Tag
Data Modelling
5 post(s) tagged with Data Modelling.
Keeping Historical Context in a Data Warehouse
How to decide whether warehouse data should show the current view, retain earlier business context, or restate history when records arrive late or require correction.
Designing a Dimensional Model That Reflects the Business
A practical guide to selecting a business process, declaring the grain, identifying dimensions and facts, and designing analytical models that support valid decisions.
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.