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

Building Analytical Dashboards with Power BI

Highly demanded class

Sign up early

24 hours

3-day class


World-class instructors


Hands-on experience


July 9 – 11




July 9 – 11




What will I learn?

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
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.


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”

“Great job. Easy to understand and integrated good real-world examples. I am blown away by the depth of knowledge and passion. I am inspired by him!”

“It was great! Lots of good information that we can immediately implement”

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

Brett Tomson

Brett is Principal Architect, Managing Consultant and Mentor for multiple high visibility projects delivering a holistic view of critical business information and processes covering a variety of vertical markets.

Brett is also Chapter Leader for the Triangle SQL Server User Group (TriPASS) and a published author of numerous articles and books


New Horizons Computer Learning Center of Tampa Bay
5402 W Laurel St. Building 1A. Suite 106
Tampa, FL. 33607

New Horizons Learning Group