Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

Data Modelling

.

Introduction


Creating a great data model is one of the most important tasks that a data analyst can perform in Microsoft Power BI. The following image is an example data model. The boxes contain tables of data, where each line item within the box is a column.

The lines that connect the boxes represent relationships between the tables. These relationships can be complex, even in such a simplistic model. The data model can become easily disorganised, and the total table count in the model can gradually increase. Keeping your data model simple, comprehensive, and accurate requires constant effort.

Star Schemas


You can design a star schema to simplify your data. It’s not the only way to simplify your data, but it is a popular method; therefore, every Power BI data analyst should understand it. In a star schema, each table within your dataset is defined as a dimension or a fact table, as shown in the following visual.

Fact tables
Fact tables contain observational or event data values: sales orders, product counts, prices, transactional dates and times, and quantities.

Dimension Tables
Dimension tables contain the details about the data in fact tables: products, locations, employees, and order types.

Considering this information about fact tables and dimension tables, you might wonder how you can build this visual in Power BI.

The pertinent data resides in two tables, Employee and Sales, as shown in the following data model. Because the Sales table contains the sales order values, which can be aggregated, it is considered a fact table.

01-star-schema-example-01-ss

This article is from the free online

Microsoft Power BI: Advanced Data Analysis and Visualisation

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now