Power BI Workshop

Excel Power BI Workshop

Course Content

Introduction to Power BI

Understanding the Power BI Interface
Overview and Interface
Accessing Data
Power BI Workspaces
Formatting Data in Power BI Desktop

Creating Reports in Power BI
Creating a Table
Formatting a Table
Sorting Tables
Creating Multiple Measures

Different Methods of Aggregation

Tables and Cards
Creating a Matrix Table
Creating a Multi Row Card
Creating a Card

Filtering Data
Slicers
Filters
Visual Filters
Page Filters
Report Filters

Visualisations
Column Graphs
Stacked Bar Graphs
Cross Filtering between Column & Bar graphs
Filtering & Highlighting

Graph Options

Trend Analysis - Time Intelligence

Additional Graph Types
Combination Graph, Pie & Donut Graphs
Treemap Graph
Geographical Analysis
ScatterPlots & BubblePlots

Creating an Interactive Dashboard
Publishing the Dashboard
Pinning Visuals to a Dashboard
Q&A Feature
Inviting other users
Accessing a shared Dashboard
Power BI on mobile

Enhancing Power BI - DAX Formulas
DAX formula language
Simple calculations in DAX
Creating time intelligence functions
Creating a date table

DAX Measures

Relationships
Employee Master Challenge
Creating Custom Visualisations
Using the Related Function

Enhancing Your Power BI Data
Aggregating Data into new Tables
Working with Queries & Applied Steps 

Duration

Two days

Requirements

Good understanding of Excel and the principals of operating Excel, preferably working with data on a regular basis, with knowledge of compiling reports.
Your own laptop with Power BI Desktop.

Cost

Standard price £650 per person
Discounts available for advance purchase.

Onsite / In-House training also available, please contact us to discuss your requirements.

Scheduled Courses

Please click on the dates in the calendar below to see different venue and course options.
Share by: