In this video, I'm doing an end to end report in Power BI.
We will be connecting to multiple data sources, transforming and cleaning data, building our data model (relationships), creating simple DAX measures, creating a report, publishing our report, scheduling our data refresh and sharing the report with end users.
If you want to practice yourself, you can find the files I used below:
https://github.com/maraftp/Data-Pears/blob/master/Sales%20data.zip
1:04 – The use case & data
2:06 – Power BI Desktop walkthrough
4:41 – Connect to data sources
7:40 – Clean & transform data
15:24 – Connecting to multiple files in a folder
17:16 – More data cleaning
18:30 – Creating relationships
23:24 – Creating a calendar table with DAX
25:38 – DAX
27:15 – Building a report
37:40 – Publish your report
40:17 – Schedule data refresh
41:39 – Sharing your report