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

This is the first course in our 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.

Retail Price: $1,200.00

Next Date: 04/24/2023

Course Days: 2


Enroll in Next Date

Request Custom Course


About this Course

This is the first course in our 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.

Prerequisites

General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required


Outline

Lesson 1 : Introducing the Power BI Service

  • What Is Power BI
  • Power BI Key Features
  • The Self-Service BI Model
  • Power BI Components

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 a Report
  • Report Visualizations
  • Formatting Visualizations
  • Report Final Touches

Lesson 4 : Report Actions and Filtering

  • Drill-down and Data Actions
  • Filters
  • Visual Interactions
  • Slicers
  • Bookmarks and Buttons

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

  • What is DAX?
  • Creating Calculated Columns
  • Basic 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

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 Content
  • App Workspaces
  • Managing App Workspaces & Adding Content

Appendix A: Power BI Roles and Security

  • Power BI Roles
Course Dates Course Times (EST) Delivery Mode GTR
4/24/2023 - 4/25/2023 10:00 AM - 6:00 PM Virtual gauranteed to run course date Enroll
5/22/2023 - 5/23/2023 10:00 AM - 6:00 PM Virtual gauranteed to run course date Enroll
6/21/2023 - 6/22/2023 10:00 AM - 6:00 PM Virtual Enroll
7/24/2023 - 7/25/2023 10:00 AM - 6:00 PM Virtual Enroll
8/28/2023 - 8/29/2023 10:00 AM - 6:00 PM Virtual Enroll