Power BI Training Courses
This page lists Wise Owl scheduled public training courses on Power BI Desktop, as well as on creating measures in DAX:
Power BI classroom training
We currently run the following classroom training courses for Power BI, as well as a dedicated DAX course:
Alternatively, why not organise your own onsite Power BI course, or have a look at the extensive changes we've made to our classroom training to allow social distancing.
Online Power BI training
Alternatively, you can take the following Power BI and DAX courses online:
Not sure how if online training is for you? We've created a detailed page for you to see exactly how our online courses work (probably better than you think!).
Which is the right Power BI course for you?
The main Microsoft Power BI tools are as follows:
| Application | Notes |
|---|---|
| Power BI Desktop | Create visual, interactive reports which you can then publish to your organisation's website (or to a public site). |
| Power BI Service | This allows you to view reports that you've published online, to create shared workspaces and to pin tiles to dashboards. |
| Power BI Mobile | Create reports to be viewed on mobile devices. |
In addition, PowerPivot within Excel is often thought of as a Power BI tool (mainly because that's what Microsoft used to call it).
Our Power BI Courses
We run the following introductory courses in the Microsoft Power BI tools:
| Course | What you'll learn |
|---|---|
| Introduction to Power BI | How to create visually interactive reports, including importing data, transforming it using Query Editor, creating visuals such as tables, matrices and charts, filtering data (for example, using slicers) and creating calculated columns and measures using DAX. |
| PowerPivot for Excel | How to import data, use Query Editor to transform it, and how to create tidy data models upon which to create pivot tables in Excel. You'll also learn how to create calculated columns and measures using DAX, as well as creating KPIs. The course ends with an overview of Power BI Desktop. |
As you can see, there's a lot of overlap between the two courses! In addition, we have the following more advanced courses listed on our site:
| Course | Notes |
|---|---|
| DAX | Learn how to create measures and calculated columns using DAX. |
| Advanced Power BI | Learn some more advanced features of Power BI, including parameters, hierarchies, binning and advanced charts. |
We also run a three-day fast-track Power BI course, which attempts to combine six days of training into a single, intensive three-day course!
10 things our Power BI courses include
Each of our scheduled courses (whether classroom or online) includes:
- Small course sizes - we have a maximum of 5 people on each classroom or online course.
- A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
- Full colour courseware and exercises of oustanding quality.
- A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
- A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a Sheaffer biro.
- Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
- A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.
In addition, our classroom courses also include:
- A computer for each delegate (obviously).
- Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
- Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
About our Power BI training
Both our PowerPivot and our Power BI courses use the same sample database. It's called Create-a-Creature, and is like a more general version of Build-a-Bear. It consists of a handful of simple tables containing purchasing data for a (fictitious) company, which delegates get to analyse by:
- Region, town and shopping centre
- Environment, habitat and product
- Year, quarter and month
Our Power BI courses will not (directly) help you to pass the following Microsoft exams:
- 70-778 (Analysing and Visualising Data with Microsoft Power BI)
- 70-779 (Analysing and Visualising Data with Microsoft Excel)
However, our Power BI courses will show you how to load data into your data models, applying clever transforms as you do so, and how to add additional statistics called measures using the DAX formula language.
Other Power BI training resources
There are so many ways in which we can help you learn Power BI, as the impressive list below shows.
Try our Power BI exercises
You wouldn't buy a car without a test drive, so why buy a training course without seeing the exercises first?
Videos on Power BI
Have a look at our training videos on learning PowerPivot.
Test your Power BI skills
Blogs on Power BI
Have a look at our blogs on PowerPoint and the DAX language.
Power BI training venues
Wise Owl Power BI Desktop and DAX courses run in these venues.
Power BI consultancy
Instead of having to struggle to create Power BI reports instead (including mastering creating measures in DAX), why not ask us to help?
Self-paced Power BI online training
Power BI courseware manuals
You can see some sample Power BI courseware chapters below.
Hi,
Can you tell me what is PowerApps? Is it another application such as Powerpivot, Power View, Power Map or something totally different?
I've answered this to some extent in this blog. More blogs with more details will follow! Make sure you sign up to our newsletter, as this will contain information on new courses and blogs as they emerge.