Power BI Training Courses

Power BI Essentials

This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards. Delegates will learn how to:

Overview of Microsoft Power BI 

• Build a Basic Report  
• Get & Transform Data - Power Query 
• Build the Data Model 
• Build a visual Report  
• Power BI Service     

Prerequisites

• None. Beginner course

Power BI Advanced Features

Delegates will learn how to:

• Power Query – Transform Data     
• Data Model – Manage        
• DAX Formulas        
• Building Dynamic Reports  
• Visualisations          
• Power BI Service

Prerequisites

• Power BI Essentials

Introduction to DAX for Power BI

At course completion, you should be able to

• describe DAX syntax, data types, and errors
• use DAX to create calculated columns, measures, and tables
• explain how DAX calculations are evaluated, along with the differences between row context and filter context
• configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
• create calculated columns and measures that use data from multiple tables in the data model
• write measures that handle error conditions gracefully
• use DAX to enhance the Power BI user experience
• use DAX Studio to connect to a Power BI data model and execute simple queries

Microsoft Power BI: Data Analysis Practitioner

In this course, you will analyze data with Microsoft Power BI. You will:

• Analyze data with self-service BI.
• Connect to data sources.
• Perform data cleaning, profiling, and shaping.
• Visualize data with Power BI.
• Enhance data analysis by adding and customizing visual elements.
• Model data with calculations.
• Create interactive visualizations.