---

Power BI Desktop Essentials

---

Prerequisites

This course assumes a proficient level in the use of Excel. Learners attending this training must know how to write complex formulas and use Pivot table in Excel.

Course Description

This course aims to provide the essential capabilities of Power BI. Learners will transform data, use DAX functions, and create visualizations. Learners will be able to acquire the fundamental skills required to use Power BI.

Course Duration

16 hours

Course Topics

Introduction

An Introduction to Power BI
What is Power BI?
The Building Blocks of Power BI
The Power BI Desktop Interface
Important Information about Power BI Updates the Power BI Web App

Working with Power BI Desktop Files

Opening Files
Saving Files
Creating a New File
Publishing to the Power BI Web App

Connecting to Data Sources with Power BI Desktop 

Connecting to an Excel Workbook
Connecting to an Access Database
Viewing All Connection Options
Creating a Manual Dataset
Managing Data Sources

Transforming and Sanitizing Data

Using Data View
Cleaning Irregularly Formatted Data
Managing Columns
Sorting Table Data

Using the Query Editor

Opening the Query Editor
The Query Editor Interface
Using the Query Settings Pane
Using Merge Queries
Using Append Queries

Data Modeling

What is DAX?
Creating a New Table
Creating a New Calculated Column
Creating a New Measure

Managing Relationships

Using the Relationships View
Creating Relationships
Editing Relationships
Deleting Relationships
Using the Manage Relationships Dialog

Creating a Report with Visualizations

Using the Visualizations Pane
Using the Fields Pane
Creating a Visualization
Interacting with Visualizations
Changing the Visualization Type
Moving and Resizing Visualizations

Doing More with Visualizations 

Formatting Visualizations
Viewing Visualization Data
Using Focus Mode and Spotlight
Removing a Visualization

Managing Report Pages

Navigating Through Pages
Showing and Hiding Pages
Adding Pages
Deleting Pages
Renaming Pages
Changing Page Order

Changing Report View Options 

Setting Page View Options
Customizing Your View
Using Phone vs. Desktop Layout

Working with Visualizations

Understanding Drill through Options
Changing Category and Summarization Options
Arranging Visualizations
Editing Interactions
About Custom Visualizations

Adding Static Objects to a Report

Inserting Pictures
Inserting Text Boxes
Inserting Shapes
Working with Static Objects

Matrixes, Tables, and Charts

Creating a Table
Creating a Matrix
Overview of Chart Types
Creating Charts

Maps, Cards, Gauges, and KPIs

Creating a Map
Creating a Card
Creating a Gauge
Creating a KPI

Slicers 

Creating a Slicer
Using Slicers
Customizing Slicer Display
Changing Slicer Mode
Changing Slicer Orientation