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. […]
Maven Monthly Challenge – Mexican Restaurant Scouting
The background to my submission for the Maven Analytics monthly data playground challenge
Welcome to DG Analysis
Hello, and welcome to DG Analysis, a look into the varied world of data analysis and the tools used to present it. My interest in data analytics has spawned from a ‘side-hustle’ at work which has led me from the basics of simple excel spreadsheets to the world of Power BI DAX and Tableau, and […]
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 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 […]
Power Query – Mega Clean
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.
5 Quick Tips for next level BAN in Tableau
A look at turning a Boring BAN into a Badass BAN in Tableau, and helping your big numbers pop!
DG Analysis 