Introduction.
Importance of data in modern business intelligence
In modern business, businesses correct alot of data from their daily operations, this data is the one that is analysed to turn it into actionable insights.
Power BI
Power BI is a tool created by Microsoft to turn raw data into interactive insights. Think of it as a supercharged Excel, but specifically designed for creating stunning reports and dashboards that anyone in your organization can use. The power of Power BI lies in its ability to pull data from many sources, clean it, analyze it, and then create visuals that are easy to understand and actionable.
Power BI reports start with great data modelling, even before a single visual is created. A strong model improves performance, ensures accurate reporting and provides a scalable foundation for analytics. In this article, we explore fact and dimension tables, star and snowflake schemas, relationships and the importance of good modelling in Power BI
Data modelling in power BI
Data modelling refers to the process of structuring data into tables, defining relationships between them, and optimizing them for analytical queries. In power BI, the data model sits at the heart of the solution, powering calculations written in DAX and driving how filters and aggregations behave across visuals. Power BI models are optimized for fast read and aggregation operations.
Poor medelling leads to slow, inaccurate, or confusing reports.
Schemas
A schema represents a logical grouping of tables that are related to each other. It acts as a blueprint defining how fact tables (metrics) and dimension tables (attributes) connect to enable efficient reporting, analysis and data modelling.
Star Schema
A star schema consists of a central fact table that stores quantitative data and multiple dimension tables that provide descriptive attributes. The layout resembles a star, with the fact table at the centre and dimension tables outward.
The fact table Sales is in the center. It holds the numeric data you want to analyze, like sales or profits. Connected to it are dimension tables with descriptive details, such as product names, customer location or dates
Fact Tables
Fact tables store observations or events and can be sales orders, stock balances, exchange rates, temperatures and more. A fact table contains dimension key columns that relate to dimension tables and numeric measure columns.
Dimension tables contain a relatively small number of rows, whereas fact tables contain a large number of rows.
Snowflake Schema
The snowflake is a schema that consists of one fact table that is connected to many dimension tables, which are connected to other dimension tables.
Relationships in power BI
Relationships define how tables connect and how filters propagate through the model.
Types of relationships include
One to one Relationship: Each row in Table A relates to exactly one row in Table B, and vice versa.
Example: A Person table and a Passport table, where each person has only one passport.
One to many: A row in Table A can relate to many rows in Table B, but each row in Table B relates to only one row in Table A.
Example: A Customer table and an Orders table, where one customer can place many orders.
Many to many: Rows in Table A can relate to many rows in Table B, and vice versa.
Example: A Students table and a Courses table, where students can enroll in multiple courses, and courses can have multiple students.
Good data modelling in power BI Isn't about complexity, it's about clarity. A good schema with proper relationships gives you faster reports with accurate numbers.
A strong model-built around a star schema, clean fact/dimension separation and well-defined relationships leads to high performance, reliable insights, simpler DAX and long‑term scalability
Top comments (0)