All courses available in-class or via remote login

Looking at graph on paper

What’s new in Power BI this November?

November 25, 2019

What's new in Power BI this month?

Power BI Desktop has had a range of exciting updates occur over the last month across the whole product.  New visuals, decomposition trees and AI functions integrated into Power Query are just some of the many new updates.

Here’s a quick two-minute overview of this month’s new features.

Reporting

Power BI has announced a long-requested feature, which is the decomposition tree visual.  Decomposition trees can be used to perform root-cause analysis – it allows you to view how individual categories in a group contribute to the whole.  Essentially you can break down a group and explore them according to selected measures, for example by sales amount.

Here’s an example image provided by Microsoft:

 

 Power BI decomposition tree

Analytics

Power BI has updated their button formatting, where users can dynamically set formatting for properties such as button text font colour, button text, icon line colour, outline colour, fill colour and button tooltip.

Visualisations

There are two new visuals in the xViz suite – Advanced Gauge and Hierarchical Filter.  The Advanced Gauge visual allows you to compare an actual value, such as key business indicators, against a target value.  This gauge can either appear as a full or semi-circle, and can be customised and configured to suit your needs, such as changing colours, setting min/max values and axis and number formatting.  The Hierarchical Filter visual is a slicer visual and supports hierarchies, advanced formatting and search, amongst others.  Advanced formatting options for this visual include things such as search support with two different search types, advanced number formatting and full text and background formatting.

You can read more about Power BI’s November updates here!

 

To learn more about Power BI and what it can do for your business, you can check out our courses here.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21470 Reviews
Jagg was an excellent trainer - very patient, had lots of options for people who didn't have the newest versions. I feel really confident about what I learnt today and I am very happy I did this course! -Power BI Beginner Adelaide
Melissa - Power BI Beginner, .
Excellent! Very knowledgeable instructor. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
Great course, very informative. Great instructor, very helpful -Power BI Beginner Adelaide
Sarah - Power BI Beginner, .
Great session, moves at a good pace with support when needed. Thanks -Power BI Beginner Adelaide
Matthew - Power BI Beginner, .
Excellent! -Microsoft Applications - Customised Sydney
Candice - Microsoft Applications - Customised, .
Very helpful -Microsoft Applications - Customised Sydney
Janet - Microsoft Applications - Customised, .
The learning environment and facilities are great. Ken knew the course content and is a friendly trainer.. -SharePoint Site Owner Melbourne
Robbie - SharePoint Site Owner, .
Thank you Ken Great 2 day of learning lots of information, looking forward to making our New Company SharePoint Site -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Thank you Ken, I feel a lot more empowered and up-skilled with regards to SharePoint. I am looking forward to supporting my organisation to leverage SharePoint as one of collaboration and information management tools. -SharePoint Site Owner Melbourne
Annita - SharePoint Site Owner, .
Found it beneficial. Ken was extremely knowledgeable -SharePoint Site Owner Melbourne
Toby - SharePoint Site Owner, .
Great course, learnt a lot for the trainer. -Power BI Beginner Sydney
Aaron - Power BI Beginner, .
A good session however some revision of content from the intermediate course, which meant doing those two courses close together made those portions somewhat repetitive. Jagg was a good presenter and a good pace. -Excel Advanced Adelaide
Belinda - Excel Advanced, .
Jagg went above and beyond to help us learn the advance functions of excel. -Excel Advanced Adelaide
Ateeq-ur - Excel Advanced, .
Jagg was a great instructor - he stepped us through at a good pace, paused well to take q's and was well prepared. -Excel Advanced Adelaide
Hannah - Excel Advanced, .
Excellent range of advanced skills presented -Excel Advanced Adelaide
Oliver - Excel Advanced, .
Jag was excellent! Clear and thorough. I was a bit worried doing it remotely but found it better! Highly recommend. -Excel Advanced Adelaide
Agland - Excel Advanced, .
Was a very good informative session from Jag. -Excel Advanced Adelaide
Nilmini - Excel Advanced, .
Thank you. Well taught, clearly presented, and valuable lessons. Would recommend. -Excel Advanced Adelaide
David - Excel Advanced, .
Good pace, great course -Excel Intermediate Melbourne
Gemma - Excel Intermediate, .
Was a very informative course. John is a very patient instructor. Gives clear instructions. -Excel Intermediate Melbourne
Sonia - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia