Power BI Course Syllabus 5hrs 2mins
Session 1: Quick Start Power BI Service0:29:53
1.01 | Get Power BI Tools | 0:03:10 |
1.02 | Introduction to Tools and Terminology | 0:03:15 |
1.03 | Dashboard in Minutes | 0:13:16 |
1.04 | Refreshing Power BI Service Data | 0:01:56 |
1.05 | Interacting with Reports | 0:05:26 |
1.06 | Sharing Dashboards and Reports | 0:03:29 |
Session 2: Getting and Transforming Data with Power BI Desktop0:16:17
2.01 | Introduction to Power BI Desktop | 0:09:01 |
2.02 | Getting Data: Excel vs Power BI Desktop & Service | 0:05:14 |
2.03 | Naming for Q&A | 0:03:15 |
2.04 | DirectQuery vs Import Data | 0:02:34 |
2.05 | Key Takeaways and What's Next | 0:01:27 |
Session 3: Modeling with Power BI Desktop0:40:45
3.01 | Introduction to Modeling | 0:01:58 |
3.02 | Setup and Manage Relationships | 0:06:45 |
3.03 | Cardinality and Cross Filtering | 0:10:15 |
3.04 | Default Summarization & Sort by | 0:05:50 |
3.05 | Creating Calculated Columns | 0:02:41 |
3.06 | Creating Measures & Quick Measures | 0:11:56 |
3.z | Recap and What's Next | 0:01:20 |
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:19:40
5.01 | Introduction to the Power BI Service | 0:04:13 |
5.02 | Standalone Tiles | 0:04:18 |
5.03 | Data Driven Alerts (Power BI Pro/Premium) | 0:04:07 |
5.04 | Quick and Related Insights | 0:02:47 |
5.05 | Custom Q&A | 0:04:15 |
Session 6: Publishing and Sharing0:40:21
6.01 | Sharing Options and Publishing | 0:04:41 |
6.02 | Row Level Security | 0:06:13 |
6.03 | Publish Reports to Web | 0:05:39 |
6.04 | Sharing Reports & Dashboards (Power BI Pro/Premium) | 0:03:37 |
6.05 | Creating Workspaces (Power BI Pro/Premium) | 0:02:29 |
6.06 | Apps (Power BI Pro/Premium) | 0:05:12 |
6.07 | Printing and PDFs | 0:01:43 |
6.08 | Embed in PowerPoint | 0:03:34 |
6.09 | Embed in Teams (Power BI Pro) | 0:01:55 |
6.10 | Embed in SharePoint Online | 0:02:23 |
6.11 | Publishing for Mobile Apps | 0:02:55 |
Session 7: Refreshing Datasets0:16:58
7.01 | Understanding Data Refresh | 0:06:49 |
7.02 | Personal Gateway (Power BI Pro and 64-bit Windows) | 0:06:43 |
7.03 | Replacing a Dataset | 0:01:39 |
7.04 | Lineage View | 0:01:47 |
Session 8: Power BI and Excel Together0:10:57
8.01 | Options for Publishing from Excel | 0:01:46 |
8.02 | Import Excel Power Query & Power Pivot Models | 0:03:29 |
8.03 | Work with Power BI Data in Excel (Power BI Pro or Premium) | 0:05:42 |