• “Strictly Come Dancing” Telling the Story Behind the Numbers with Power BI
    26th November 2020
    Back in March this year, I did think I’d be relieved of my duty of updating the Strictly Come Dancing Power BI Report to reflect another series. To be quite honest, I was hoping this would be the case. I first created the Report for Series 16...
  • How DAX Treats Nulls & Zeros
    12th November 2020
    In DAX there is a special way to identify null or empty values and that’s by using a value called “blank”. In order to return blank values, we can use...
  • The 8th Secret of the Matrix Visual: Controlling Calculations and Labels on Subtotals
    26th October 2020
    Since I wrote my blog on The 7 Secrets of the Matrix Visual in April 2019, the world has changed (in so many ways) and things have moved on with the...
  • 7 Secrets of the Pie Chart
    21st July 2020
    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...
  • Sentiment Analysis in Power BI, analyse text reviews and a Premium tip.
    14th July 2020
    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...
  • 7 Secrets of the Line Chart
    10th July 2020
    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...
  • The Benefits of Online Training for Businesses
    22nd June 2020
    Offering your staff training courses to improve their skills can be extremely beneficial to your business; not only will it allow you to improve your...