About the course

Introducing Power BI

• Understanding Microsoft Business Analytics Platform

• Understanding organizational BI

• Understanding self-service BI

• Choosing a design environment

• Introducing Power BI

• Understanding PowerPivot models

• Sharing and collaboration options Using other Excel features

• Understanding the BI continuum

Introducing PowerPivot

• PowerPivot overview

• Understanding corporate and personal BI

• Understanding PowerPivot models

• Introducing PowerPivot for Excel

• Lab 1: Creating a basic PowerPivot model

• Introducing PowerPivot for SharePoint

• PowerPivot usage scenarios and limitations

• Lab 2: Sharing PowerPivot models

Working with Data

• Importing from relational data sources

• Importing from multi-dimensional data sources

• Lab 1: Importing data from databases

• Importing flat files

• Importing from Excel

• Copying and pasting data

• Importing from reports and data feeds

• Lab 2: Importing from other data sources

Enhancing the Data Model

• Understanding PowerPivot data types

• Performing column operations

• Lab 1: Working with columns

• Understanding table relationships

• Understanding data refresh

• Lab 2: Working with relationships

Analyzing Data

• Understanding PowerPivot data analysis

• Understanding PivotTable and PivotChart

• Understanding PowerPivot Field List

• Lab 1: Creating PivotTable and PivotChart reports

• Understanding slicers

• Handling metadata issue and changes

• Using other Excel features

• Lab 2: Implementing dashboards

• Working with dates, hierarchies, and perspectives

• Lab 3: Implementing end-user features

Data Analysis Expressions (DAX)

• Understanding Data Analysis Expressions

• Understanding row and filter context

• Understanding calculated columns

• Lab 1: Implementing calculated columns

• Understanding measures

Publishing and Managing PowerPivot Models

• Understanding PowerPivot for SharePoint

• Publishing to SharePoint

• Viewing published models

• Lab 1: Publishing models and authoring reports

• Managing data refresh

• Understanding PowerPivot Management Dashboard

• Lab 2: Managing PowerPivot models

Importing Data with Power Query

• Introducing Power Query

• Understanding Power Query elements

• Viewing published models

• Lab 1: Importing and transforming data

• Understanding query sharing

• Discovering queries

• Demo: Sharing and discovering queries

Analyzing Data with Power View and Power Map

• Introducing Power View

• Understanding Power View visualizations

• Understanding Power View filtering options

• Lab 1: Implementing Power View reports

• Introducing Power Map

• Preparing geospatial data

• Understanding Power Map visualizations

• Lab 2: Geospatial reporting with Power Map