Blog posts related to my work in Power BI and Power Query.
Maven Challenge – Telecoms Churn Analysis
a brief run through of my winning entry on the Maven Churn challenge
Maven Challenge – Net Promoter Score and Likert Analysis – Airline Survey
How to create stacked bar charts in Power BI to present Likert data andNet Promoter Scores (NPS).
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…
Maven Challenge – Power Query Mega Clean – Taxi Challenge
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.
DG Analysis 