Table of contents
- Introduction
- 1: Getting started with Power BI
- 2: Importing and transforming data using Power Query Editor
- Learning objectives
- 2.1 Navigate the Power Query Editor
- 2.2 Explore data sources
- 2.3 Load data from a website
- 2.4 Load data from files
- 2.5 Load a folder of data
- 2.6 Explore data source settings
- 2.7 Rename columns and set data types
- 2.8 Reduce rows
- 2.9 Manage columns
- 2.10 Append queries
- 2.11 Add columns
- 2.12 Merge queries
- 2.13 Transform and cleanse data
- 2.14 Organize and manage queries
- 3: Building a Data Model to support self-service reporting
- Learning objectives
- 3.1 Navigate the Power BI Desktop
- 3.2 Introduce Dimensional Modeling
- 3.3 Create relationships and manage settings
- 3.4 Modify column properties
- 3.5 Modify column formatting
- 3.6 Create hierarchies
- 3.7 Introduce DAX
- 3.8 Create basic DAX expressions
- 3.9 Understand contexts
- 3.10 Introduce time intelligence
- 3.11 Introduce CALCULATE
- 3.12 Introduce quick measures
- 3.13 Discuss data model cleanup
- 4: Developing reports and visualizations using the Power BI Desktop
- Learning objectives
- 4.1 Navigate the Power BI Desktop report view
- 4.2 Use a page background and theme
- 4.3 Create a clustered column chart
- 4.4 Create a funnel chart
- 4.5 Explore drill through
- 4.6 Create a line chart
- 4.7 Explore drill down
- 4.8 Create a card and KPI visualization
- 4.9 Create slicers
- 4.10 Explore the filter pane
- 4.11 Edit interactions between visuals
- 4.12 Create bookmarks
- 4.13 Explore the structure of a pbix file
- 5: Enhancing the experience in the Power BI Service
- 6: Securing, Sharing and Collaborating using the Power BI Service
- Summary
Introduction
Introduction