top of page
Profile
Join date: Feb 7, 2022
Posts (22)
Nov 4, 2025 ∙ 4 min
Granularity
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 Order Status...
12
0
2
Oct 26, 2025 ∙ 4 min
Keys - Primary, Surrogate, Natural and Foreign
Keys are a core component of star schema modelling; relationships between tables are built using the keys. This article covers: The main...
44
0
1
Oct 19, 2025 ∙ 4 min
Non-Functional Requirements
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-Functional...
10
0

Chris Barber
Admin
More actions
bottom of page

