Contact Us

Microsoft Power BI 2 days | 12 hours | $1,190 PLUS TAX

Raw data doesn't tell a story on its own -- Power BI helps you make sense of it. Over two days, you'll learn how to pull data together, clean it, transform it, and build dashboards and reports that communicate clearly. You'll also explore how Power BI connects with Excel and other Microsoft tools you already use. Prerequisite:

COURSE OUTLINE

Introduction

» getting started with Power BI Desktop
» review a sample Dashboard

Beginning a project

» connecting to data sources
» using the Query Editor to clean up and
transform data
» advanced data sources and transformation
» dealing with irregularly formatted data

Modeling

» managing your data relationships
» creating Calculated Columns
» creating Calculated Tables
» optimizing data models for better visuals
» working with time-based functions
» exploring time-based data

Introduction to DAX

» DAX calculation types
» DAX functions
» using variables in DAX expressions
» table relationships and DAX
» DAX tables and filtering

Visualizations

» creating simple visualizations
» customizing visualizations
» using combination charts
» create and format slicers
» using map visualizations
» using tables and matrixes
» using a variety of charts and visualizations
» formatting your reports your way
» creating interactions between visualizations
» customizing visuals with options

Finishing the project

» publishing and sharing
» content packs
» summary