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 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”

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 mayContinue reading “Social Media Dashboard – Power BI”

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.