Table of contents
- Introduction8m
- 1: Getting started with Power BI29m
- 2: Importing and transforming data using Power Query Editor2h 18m
- Learning objectives4m
- 2.1 Navigate the Power Query Editor8m
- 2.2 Explore data sources6m
- 2.3 Load data from a website6m
- 2.4 Load data from files14m
- 2.5 Load a folder of data9m
- 2.6 Explore data source settings6m
- 2.7 Rename columns and set data types15m
- 2.8 Reduce rows6m
- 2.9 Manage columns5m
- 2.10 Append queries10m
- 2.11 Add columns8m
- 2.12 Merge queries10m
- 2.13 Transform and cleanse data10m
- 2.14 Organize and manage queries15m
- 3: Building a Data Model to support self-service reporting1h 53m
- Learning objectives5m
- 3.1 Navigate the Power BI Desktop5m
- 3.2 Introduce Dimensional Modeling14m
- 3.3 Create relationships and manage settings16m
- 3.4 Modify column properties5m
- 3.5 Modify column formatting2m
- 3.6 Create hierarchies8m
- 3.7 Introduce DAX3m
- 3.8 Create basic DAX expressions14m
- 3.9 Understand contexts8m
- 3.10 Introduce time intelligence12m
- 3.11 Introduce CALCULATE4m
- 3.12 Introduce quick measures7m
- 3.13 Discuss data model cleanup5m
- 4: Developing reports and visualizations using the Power BI Desktop1h 30m
- Learning objectives4m
- 4.1 Navigate the Power BI Desktop report view2m
- 4.2 Use a page background and theme3m
- 4.3 Create a clustered column chart10m
- 4.4 Create a funnel chart7m
- 4.5 Explore drill through15m
- 4.6 Create a line chart4m
- 4.7 Explore drill down5m
- 4.8 Create a card and KPI visualization9m
- 4.9 Create slicers6m
- 4.10 Explore the filter pane3m
- 4.11 Edit interactions between visuals5m
- 4.12 Create bookmarks9m
- 4.13 Explore the structure of a pbix file1m
- 5: Enhancing the experience in the Power BI Service52m
- 6: Securing, Sharing and Collaborating using the Power BI Service22m
- Summary2m
3: Building a Data Model to support self-service reporting
3.13 Discuss data model cleanup
3: Building a Data Model to support self-service reporting
3.13 Discuss data model cleanup: Study with Video Lessons, Practice Problems & Examples
Video duration:
5mPlay a video: