By Alison Box

DAX Learning Power BI in Practice

Power BI Conditional Formatting

I thought this would be an easy blog. Not much to say about using Power BI's Conditional Formatting. All it does is make visuals look more appealing by using pretty colours based on the data's values. How wrong I was! In fact there's so much to say that I've had to resort to a mini contents page using outline numbering and links to the relevant paragraphs. In fact, just like the old days of writing user manuals! So here goes… 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

Learning Microsoft 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. Two Types of Many-to-Many Relationship… Read More

By Alison Box

Learning Power BI in Practice

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

Learning Power BI in Practice

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

Excel Learning Power BI in Practice Power BI Resources

The “Strictly” Report: Insights into the Data

Alison Box, one of our Directors and Trainers, details how she used Power BI to bring her Strictly statistics to life. In my previous blog, “The Strictly Report: Behind the Scenes”, I explained how I imported the data, cleaned and re-structured it. The next question was how was I going to explore all this data to get meaningful insights. Would I ever get to answer the “contestant journey” question that had prompted me to create the report in the first… Read More

By Burningsuit

Excel Learning Power BI in Practice Power BI Resources
Strictly Results

The “Strictly” Report: Behind the Scenes

We speak to Alison Box about how she gathered the data to create The Strictly Report. Contrary to what people might think, I’m not a raving Strictly Come Dancing fan. I find the first weeks of the competition quite entertaining when they stumble around, but when they get good it all gets a bit boring and samey. However, there’s one question regarding “Strictly” that has always intrigued me; for those that get to the final, how has their “journey” differed… Read More

By Burningsuit

Learning Training
Training Microsoft Power BI

The Difference Between Public and Private Courses

At Burningsuit Ltd we run several different courses across the year training attendees on the fundamentals of Microsoft Power BI. We have monthly public courses running in London that anyone can sign up to join, and we also hold private, onsite courses that are specifically for your business and team members. It can be difficult to know what is the best option for your company, so below we have listed some of the benefits and finer details of what each… Read More

By Burningsuit

Learning Power BI Resources Training

Invest in training in Power BI for your team

Training your team is vital to ensure their skills are up to scratch, as well as ensuring that everything in your business is running as smoothly as possible. When it comes to Power BI, it is a very powerful system and training your staff members how to utilise it to its full potential is vital to get the best return on the investment you have made in software licences and business time. Discover here how training your team in Power… Read More

By Burningsuit

Case Study DAX Learning Power BI Resources Training

Case Study: Training Heathrow Airport Staff

Heathrow Airport is the UK’s largest airport, serving 204 destinations in 85 different countries and with 78 million passengers passing through the airport in 2017. Burningsuit have been providing Power BI Training and Consultancy to Heathrow Airport since August 2017. Heathrow Airport approached us after two of their staff members attended one of our Public Microsoft Power BI Service Courses in London in August 2017 and found the training useful and appropriate. Following this, Heathrow decided to book several on-site… Read More