a short review of “the functional art” by Alberto Cairo
Category Archives: Blog
Net Promoter Score and Likert Scale Visuals in Power BI – Maven Airlines
How to create stacked bar charts in Power BI to present Likert data andNet Promoter Scores (NPS).
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”
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!