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
Power BI Resources Blog Posts
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 Power BI Resources Training 7th November 2018
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
Power BI Resources 22nd August 2018
Data Visualisation Tools: 4 Creative and Inspirational Dashboard Examples
Power BI is a useful tool in a wide range of fields and industries because its dashboards and reporting functionalities can be tailored and implemented to reflect your company’s exact requirements. With this being the case, there are some really unique and useful dashboards out there with some of the best being found in the Power BI Data Stories Gallery. We spoke to our Director, Stuart Box, who has put together a guide of useful elements to consider when creating… Read More
By Burningsuit
Case Study DAX Learning Power BI Resources Training 24th July 2018
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
By Burningsuit
Excel Microsoft Power BI Resources 24th May 2018
Why Power BI is the future of Excel
Microsoft’s Power BI is powerful and easy to use, and with new features being added every week, it is fast becoming the future for business analysis. Excel formulas and pivot tables may well be the most popular programming language in the world, and the addition of tools like Power Query, Power Pivot, Power Map, and Power View mean you can connect to, clean, remove duplicates and transform almost any data you have. We have discussed the benefits of Power BI… Read More
By Burningsuit
Power BI Resources 9th May 2018
What is the difference between BI reports and dashboards?
There is a misconception that the Power BI report is a detailed tabular report and that the dashboard is an interactive visualisations with charts. This isn’t the case and in order to build effective power BI solutions, you will need to understand the differences, and in a way that can help you to leverage their unique powers to the greatest possible effect. After the February 2018 update to Power BI Service, both Reports and Dashboards can be shared. It’s a… Read More