Power BI Desktop - Creating Interactive Visuals and Dashboards by Importing Excel Data Models - Lesson 12

This 25-minute tutorial from ExcelIsFun demonstrates how to use Power BI Desktop to build interactive dashboards and import Excel Power Pivot data models. Learn essential skills including importing data models, creating various visuals (line charts, matrices, column charts, stacked bars), utilizing drill-down features, formatting visuals, adding amazing tool tips, editing interactions between visuals, implementing filters and slicers, adding cards to highlight measure amounts, inserting titles and pictures, and applying themes for consistent formatting. Download the practice files from the provided link to follow along with the step-by-step instructions. Available with subtitles in multiple languages and audio translations in French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.

Syllabus

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:51Tour 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