Power BI Course Syllabus 5hrs 30min
Session 1: Quick Start Power BI Service0:31:40
| 1.01 | Get Power BI Tools | 0:03:08 |
| 1.02 | Introduction to Tools and Terminology | 0:04:19 |
| 1.03 | Dashboard in Minutes | 0:09:51 |
| 1.04 | Refreshing Power BI Service Data | 0:02:59 |
| 1.05 | Interacting with your Dashboards | 0:07:22 |
| 1.06 | Sharing Dashboards and Reports | 0:04:01 |
Session 2: Getting and Transforming Data with Power BI Desktop0:23:21
| 2.01 | Introduction to Power BI Desktop | 0:08:16 |
| 2.02 | Getting Data: Excel vs Power BI Desktop & Service | 0:05:14 |
| 2.03 | Naming for Q&A | 0:03:46 |
| 2.04 | DirectQuery vs Import Data | 0:03:44 |
| 2.05 | Recap and What's Next | 0:02:21 |
Session 3: Modeling with Power BI0:42:34
| 3.01 | Introduction to Modeling | 0:01:17 |
| 3.02 | Setup and Manage Relationships | 0:06:15 |
| 3.03 | Cardinality and Cross Filtering | 0:10:04 |
| 3.04 | Default Summarization & Sort by | 0:06:04 |
| 3.05 | Creating Calculated Columns | 0:03:13 |
| 3.06 | Creating Measures & Quick Measures | 0:13:39 |
| 3.07 | Recap and What's Next | 0:02:02 |
Session 4: Power BI Desktop Visualisations2:06:16
| 4.01 | Creating Visualisations | 0:05:55 |
| 4.02 | Color & Conditional Formatting | 0:07:39 |
| 4.03 | Setting Sort Order | 0:03:57 |
| 4.04 | Scatter & Bubble Charts & Play Axis | 0:04:03 |
| 4.05 | Slicers | 0:12:08 |
| 4.06 | Tooltips | 0:03:47 |
| 4.07 | Cross Filtering and Highlighting | 0:03:32 |
| 4.08 | Visual, Page and Report Level Filters | 0:08:10 |
| 4.09 | Drill Down/Up | 0:06:16 |
| 4.10 | Hierarchies | 0:02:48 |
| 4.11 | Constant Lines | 0:05:14 |
| 4.12 | Tables, Matrices & Table Conditional Formatting | 0:10:30 |
| 4.13 | KPI's, Cards & Gauges | 0:08:57 |
| 4.14 | Map Visualisations | 0:05:44 |
| 4.15 | Custom Visuals | 0:03:13 |
| 4.16 | Managing and Arranging | 0:04:06 |
| 4.17 | Drillthrough | 0:04:47 |
| 4.18 | Custom Report Themes | 0:08:29 |
| 4.19 | Grouping and Binning | 0:03:49 |
| 4.20 | Bookmarks & Buttons | 0:08:54 |
| 4.21 | Decomposition Tree | 0:07:16 |
| 4.z | Recap and What's Next | 0:02:57 |
Session 5: Power BI Service Visualisation Tools0:22:54
| 5.01 | Introduction to the Power BI Service | 0:04:24 |
| 5.02 | Standalone Tiles | 0:04:32 |
| 5.03 | Data Driven Alerts (Power BI Pro/Premium) | 0:05:11 |
| 5.04 | Quick and Related Insights | 0:04:06 |
| 5.05 | Custom Q&A | 0:04:41 |
Session 6: Publishing and Sharing0:47:44
| 6.01 | Sharing Options Overview | 0:04:16 |
| 6.02 | Publish from Power BI Desktop | 0:03:53 |
| 6.03 | Publish Reports to Web | 0:05:26 |
| 6.04 | Sharing Reports & Dashboards (Power BI Pro/Premium) | 0:04:01 |
| 6.05 | Workspaces (Power BI Pro/Premium) | 0:03:56 |
| 6.06 | Apps (Power BI Pro/Premium) | 0:06:39 |
| 6.07 | Printing, PDFs and Exporting to PowerPoint | 0:04:20 |
| 6.08 | Row Level Security (Power BI Pro) | 0:05:17 |
| 6.09 | Export Data from a Visualisation | 0:03:38 |
| 6.10 | Publishing for Mobile Apps | 0:03:04 |
| 6.z | Sharing Options Summary | 0:03:14 |
Session 7: Refreshing Datasets0:15:48
| 7.01 | Understanding Data Refresh | 0:04:18 |
| 7.02 | Personal Gateway (Power BI Pro and 64-bit Windows) | 0:07:08 |
| 7.03 | Replacing a Dataset | 0:01:57 |
| 7.04 | Troubleshooting Refreshing | 0:02:25 |
Session 8: Power BI and Excel Together0:18:01
| 8.01 | Options for Publishing from Excel | 0:02:34 |
| 8.02 | Import Excel Power Query & Power Pivot Models | 0:04:08 |
| 8.03 | Analyze in Excel (Power BI Pro or Premium) | 0:03:44 |
| 8.04 | Excel Publish: Upload and Export to Power BI | 0:05:05 |
| 8.05 | Sharing Published Excel Dashboards (Power BI Pro or Premium) | 0:02:30 |