Power BI for Power Users

Duration: 2 Days

Course Overview

This course will introduce the tools embedded within the Power BI tool via Excel and Power BI. This is an introduction to developing data models with Power Pivot and Power Query.

How can I attend my course?

On-line from
your chosen location

At our dedicated
training facility

On-site at
your premises

Course Content

Overview of Power BI

• Identifying Business Intelligence (BI) tools
• Touring the BI tools in Excel
• Investigating the Power BI versions
• Integrating Power BI with Office

Shaping the Data in Power Query

• Touring the Power Query interface
• Importing data and adding to the Data Model
• Transforming data
• Manipulating the data further with expressions

Designing the Data Model in Power Pivot

• Touring the Power Pivot Interface in Excel and Power BI
• Defining data tables
• Developing relationships between data tables
• Normalizing the data model

Performing Data Analytics with DAX

• Mastering the DAX terminology
• Developing measures to provide finite analysis
• Exploiting the use of KPIs
• Incorporating common DAX functions

Familiarisation with Power BI

• Developing models in Power BI
• Importing data models into Power BI
• Sharing data models

You will receive a full set of course notes
and all supporting materials for your course.

Hard Copy Delivered to your premises or Downloaded to a chosen device.