Tag
Data Modelling
3 post(s) tagged with Data Modelling.
Designing an Analytics-Friendly Data Model
A practical dimensional-modelling case study that transforms AdventureWorks OLTP sales data into a validated star schema for analytical reporting.
Preparing Sales Data for Analysis with SQL
A practical approach to building reusable SQL views over AdventureWorks2025, with consistent customer, order, product, geography, date, and financial definitions.
Understanding the Sales Data Landscape with SQL
A practical exploration of the AdventureWorks2025 sales schema, from customers and orders to products, territories, and the different grains that shape reliable analysis.