home > training > PBICRB: Data Analysis using Power BI Desktop – Level 1 – Report Builder

PBICRB: Data Analysis using Power BI Desktop – Level 1 – Report Builder

$990

  • 2 Days

Dates Available
Class Time
Guaranteed
to Run
Attend
Live Online
Rewatch with
Replay™
 
Oct 10 - Oct 11
7AM - 3PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Nov 7 - Nov 8
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Dec 5 - Dec 6
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
x
Course:
  • This field is for validation purposes and should be left unchanged.

Course Description

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

Outline

Lesson 1: Introducing Power BI

  • Power BI as Part of Power Apps
  • What is Power BI
  • Power BI Overview

 

Lesson 2: Understanding Power BI Data Models

  • Understanding Data Terminology
  • Data Normalization
  • Understanding Tables & Relationships
  • Diagnosing Data Models, Data Model Schemas

 

Lesson 3: Defining a Report

  • Power BI Reports
  • Report Objectives
  • Data-Driven Narrative

 

Lesson 4: Building Power BI Desktop Reports

  • Working with managed data
  • Creating Visuals
  • Formatting and Organizing Visuals
  • Sharing

 

Lesson 5: Report Actions & Filtering

  • Drill-Down, Drill-Through and other Data Actions
  • Filters
  • Visual Interactions
  • Bookmarks and Buttons

 

Lesson 6: Report Data

  • Data Queries vs Data Models
  • Modifying Report Data

 

Lesson 7: Data Model Functions

  • Calculated Columns
  • What is DAX?
  • Row Level Security

 

Lesson 8: Connecting to Power BI Service

  • Power BI Service Interface
  • Publish PBIX Reports and Get Data
  • Creating your own Workspace
  • Connecting to Data Sources
  • Refreshing Power BI Data
  • Power BI service Report Interface Components

 

Lesson 9: Building Power BI Service Dashboards

  • Building Dashboards
  • Organizing Dashboard Elements

 

Lesson 10: Service Analytics Features

  • Dashboard Q & A
  • Quick Insights

 

Lesson 11: Sharing Reports & Dashboards

  • Sharing Content
  • Managing App Workspaces & Adding Content

 

Lesson 12: Bonus Activity – Putting it all Together

  • Power BI Roles
Prerequisites

Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.