Microsoft Power BI

This is our extensive 2 day course that covers the basics of Power BI through to some of the more advanced capabilities. When businesses need to understand how they are performing quickly and accurately, Power BI is one of the most useful tools in showcasing their data from multiple sources. 

During the course we’ll start by going through the basics of setting up your first interactive dashboard and how to pull in different data sources from different file types, and then we’ll show you how to get the most out of your data through more advanced techniques like power queries and DAX functions. 

By the end of this course you will be able to use Power BI Desktop to create effective reports as well as publish and share it to employees and bosses within your workplace.

Course Outline

What is Power BI?

• Power Query
• The Data Model/Power Pivot
• Rich interactive visualisations
• Power BI Desktop and Power BI Service

The Power BI Desktop Interface

• Different Views
• Visualisation and Fields pane
• Power BI Desktop Options

Getting Data into Power BI

• From Text Files
• From CSV files
• From Web
• From Folder
• From Excel ranges and sheets

Understanding Power Query

• Understanding the Power Query interface
• Renaming and deleting steps
• Cleaning messy data example
• Refreshing a query
• Power Query Options

Common Power Query Features

• Unpivot Columns
• Setting Data Types
• Append Queries
• Merge Queries
• Creating the Data Model
• Create table relationships
• Edit and delete relationships
• Understand filter context

Getting Started with DAX

• How is DAX different to Excel Formulas
• Calculated Columns vs Measures
• Creating a Calculated Column
• Creating Measures
• Using Common DAX Functions

Lookup and Filter DAX Functions

• Why these functions are useful?
• RELATED Function
• CALCUALTE Function
• FILTER Function

Interactive Visualisations

• Adding tiles to a Report
• Creating Charts
• Using Geographic Data
• Creating Matrixes
• Using Slicers
• Other Filter tools (Report, Pages, Visualisations)
• Editing Interactions
• Highlight vs Filter
• Formatting Visualisations
• Drill Down

Power BI Service

• Publishing your Report
• Mobile Layout
• Reports and Dashboards
• Bookmarks

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses