Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
We've updated our Power BI courseware after a two-year gap |
---|
Power BI is a nightmare to teach, as it keeps changing! Our policy is to update our courseware roughly every 18-24 months; this blog contains details of our latest huge update, and how it will affect delegates on our Power BI courses. |
In this blog
How do you pin down Power BI when it changes every month? This is a problem we've wrestled with over the years. Our solution is to do big updates over 18-24 months. Here's the recent history of these major updates, in reverse chronological order:
Month | Update |
---|---|
March 2024 | We've just updated all of our Power BI manuals from a February 2022 base. |
September 2023 | We updated our DAX manual. |
February 2022 | We updated our Power BI courseware to include all updates since October 2021. |
October 2021 | We updated all of our Power BI manuals since May 2020. |
May 2020 | We updated our Power BI manuals to include the new ribbon and other changes. |
To give you some idea of how long this takes, my original project plan allowed for 40 man days of work on updating our courseware for our Basic Power BI, Advanced Power BI (Reports) and Advanced Power BI (Data) courses.
So what does the new March 2024 update include? I'd say you can divide the changes into 5 main categories, as explained under separate headings below.
To include this change, or not? It's still in preview:
This option is not ticked by default.
Cosmetically, ticking this option makes a huge difference. Here's a screen-shot of a line chart's formatting without on-object interaction:
The version of Power BI that most people will see.
Here's roughly the same screen with on-object interaction enabled:
The main difference is in the way in which format properties are presented.
We decided to include on-object interaction in the courseware update. For courses from the start of March onwards we will show delegates what Power BI looks like with on-object interaction enabled, but then teach the course with it disabled.
This obviously means that delegates' courseware won't exactly reflect their experience of Power BI, but in practice this has always been true: it would be impossible to get every delegate to receive courseware fine-tuned to the version of Power BI Desktop that they use.
This irritating change meant that we've had to replace virtually every single screen-shot in our Power BI courseware:
Before-and-after dialog boxes showing the colour change.
This may not seem that important, but it doesn't look good when all the manual screen shots look different from what people see on their screens.
Much has changed in the last 24 months in the Power BI world (you can see a list of all the updates to Power BI Desktop here). Here's a quick summary of all the changes which we've incorporated in our revamp:
Update | Highlights |
---|---|
Lots of new formatting options for bar and column charts, data labels in any chart and Azure Maps cluster charts. | |
Button slicers, adding reference labels to cards, a new DAX query editor. | |
Opening reports from and saving reports to OneDrive and SharePoint. | |
Formatting visuals interactively in mobile layout and adding new linguistic relationship rules to Q&A visuals. | |
A new button to switch between mobile and report layouts. | |
Smoothing and leader lines for line and area charts. | |
The new card visual. | |
The Azure Map visual and Optimize ribbon, and measures for chart data labels. | |
Modern visual tooltips. | |
Subtitles, clear/apply slicer actions and PowerPoint story-telling | |
A new relationship editor, tweaks to conditional formatting, themes, text boxes and page navigators. | |
Changes to slicer formatting. | |
Field parameters to create dynamic slicers and different Y axes for different small multiple charts. | |
Changing the stack order of column and bar charts. | |
Formatting mobile reports differently, small changes to hierarchical charts and default column titles in tables. | |
Conditionally formatting the font colour of data labels. | |
Chart error bars. | |
Subtle improvements to the table visual. | |
Zooming in and out in a report, and using a rectangular lasso to select data points in some chart types. | |
A few new formatting options for matrices and for chart legends. |
We've included these two exciting new visuals in our courseware (both are in preview, but new cards are turned on by default). Here are sone examples of new cards:
Examples of the new card visual.
Here's an example of the new slicer visual:
An example of the new slicer visual (with a modern tooltip showing too).
We've done what Microsoft clearly want to do, and have consolidated our map teaching into a single visual - Azure maps:
Four examples of the Azure Maps visual.
I blogged on Azure maps when they first came out way back in June of last year, and reported that I was underwhelmed because they seemed a bit buggy and VERY slow to refresh. I'm pleased to say that these problems have gone, so I've now written a full guide to using Azure maps to do this excellent new visual justice.
From 1st March all of our Power BI delegates will get our new courseware (we're also working on a brand new suite of exercises which we hope to roll out soon). We hope you enjoy reading about all the whizzy new things Power BI has to offer!
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.