I suppose I shouldn't really be writing this blog because the question has to be asked, why are you using a pie chart? But if you really must, at the very least make your pie charts unambiguous and preferably, interesting. Let's not have anything anymore that looks like this:- An example of a really bad pie chart! So I'm hoping that by revealing my seven secrets below, you'll either never use a pie chart again or at least you'll produce… Read More
Power BI in Practice Blog Posts
By Stuart Box
Power BI in Practice Power BI Premium 14th July 2020
Sentiment Analysis in Power BI, analyse text reviews and a Premium tip.
Power BI is great at analysing numeric data. Numbers like values, costs, stock holdings and averages can all be worked up into informative charts and visualisations. But what if your data isn't like that? What if your data is more textual, like product reviews, staff evaluations or survey results? How can you visualise that data with Power BI ? This post explains how you can work with that sort of data in Power BI using the AI Insights in Power… Read More
By Alison Box
Power BI in Practice 10th July 2020
7 Secrets of the Line Chart
The line chart is the go-to chart type to visualise data over time. Typically, this visual is used to analyse your data by year, quarter, month or by day. It should be an easy thing to do to create a line chart that plots your data in the way you want. But beware, there are secrets lurking behind the benign line chart! Here are my top seven. #1 There Are Two Different Types of X-Axis The default x-axis, along the… Read More
By Stuart Box
Cloud DAX Excel Online Training Power BI in Practice Training Virtual Classrooms 29th April 2020
All our courses are now available as Live Online Training
All our Courses are now available as "Live Online Training", here's what you need to know. In a "Social Distancing" world we can't gather together in groups for Training. So how can organisations keep their skills current when we can't get together in the same room? The answer is with Live Online Training.Read More→ Read More
By Stuart Box
Cloud DAX Learning Online Training Power BI in Practice Virtual Classrooms 8th April 2020
Live Online Power BI Training from Burningsuit
We have many years' experience of training people how to use Microsoft Power BI. Up to now our training has all been face-to-face, either as open public courses in London or private on-site training. Obviously due to the current coronavirus restrictions this type of course is not possible, so we're launching Live Online PowerBI training. Having had experience in online training in the past we're confident that this will provide a first-class learning experience in these difficult times. What is… Read More
By Alison Box
DAX Power BI in Practice 16th March 2020
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
4 Responses
By Burningsuit
Learning Power BI in Practice Training 12th March 2020
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 18th February 2020
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 22nd January 2020
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
2 Responses
By Alison Box
DAX Microsoft Power BI in Practice 20th January 2020The 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
1 Response
