Global - (+34) 91 414 89 50 | N. America - (800) 757 6543

Building Analytical Dashboards with Power BI


Create powerful visualizations and analyze your data like a pro.

Most demanded class

Sign up early


Award Winning, World-Class Instructors

24 hours

3-day class


View map

November 5 – 7, 2019

$2,950 $1,950


Power BI is an innovative solution helping businesses make better decisions.

The Power BI platform allows organizations to obtain data from many sources, integrate and convert information to be shared through excellent visualization and collaboration tools.

Take action on data insights!

Reserve your seat
or request more information

Course Benefits

Does our organization need insights to make decisions at every level, in real time?
With Power BI you can gather and analyze data from hundreds of data sources: on-premises data sources, big data, streaming data, cloud services…

Are you already using Power BI but you need to get the most out of it?
In this course you will learn how to create and share powerful data visualizations with your team, using practical examples that you can implement from day 1.

Are you leveraging implementing Power BI in your organization?
Microsoft Power BI is the best data visualization tool out there, and we will show you all the necessary ingredients for a successful implementation.

Course Coverage

By the end of this course, you will have practiced how to Get Data from various sources, Model your data, Visualize your data, and Share your data with Power BI Desktop and the Power BI Service.

The training objective of the course is to provide students with the necessary knowledge for data integration and advanced analysis using Power BI.  Practical use cases are incorporated into the sessions allowing application into real-world situations.

  • Import data from heterogeneous sources including Excel, Access, ERP systems, websites, online services, social media, and more.
  • Design, refine and optimize data models
  • Create analytical calculations using Data Analysis eXpressions (DAX)
  • Create interactive reports and dashboards
  • Share insights within the organization using content packs and app workspaces
  • Leverage content on various mobile platforms


This course is intended for experienced business and data analysts with prior experience data visualization tools like Tableau, QlikView and Excel with PowerPivot & Power View and desire to apply similar approaches to Power BI.



Exposure to Power BI Desktop and Power BI Service ( is recommended and prior work in Power BI is strongly encouraged.

Excellent teacher, he exceeded my expectations, his greatest strength is the ability to provide examples of the real world

Allan McDowell

BI specialist

Course outline


Day 1

Introduction to the Power BI ecosystem

· Power BI Service at

· Power BI Desktop

· Power BI Mobile

· Power BI Embedded

· Power BI Report Server

Introduction to Power BI Desktop

· Key features and navigation

· Core activities with Get Data, Model and Visualize

Modeling: Introduction-Fundamentals of Data Modeling

· Data types

· Model design

· Modeling time

· Practical cases

Get Data: Gathering and Cleansing

· Query Editor

· Data Sources

· Querying data

· Other features

· Practical cases

Modeling: Improving the Data Model

· Data model key components

Modeling: Data Analysis eXpressions (DAX) and Quick Measures

· What is DAX and why we need it

· Calculated columns and measures

· DAX functions introduction

· Practical cases

Visualize: Introduction to Visuals and Chart Interaction

· Introduction to Power BI Reports

· Visual elements

· Creating reports

· Practical cases

Visualize: Conditional Formatting Options

· Conditional formatting with the default visuals

· Custom visuals tailor-made for conditional formatting


Lab 1: Obtaining and Refining Data

Students will work with the Power BI Desktop to perform basic steps in creating queries using the Query Editor and create their first Data Model.

Lab 2: Refinements and Improvements on the Data Model

Students will enhance the Power BI Desktop Data Model by validating data types, formats and navigation paths through the data.

Lab 3: Incorporating Basic DAX Expressions

Students will create their first Data Analysis eXpressions (DAX) into the Power BI Desktop Data Model including how to define standard calculations and expressions.

Lab 4: Create a Simple Report

Students will use Power BI Desktop to build common visualizations off the Data Model including charts, graphs, slicers and maps.

Day 2

Share: Publishing to the Power BI Service

· Publishing Reports

· Building Dashboards

· Sharing Dashboards

Share: Creating and Managing Workspaces

· Personal workspace

· Group workspace

Modeling: Connecting On-Premises Data to the Power BI Service

· Power BI Gateway overview

· Gateway setup and configuration

Get Data: Advanced Data Cleansing Features

· Advanced Transformations

· Using Parameters

· M Language Introduction

· Incorporating R datasets

Modeling: Intermediate DAX Calculations

· Overview of different types of functions

· Aggregation and relationship functions

· Implementing calculations, measures, and KPIs

· Practical cases

Get Data: Working with Data for Power BI Report Server

· Extending on-premise capabilities

· User Experiences

· Moving assets to SSAS

· Data Connectivity

Share: Deploying Reports to Power BI Report Server

· Deploying reports to Power BI Report Server

· Editing and content linking

· Security and Sharing

· Developer resources


Lab 5: Building Better Visualizations

Students will use basic features offered in the Power BI Service ( to publish reports, create quick insights, share reports, create dashboards and ask questions against the data.

Lab 6: New Ways to Modify Reports

Students will use Power BI Desktop to modify the Data Model with pivots and leverage the M language and incorporate report filters.

Lab 7: Intermediate DAX Calculations

Students will create several new measures using Data Analysis eXpressions (DAX) in the Power BI Desktop Data Model and leverage calculations in new visuals and Key Performance Indicators (KPIs).

Lab 8: Working with Power BI Report Server

Students will publish a report from Power BI Desktop to Power BI Report Server and work with features like the Web Portal including report editing, data refresh and data source connections.

Day 3

Visualize: Custom Visuals and Custom Data Sources

· The default visuals that come with Power BI Desktop are very useful, but there are many custom visuals available to help fit specific situations.

Visualize: Advanced Visualization Techniques

· New analytical features

Visualize: Advanced Visuals with R

· Bringing Data Science into your Power BI reports

Visualize: Designing for Mobility

· Design considerations

· Features & options

Share: Power BI Service Administration

· The need to share

· The Power BI Service

· Practical cases


Lab 9: Custom Visualizations

Students will discover advanced levels of customization in the Power BI Desktop with custom visuals from the custom visuals Marketplace, R visuals, custom themes and mobile layouts.

Lab 10: Power BI Service and Power BI Report Server better together

Students will use Power BI Report Builder to create a report and publish to Power BI Report Server, create KPIs, apply Row Level Security and share content to the Power BI Service.

Meet the Instructor

Patrick Dubois

Patrick is an experienced Data Specialist who has been guiding clients since 2001 in better understanding and working with their data. His project experiences have revolved around moving and integrating data into new environments, system/process redesigns, data and business rule validation, as well as full implementation of business intelligence solutions at both large and small clients. To that end, Patrick has worked with a variety of tools, but he specializes within the Microsoft BI Suite of Products (SQL Server, SSIS, SSAS, SSRS, Power BI).


Training facility

MicroTek Chicago Training & Meeting Rooms
230 West Monroe Street, Suite 900, Chicago, Illinois 60606