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”

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”

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.