4 docs tagged with "Data Modeling"

Dimensional modeling is the standard technique for structuring data warehouses for analytical queries. It organizes data into fact tables and dimension tables to optimize read performance and business usability.

Fact tables are the core of any dimensional model. Their design directly impacts query performance, storage efficiency, and analytical flexibility.

The Power BI semantic model (formerly called a dataset) is the layer between raw data and reports. A well-designed semantic model determines report performance, metric consistency, and maintainability.

Slowly Changing Dimensions (SCD) handle the problem of dimension attributes that change over time. The chosen SCD type determines how historical values are preserved or overwritten.