This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to […]
As is almost always the case when building Power BI reports, the first version is just the start of the journey, not the final destination. This article is a follow up from last week where I showed you how I built my COVID Power BI report from scratch. This week […]
As promised, today I am sharing with you the process I went through to build the COVID report I shared in my last article. One of the best ways to learn and improve your Power BI skills is to practice. The best way to practice is to find something you […]
I am writing an off-topic article today but I promise I will circle back later in the week with a follow up article bringing it back on topic. In this article, I am going to share a COVID report I built today, and later in the week I will post […]
This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to […]
I have been increasingly recording videos as my method of sharing tips and techniques for getting more out of Power BI. Some concepts are best documented (traditional blogging) and some are just easier for everyone if it is a video. That is the case again for today. Compare Any Two […]
I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s […]
Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not […]
This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of […]
Original Post: Feb 2017 Updated: May 2021 I first wrote this article back in Feb 2017 to be a definitive list of the top reasons you should consider using Power BI in your organisation (in case you haven’t already made the decision to do so). In fact there is only […]
This is an update to an article that I wrote back in 2019. This time around I created a video to go along with the written explanation and documentation below. You can jump straight to the video below if you prefer that medium. What is Calendar Over Run? Consider the […]
A client recently asked me if it was possible to build a Power BI report using data from a Microsoft Form. I have come across this question a few times now, and you could be excused for thinking this would be a straightforward task. Despite the fact that Microsoft has […]
To celebrate the release of the third edition of my book Supercharge Power BI, I plan to hold a live webinar this coming Thursday pm (US time), Friday morning Australia/NZ time. Sorry, it will be very late for Europe. I plan to cover 1 topic from my book, and I […]
One interesting trend I have seen over the last 12 months is the creation of a lot more non-technical Power BI content on the web. Adam Saxton and Patrick LeBlanc were early adopters of this format with their YouTube channel “Guy in a Cube”. More recently there have been new […]
As you will most likely know well by now, there is a lot to learn if you want to be good at Power BI. You need to learn skills across the 4 distinct areas as shown below. Ken, Miguel and I are really excited that we have released a new […]
I blogged about how to Build a P&L With Power BI back in April 2020, and the response from my readers was great. Several people asked how to add percentages such as % of net sales revenue, % gross profit, etc. into the P&L. I decided therefore to do a […]
I am proud and excited to announce that I have again updated my best-selling DAX book Supercharge Power BI, now in its 3rd edition. This book as a long history: First released back in Sept 2015 under the title “Learn to Write DAX”. Updated in June 2018 (2nd editions) in […]
Well I am pretty excited to let you know that we (Ken Puls, Miguel Escobar and I) have launched our brand new website for Skillwave.Training. We are dedicated to providing you with the best possible learning experience and have completely revamped the look and feel of our website. We also […]
Power BI Desktop is a free, standalone self service BI tool for data modelling and reporting. You will not get a better, free desktop data modelling and reporting tool than this anywhere. Power BI Desktop is evolving at a rapid rate with updates released every month. Due to the […]
As my regular readers may know, I am the co-organiser and co-founder for the official Power BI User Group here in Sydney. During the period where COVID has impacted our ability to congregate face to face, Iman and I have been running virtual, online meetup events. Last week I presented […]
Matt shares lots of free content on this website every week. Subscribe to the newsletter and you will receive an update whenever a new article is posted.
Excelerator BI | Expert Power BI Training | © 2020