Power BI for the Cloud - Level 1 - Report Builder

This is the first course in the Power BI for the Cloud training series. This course lays the foundation for Power BI for the Cloud Report Builders. Power BI Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created by Power BI Data Model Designers. This course covers the use of both the Power BI Desktop application as well as the Power BI Service.

Course Outline

Lesson 1 : Introducing the Power BI Service

  • What Is the Power BI Service?

  • Power BI Service Key Features

  • The Self-Service BI Model

  • Power BI Reports & Dashboards


Lesson 2 : Defining a Report

  • What is a Power BI Report?

  • Defining a Report

  • Data-Driven Storytelling


Lesson 3 : Building Power BI Desktop Reports

  • Understanding the Design Interface

  • Creating Reports

  • Report Visualizations

  • Formatting Visualizations

  • Report Final Touches


Lesson 4 : Report Actions and Filtering

  • Visual Sorting

  • Creating Slicers

  • Drill-down, Highlighting, & Data Actions

  • Visual, Report, & Page Filters

  • Visual Interactions


Lesson 5 : Understanding Data Models

  • Understanding Data Terminology

  • Understanding Tables

  • Understanding Relationships

  • Diagnosing Data Models

  • Data Model Schemas


Lesson 6 : Gathering Report Data

  • Data Queries vs Data Models

  • Viewing & Refreshing a Data Source

  • Modifying Report Data


Lesson 7 : Data Model Functions

  • Creating Calculated Columns

  • What is DAX?

  • Understanding DAX Functions

  • Date Hierarchies


Lesson 8 : Connecting to the Power BI Service

  • Power BI Service Interface

  • Connecting to a Data Source

  • Uploading & Updating PBIX Reports

  • Power BI Service Report Interface

  • Managing Power BI Service Datasets


Lesson 9 : Building Power BI Service Dashboards

  • Creating Dashboards using Existing Reports

  • Building Dashboards

  • Organizing Dashboard Elements


Lesson 10 : Using Q & A (Cortana)

  • Understanding Q & A

  • Modifying Q & A Results

  • Pinning Q & A results to a Dashboard


Lesson 11 : Sharing Reports & Dashboards

  • Sharing with Co-Workers

  • Managing Power BI Content

  • Using Groups

  • Creating Content Packs


Lesson 12 : Appendix A: Power BI Roles

  • Adding Roles

  • Determining filters

  • Publishing Roles

Audience

Prerequisite(s):
Basic reporting knowledge, basic understanding of data

Available Course Dates

08/21/2017 11:00 am - 08/22/2017 7:00 pm
10/16/2017 11:00 am - 10/17/2017 7:00 pm
12/04/2017 11:00 am - 12/05/2017 7:00 pm
Click here to sign up for this class