Power BI

Blog posts related to my work in Power BI and Power Query.

Maven Challenge – Unicorns – Interviewing the Data

Maven’s data challenge for April-May 2022 involves the analysis of a set of data related to “Unicorns”. A few of my work colleagues saw my LinkedIn post related to the announcement of this challenge, and thought I was looking at data related to the horsey-type unicorns, and they were pleasantly amused at the thought. Needless […]

My Data Analysis Portfolio

Introduction From reading a lot of data viz experts and tutors comments on platforms such as LinkedIn, one recommendation that keeps popping up is that any aspiring or practising “visualizer” should maintain a portfolio of work to showcase the skills and breadth of work that they may have. I have taken that advice, and put […]

Maven Challenge – Superbowl Commercial – My Plan and Strategy

After submitting my Power BI report on LinkedIn as part of the Maven Super Bowl Challenge, I was messaged by a few people asking if I could put together an article or video blog on how I created it. So, here I am!! Rather than jumping onto the snapshots of the Power BI platform and […]

Maven Challenge – Harry Potter Scripts

Using Power Query to match number of particular spells to characters When I first saw the new Maven Magic Challenge description, I was drawn to the words “share a…visual that captures the MAGIC“. And so, when I started looking at the data I had little real interest in the budgets, box office and run times. […]

Sankey Chart and SUMMARIZECOLUMNS – Power BI

Walkthrough I have created a walkthrough video of how to use SUMMARIZECOLUMNS in DAX to create a multilevel Sankey Chart in Power BI. Here is a link to the video, and I will describe some of the steps and calculations performed in the following paragraphs Background Quite a lot of the content surrounding Power BI […]

Social Media Dashboard – Power BI

Overview I have created a walkthrough so that you can use just 6 DAX formula to develop data extracted from your social media accounts into a metrics dashboard like that below, whether that be LinkedIn, Twitter, blog accounts or your own website. A Youtube video of this walkthrough is linked here. Some of you may […]

Power Query – Nested If/And/Or Statements

This is a brief follow on to my earlier blog on the Maven Analytics NYC Taxi challenge, and cleaning well over 25 million line items of data in Power Query, before developing a Power BI dashboard. In particular, I am looking at amending an “If/And” statement to become a nested “If/Or/And” statement. One of the […]


Follow My Blog

Get new content delivered directly to your inbox.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s