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
THE BURNINGSUIT BLOG
By Burningsuit
Learning Power BI in Practice 15th March 2019
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
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
By Burningsuit
Excel Learning Power BI in Practice Power BI Resources 29th January 2019
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 21st January 2019
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
Power BI in Practice Power BI Resources 10th December 2018
Power BI – Strictly Come Dancing, the Results
Power BI is a very powerful tool that is able to extract and analyse a wide range of data and produce easy to understand interactive dashboards and reports. With that in mind, we have put together a report that collates a range of different data from the popular TV programme, Strictly Come Dancing! Strictly Come Dancing in Power BI What our report includes Our report analyses a range of data, such as: “Does Craig really give the lowest scores?” “How… Read More
By Burningsuit
Learning Training 29th November 2018
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
DAX 21st November 2018
Four DAX Functions You Can’t Live Without
Data Analysis Expressions, known as DAX, is the Function language that is used to solve data analysis problems in Power BI. DAX is used in the much the same way that you use Formulas to solve analysis problems in Excel. These expressions, when used in Measures, analyse our data by applying or removing specific filters from the data, filters that would be difficult to accomplish with the normal filtering tools in Power BI such as Slicers and Visual Level Filters.… Read More
By Burningsuit
Case Study 16th November 2018
Case Study: Consultancy with Berry Bros. & Rudd
In 2018 the world-renowned wine and spirit merchant Berry Bros. & Rudd attended a public London course with us, and then booked several consultancy days, also in the capital. About Berry Bros. & Rudd Operating since 1698 from the same central location in London, Berry Bros. & Rudd are Britain’s oldest wine and spirit merchant, and now have offices worldwide. With their history and experience, they stock over 4000 fine wines selected by their Masters of Wine. Still family-run, they… Read More