System designLevel 3
Pipelines and analytics
Easynot started
Mediumnot started
Hardnot started
StatusFormatCompany style
Easy
Page view counterDesignDesign25 minNightly sales rollup for a store chainDesignDesign25 minSignup funnel events for a mobile appDesignDesign30 minHourly and daily rollups for smart thermostatsDesignDesign25 minExperiment report for a pricing page testDesignDesign30 minMedium
Kubernetes metrics collectionDesignDesign35 minMulti-source order consolidationDesign · Databricks styleDatabricks styleDesignDatabricks style40 minDesign a job orchestration systemDesign · Databricks styleDatabricks styleDesignDatabricks style40 minReverse-ETL to operational platformsDesign · Salesforce styleSalesforce styleDesignSalesforce style40 minSlowly changing dimensionsDesign · Snowflake styleSnowflake styleDesignSnowflake style35 minLakehouse micro-batch compactionDesign · Databricks styleDatabricks styleDesignDatabricks style35 minIncremental extraction with deletesDesign · Databricks styleDatabricks styleDesignDatabricks style35 minScheduled remindersDesignDesign30 minFile processing pipelineDesignDesign40 minDesign a cold-storage observability systemDesign · Snowflake styleSnowflake styleDesignSnowflake style40 minShort-link redirect and analyticsDesignDesign35 minHard
Change-data-capture sync pipelineDesign · Shopify styleShopify styleDesignShopify style45 minTrending topics with velocity detectionDesign · Meta styleMeta styleDesignMeta style45 minPersonalized send-time optimizationDesign · Spotify styleSpotify styleDesignSpotify style50 minContent artwork optimization and convergenceDesign · Netflix styleNetflix styleDesignNetflix style45 minPrometheus metrics backendDesign · Uber styleUber styleDesignUber style45 minCentralized log aggregationDesignDesign40 minDistributed time-series query engineDesign · Snowflake styleSnowflake styleDesignSnowflake style45 minEdge telemetry aggregationDesignDesign40 minLatency percentile aggregationDesignDesign40 minClickstream lakehouse upsertsDesign · Databricks styleDatabricks styleDesignDatabricks style50 minPostgres CDC to warehouseDesign · Databricks styleDatabricks styleDesignDatabricks style50 minWarehouse fact-dimension joinsDesign · Snowflake styleSnowflake styleDesignSnowflake style45 min