Blog posts related to my work in Power BI and Power Query.
a brief run through of my winning entry on the Maven Churn challenge
How to create stacked bar charts in Power BI to present Likert data andNet Promoter Scores (NPS).
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
This is a walkthrough of the cleaning I undertook on excess of 25 million lines of data as part of the #maventaxichallenge , which is the monthly data visualization challenge set up by Maven Analytics.
Follow My Blog
Get new content delivered directly to your inbox.