Data Modelling: From single table to star schema

There is a broad range of skills you can choose to learn to enhance your report building capabilities in Power BI. These include DAX, M or even R and Python. Whilst these are all useful techniques, without appropriate data modelling you are likely to run into difficulties and challenges. These challenges may present themselves early on or latter down the line after you have deployed your solution.

We start with an overview of data modelling, looking at what data modelling is and why it is so important. We will then dive into 3 specific elements focusing on: 1) Star Schema Facts and Dimensions, 2) Role Playing Dimensions, and 3) Degenerate Dimensions.

Files can be downloaded from https://tinyurl.com/ych6n5p8