Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Files: ZippedTextFiles: https://excelisfun.net/files/1659TextFiles.zip Finished Power BI Desktop File: https://excelisfun.net/files/CrossTabReportEMT1659.pbix Download Power BI Desktop : Microsoft Download Page: https://www.microsoft.com/en-us/download/details.aspx?id=45331 • When you want to update each month, you have to re-download and re-install. Microsoft Windows Store: https://powerbi.microsoft.com/en-us/desktop/ • This download will automatically update each month. In this video learn how to build a Data Model in Power BI Desktop to create a Cross Tab Report with six conditions. Learn how to use Power Query to import Text Data From a Folder and how to use Power Query to make a Date Table. Learn how to create a DAX Measure to count hours less than zero using the COUNTROWS and CALCULATE Function. Learn how to make a report with the Martix Visualtization and how to publish the report top powerbi.com. Topics: 1. (00:01) Introduction. 2. (00:29) Download Power BI Desktop 3. (00:45) Data we need to import 4. (01:05) Open and Save Power BI Desktop 5. (01:19) look back to last three videos and compare to this video 6. (01:47) Power Query to Import Text Data From Folder. 7. (04:25) Create Data Table using Power Query. Power Query M Code to build a Date Table. 8. (10:47) Build Relationship between Date Table and Fact Table. 9. (11:20) Sort Month Name Column. 10. (11:36) Hide Month Number in Report View. 11. (11:43) Matrix Visualization Report. 12. (13:06) DAX Function COUNTROWS. 13. (14:01) Learn how Filter Context works. 14. (14:54) DAX Function CALCULATE to change the Filter Context. 15. (16:21) Publish Report to Power BI Online so it can be viewed on any device. 16. (17:11) Summary of the tasks in video. 17. (17:34) Change Folder Location. 18. (18:07) Summary and End Video Links.