Dashboard In A Day (DIAD) Episode 1: data setup

Episode 1 in a series about how to use Microsoft’s Dashboard In A Day (DIAD) dataset to understand the basics of working with Power BI. See the links below the video to download the dataset.

In this episode we take a look at the tables in the data and work out the operations that we will need to apply in Power Query to get the data ready to be loaded into the Power BI data model.

Links

Microsoft’s page about the Dashboard In A Day (DIAD) course: https://powerbi.microsoft.com/en-us/instructor-led-training/#section_diad
Download the content for the course including the dataset here: https://aka.ms/diad_student
Further details about the course on the OP-Training website: https://op-training.co.uk/diad-landing-page/