Preparing Dashboard Data - March 2021
Preparing Dashboard Data Modules Module 1: Introduction to the Power BI Environment Module 2: Preparing Dashboard Data Module 3: Creating Interactive Visualizations Module 4: Power BI Finishing Touches Module 5: Power BI Advanced Data Modelling Example Learning Outcomes Import data into Power BI Desktop from a wide variety of data sources How to join different data sets together, even if they come from different files, databases or other sources Clean and transform your data so it’s ready for use with Power BI Delve into “Get Data” and an introduction to understanding “M” code (Power Query language) Turn short, wide data tables into long, tall tables and why this is so useful for Power BI Join multiple data tables together and understanding relationships Create efficient data models: merging, appending and structuring your datasets to create the optimal structure Apply your Power Query skills to Excel and when to choose one over the other Use different techniques for creating and utili...