MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model

Download Excel Zipped Folder with all files (including pdf notes): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/MECS04DownloadFiles.zip Free YouTube Excel & Data Analysis class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3 Download Power BI Desktop: https://www.microsoft.com/en-us/download/details.aspx?id=58494 In this video learn about Power BI Desktop and how to build Interactive Dashboards. Learn how to import an Excel Power Pivot Data Model into Power BI Desktop. Topics: 1. (00:00) Introduction 2. (00:23) Look at last videos Power Pivot Data Model and look at the Interactive Dashboard that we will create with Power BI Desktop in this video. 3. (01:42) Download Power BI Desktop 4. (01:54) Files used in this video 5. (02:12) Open Power BI Desktop 6. (03:01) Import Power Pivot Data Model into Power BI Desktop. Example 9. 7. (03:51)Tour of Power BI Desktop 8. (06:15) Open Power Query and delete unwanted queries from import process 9. (08:13) Building Interactive Visuals: Line Chart 10. (08:58) Drill down feature in charts 11. (10:30) Format visual area in Power BI Desktop. Turn off concatenate labels in X-axis. Add Data Labels. 12. (11:03) The AMAZING Tool Tips in Power BI (Not in Excel): Add Measures to hovering tool tips for ivsuals. 13. (11:53) Change Visual Title 14. (12:09) Matrix Visual (Like a PivotTable) 15. (13:17) Column Chart 16. (14:04) Edit Interactions: to control how visuals interact 17. (14:49) Filter Pane to filter visual, page or entire file. 18. (15:55) Add Slicer 19. (16:22) Add Card that highlights Measure filter amount to dashboard/report 20. (16:39) Add Dashboard/Report Title 21. (17:14) New Dashboard/Report with Matrix & Stacked Bar visuals 22. (18:06) Increase global font size for Matrix 23. (18:43) Stacked Bar/Chart Vs. Clustered Bar/Chart 24. (21:53) Change interactions between Stacked Bar Charts 25. (23:07) Insert a picture into Dashboard/Report. 26. (23:52) Use Themes to create a consistent formatting style to entire Dashboard/Report. 27. (24:26) Summary 28. (24:51) Next Video 29. (25:06) Closing Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese. Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish. #excel #excelisfun #groupby #dataanalysis #Sort #filter #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #powerbi #powerbidashboard #powerbidesktop #powerpivot #dashboard #dashbord