By Alison Box
DAX Power BI in Practice 9th May 2019
Ever wanted to find which are your best or worst customers or best or worst products? Finding a simple TopN (or BottomN) in Power BI Desktop couldn't be easier; use "Ask a Question" on the Home tab; just type "Top 10 Customers by Total Sales as a Column Chart" or "Top 20 Products by Quantity as a Table" and see the magic happen! But what about finding Top 10 Percent? As the number of customers or products grows over time,… Read More
By Alison Box
Power BI in Practice Power BI Resources 9th April 2019
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
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
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
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
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
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 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
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
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
© 2019 Burningsuit Ltd | Terms & Conditions | Privacy Policy
