Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
4.3.2. Data Modeling Concepts
š” First Principle: A Power BI data model consists of tables, relationships, and calculations (DAX) designed to enable dynamic analysis and high-performance visualizations.
- Dimensions: Descriptive attributes (who, what, where, when) used to aggregate measures (filter and group data).
- Facts: Numeric, measurable data (sales amount, quantity) stored in central fact tables.
- Hierarchy: A structure within a dimension that allows users to drill up and drill down (e.g., Year ā Quarter ā Month ā Day).
- Relationship: Links between tables (typically 1:many) based on matching columns (keys).