Great Shelford, Cambridge / Online
1 day course
£310.00 (ex. VAT)

This is a 1 day Introduction course that covers the basics of Power BI. 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.   

Prior to attending this course you should have attended our Excel Advanced courses or have existing knowledge of VLOOKUP and Pivot Tables.

By the end of this course you will be able to use Power BI Desktop to:

  • Connect to, import, and transform data from a variety of sources.
  • Define business rules and KPIs.
  • Explore data with powerful visualization tools.
  • Build stunning reports with Power BI.
  • Share dashboards with your team and business partners and publish them to the web.

.

Course Outline

  • Connect to, import and transform data from a variety of sources
  • Manipulate and Prepare data using Power Query
  • Data transformations in M
  • Introduction to DAX and measures
  • Creating and formatting data visualisations
  • Creating groups, hierarchies and cross filters
  • Creating bookmarks and using conditional formatting
  • Creating and sharing dashboards with others
  • Publishing to the Power BI service

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

Microsoft Excel Power Query

Microsoft Power BI

Microsoft Excel Advanced Formulae & Pivot Tables

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel VBA