By Alison Box

Learning Microsoft Power BI in Practice 31st July 2019

It’s Complicated – Dealing with Many to Many Relationships in Power BI

If you're building a DataModel in Power BI, and creating relationships between tables you may have come upon this message. What the heck does "Cardinality Many-Many" mean? And what is the "Significantly different behaviour" they're warning me about here? In this post I set out to find out what these Many-to-Many relationships mean and how they work. The answer is complicated, but worth understanding if you want to create efficient data models in Power BI. Two Types of Many-to-Many Relationship… Read More

By Stuart Box

Microsoft Power BI in Practice 29th July 2019

The Filter Pane Pain in Power BI

The July 2019 update to Power BI is now out, you can get all the details from Microsoft here. As usual there are a list of new features and tools released in the product. One of the main updates is the release of the new Filter Pane. Existing reports can upgrade to the new pane through the Options dialog, but any new reports should automatically have the new pane on by default. The Filter Pane is a new way of… Read More

By Stuart Box

Microsoft Power BI in Practice 12th July 2019

Joke’s Over – send Email to users when refresh fails

I do a lot of Power BI Training, and have been doing it since Power BI came out over three years ago. So to keep myself fresh, amuse myself and hopefully my delegates, I've built several "Jokes" into my Power BI training. But now with the latest update to the Power BI service one of my favourite gags has been stopped. The joke used to go like this. The Tale I'm an Office 365 users, that means my Email, Diary,… Read More

By Alison Box

Learning Power BI in Practice 22nd June 2019

Understanding the “Analytics” Lines in Power BI

In our Power BI training courses, I show people how to add a Constant Line to a clustered column chart by using the Analytics section of the Visualizations pane.  I then explain that the other Analytical lines (Max, Min, Average etc) are “calculations across the totals”.  But what do I actually mean by this; what are these calculations?  I do feel that these Analytics Lines deserve a much better explanation so now is the time to turn the spotlight on… Read More

By Burningsuit

Microsoft 17th June 2019

Burningsuit Featured at the Microsoft Business Applications Summit

This week, the Burningsuit team were delighted to attend the Microsoft Business Applications Summit which took place in Atlanta, Georgia. The summit featured many insightful talks, training sessions and updates about the Power BI platform. Keep an eye out for our next blog post that will be an in-depth look at the two day event and everything that we experienced and learnt. For now, discover why this summit is so important for our industry and our main highlight from the… Read More

By Alison Box

DAX Power BI in Practice 19th May 2019

Best and Worst: Two approaches to finding Top or Bottom N Percent using DAX

Ever wanted to find which are your best or worst customers or best or worst products by a metric such as Total Sales? Finding a simple TopN or BottomN (e.g. Top 10 Customers) in Power BI Desktop couldn't be easier; just use the TopN Filter:- But what about finding Top 10 Percent of a value like Total Sales? As the number of our customers or our products grows over time, finding a simple Top 10 or Bottom 10 of a… Read More

By Alison Box

Power BI in Practice Power BI Resources 9th April 2019

7 Secrets of the Matrix Visual

Some of you Excel users may have realised that the Power BI Matrix visual is just an Excel Pivot Table by another term. You even get buckets for “Rows”, “Columns” and “Values” just like constructing an Excel Pivot Table. The temptation is to think this is all the Matrix visual can do; act like, well, a typical Pivot Table: -   However, depending on your knowledge of Excel Pivot tables, you’ll know that if the Matrix is just like an… Read More

By Burningsuit

Learning Power BI in Practice 15th March 2019
harmonic2

Case Study: Power BI Training with Harmonic Ltd

In 2018 we were booked for an on-site Power BI course with Harmonic Ltd after several of their team members attended our public course in London. Following the private course, they have been in touch with the prospect of booking onto more courses. Find out the difference between our public and private course options here. About Harmonic Ltd Based in Ilminster, Somerset, Harmonic Ltd are a managing consultancy firm working with some of the UK’s largest businesses. They provide effective… Read More

By Burningsuit

Case Study 15th February 2019
DAX-for-Power-BI-Training

Case Study: Power BI Training with HMICFRS

In 2018 Burningsuit were pleased to work with Her Majesty’s Inspectorate of Constabulary and Fire & Rescue Services (HMICFRS), based in London, on Power BI training for their team. Since the course, some of HMICFRS employees have signed on for further training with our DAX for Power BI course. About HMICFRS Established in 1856, HMICFRC is located next to the Home Office and is a senior institution within policing. They are responsible for inspecting and reporting on the performance of… Read More

By Stuart Box

Power BI in Practice Power BI Resources 4th February 2019

New Power BI feature, embed reports securely in Web Pages

We know that we've been able to publish Power BI reports to the web for some time. It's a good feature, allowing us to publish our "Strictly Come Dancing" report so anyone can access it. But that's also the flaw in publish to Web, anyone can access, it effectively makes the whole report public property. It doesn't matter that you put the link on a secure intranet page, publish to web hosts the reports on a publicly facing web server. One… Read More