The Perfect Data Model for Power BI. Creating a STAR SCHEMA from Flat File, Excel source in Power BI

This video will take a simple FLAT FILE source, so just a simple, single table from Excel (or a CSV file) and transform this completely into the PERFECT star schema model, ideal for consumption by Power BI. Power BI loves a star schema and works most efficiently when utilising this type of model. You will have better performance, reduced storage, and increased happiness from your users. We will utilise the power query in PowerBI, duplicate sources to create individual dimensions for Customer, Product, Location, Date and more. We will go through some of the common questions around this type of modelling and why we should adopt it.