By Burningsuit

Learning Power BI in Practice Training
Power BI Training in London

Why Power BI Training Courses in London Could Benefit You

Power BI is an essential tool that many businesses use to get insightful reports on a range of different important metrics. Whilst it’s extremely useful, it has a lot of functions that can be complicated to initially understand. Attending a Power BI training course can be extremely beneficial and help you and your team to improve on your skills and data analysis. At Burningsuit, we run a range of public courses in London across the year to help users of… Read More

By Stuart Box

Power BI in Practice

Enable the new Ribbon Menu in Power BI Desktop

I've made a quick video to show how you can enable the new Ribbon Menu in Power BI Desktop. In the February 2020 version of Power BI Desktop this is still a "preview" feature, so you need to enable the preview to see it. However this new menu is expected to be on general release sometime in March this year, so it's probably a good thing to enable this menu now and get used to it before the March update… Read More

By Alison Box

DAX Power BI in Practice

Categorising Measures into Numeric Ranges or “Bins”

We've often been asked if it's possible to group the results of a DAX measure into numeric ranges. For example, to group a Total Sales measure for each Customer into various numeric ranges, sometimes referred to as "bins". The answer is, yes it is, as you can see from the screenshot below:- In this screenshot, we can see that we have five customers whose Total Sales fall between 150,000 and 199,999 in 2019. How did I do this? Firstly, my… Read More

4 Responses

By Alison Box

DAX Microsoft Power BI in Practice

The Key Influencers Visual Versus Strictly Come Dancing

The Key Influencers visual, introduced in February 2019, is Microsoft's first visual that uses "Machine Learning" to identify factors that influence the outcome of a particular metric. "Wow", I thought! The idea of leaving Power BI to do all the hard work in analysing my data seemed too irresistible to ignore, so I gave way to temptation and decided to give it a go. On the one hand, it's a very simple visual to construct (it only has 3 buckets;… Read More

2 Responses

By Alison Box

Power BI in Practice

Strictly Come Dancing Series 17; Report Version 2 is Here!

As I keep telling people and as I've said in previous blogs, I'm not a "Strictly" fan, I just happen to love the data and all the insights into it that Power BI can give you. So it had to be done; to update the report to include analysis for the latest series; Series 17. I've also taken the opportunity to completely re-vamp the original and many of the existing pages have been re-designed. I've added quite a few new… Read More

By Alison Box

DAX Power BI in Practice

Find a Value in the Previous Row

Recently I was asked by one of our clients to solve this question; how could they calculate the number of days between customers' transactions? Clearly, in order to do this calculation, you would need to find the transaction date that was previous to the transaction date sitting in the current row. You could then subtract the earlier date from the later date and return the days between them. It occurred to me, that such a calculation could have a more… Read More

6 Responses

By Alison Box

Power BI in Practice

Top 10 Power BI Desktop Annoyances

You know that moment when you're using Power BI Desktop and you start swearing under your breath? I have to admit I don't often do this but when I do, boy do some things annoy me! So just to get things off my chest and have a good old rant, I've listed my top 10 annoyances in Power BI Desktop and notice I haven't even mentioned the ridiculously small default font used by visuals.Read More→ Read More

By Stuart Box

Learning Power BI in Practice Power BI Resources Training
harmonic2

Our Autumn Training Schedule

We have released the schedule of our Power BI and DAX training for the last part of this year. Our courses cater for all levels of Power BI users, from the Fundamentals course which offers a good introduction to creating and sharing Reports and Dashboards with Power BI, our Advanced Power BI course which takes things to the next level with a closer look at the Data Model and advanced topics such as Row Level Security, and our DAX course… Read More

By Stuart Box

DAX Learning Power BI in Practice Training

Level Up! Take your Power BI Skills to the next level with Advanced Training

This week we're delighted to announce the availability of our new advanced Power BI courses. We offer a full range of courses to take users from their first look a Power BI to advanced topics such as Apps, Row-Level-Security and CALCULATE and FILTER in DAX. Read this post to find out about these new courses and see which one is right for you.Read More→ Read More

By Alison Box

DAX Power BI in Practice

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. [latestCourse] Two Types of Many-to-Many… Read More