In this article, we discuss another core concept; that of granularity. In doing so, we'll cover: Definition of Granularity Why you should (almost always) work at the atomic level Why more Foreign Keys results in more rows Sparsity in the fact table Definition of Granularity Granularity relates to the level of detail in the fact table. It can be explained in: Business terms, i.e., Sales is explainable by Date, Product, Department, Geography, Customer, General Ledger (GL) and

Keys are a core component of star schema modelling; relationships between tables are built using the keys. This article covers: The main...

Like the Functional Requirements, the Non-Functional Requirements (NFRs) - how Power BI operates - are of critical importance. This article covers: Why you need to understand Functional and Non-Functional Requirements from the outset Generic modelling rules NFRs: Performance, Scalability, Security, Maintainability, Reliability, Extendibility and Recovery Why you need to understand Functional and Non-Functional Requirements from the outset Understanding Functional and Non-Fun

Referential integrity is a common problem encountered when data modelling which can impact understandability, performance, reliability,...