SkillData AnalystData Engineer
Library · concept
Data modelling
Design tables that make analysis fast, correct and easy: facts, dimensions, grain and history.
Data modelling was named in 72% of the Data Engineer and 26% of the Data Analyst job descriptions we read. Analysts meet it as a Power BI or Tableau model; engineers build it in the warehouse.
Examples build a real star schema from the UCI Online Retail II data in DuckDB.
Beginner lessons for Data modelling are being written.
- 1BeginnerRetail star schema in SQL
- 2IntermediateE-commerce star schema and DAX dashboard
- 3IntermediateMarketplace warehouse with history
- 4IntermediateTaxi analytics marts with dbt
- 5AdvancedIncremental warehouse loads with late and corrected data
- 6AdvancedSecure self-serve sales model for 27 regional managers