Category Archives: Blog

Maven 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. NeedlessContinue reading “Maven Unicorns – Interviewing the Data”

Maven Remote Work Challenge – Strategy Execution

Before we start…. There was quite a bit to this challenge, so I am covering it in one blog and one video. This one will look at the strategy and execution of the planned steps I laid out in a LinkedIn post and in the below photo shot; the separate video looks at the technicalContinue reading “Maven Remote Work Challenge – Strategy Execution”

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 putContinue reading “My Data Analysis Portfolio”

Maven Motors Challenge – 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 andContinue reading “Maven Motors Challenge – My Plan and Strategy”

Maven Analytics – Harry Potter Challenge

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.Continue reading “Maven Analytics – Harry Potter Challenge”

Sankey Chart and SUMMARIZECOLUMNS in 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 BIContinue reading “Sankey Chart and SUMMARIZECOLUMNS in Power BI”

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 theContinue reading “Power Query – Nested If/And/Or Statements”