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

Building Analytical Dashboards with Power BI

BI-PWRBI17-301-EN

Create powerful visualizations and analyze your data like a pro.

Most demanded class

Sign up early

Instructor-led

Award Winning, World-Class Instructors

24 hours

3-day class

Philadelphia

TBD

$2,950

r

Early Bird

discounts available

 

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!

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

Audience

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.

 

Requirements

Exposure to Power BI Desktop and Power BI Service (powerbi.com) 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 PowerBI.com

· 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 (powerbi.com) 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 our Instructors

 Paco González

Paco, a Microsoft Data Platform MVP and SolidQ North America Managing Director, is the PASS Big Data Virtual Chapter Leader, SQL Saturday Barcelona Organizer and assistant at the PASS Atlanta BI User Group. He is finishing his PhD thesis about: “Analyzing Social Data with Machine Learning.” He is an MCT and MCP on BizTalk Server and SQL Server. He is coauthor of Microsoft Training Kit 441.

Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEds, PASS BA, PASS Summit,  DevWeek London, and PAW Chicago and London.

 Dan Evans

Dan Evans is the North America Business Analytics Practice Director for SolidQ with over 25 years’ experience in applying innovative solutions to business needs. His key focus areas are Advanced Analytics, Business Intelligence, Enterprise Performance Management and Data Strategy on the Microsoft Data Platform. Dan works heavily in promoting technology across North America through involvement through user forums (.NET, PASS, Ignite) and industry-recognized organizations (TDWI, DAMA).

Specialties include business technology solutions, management consulting, business analytics, Big Data, Internet of Things, project management, technical strategic planning and new business development.