Data Viz Done Right

May 12, 2021

How to Create a Time Series Drilldown with a Set Action

No comments
In this video, I show you how to use a set action to drill down from a monthly view to a daily view. This technique will work with any date drill down, whether it be year to quarter, year to month, quarter to day, etc.

May 11, 2021

Threshold Analysis - Level of Detail Expressions vs. Table Calculations

No comments

DS22 is nearing the end of their training and today was a bit of a refresher. One of the questions I wanted them to answer was how many sub-categories in each region had sales above $40,000?

We then expanded that to include (1) the sales for those sub-categories and (2) the % of sales those sub-categories make up of the region sales. They were to complete this using LODs.

As they worked on the task, I thought that this, for sure, could be done with table calculations. This is perfect for the Data School Gym. 

If you know me, you know I love table calculations. And if you know Lorna Brown, you'll know she HATES table calculations. So this is your Data School Gym challenge Lorna.

Of course, everyone is welcome at the Data School Gym. It's actually not that hard and is a good way to help you learn about LODs vs. table calcs.

I'm not too fussed about making it look exactly the same. The point is to see if you can create the identical tables. Enjoy!

May 10, 2021

#MakeoverMonday 2021 Week 19 - The Cost of 1GB of Mobile Data in Every Country

No comments
This was my first time making a World Tile Map (thanks for the template to Neil Richards). Download the template here

In my version, you can view the cost overall or you can compare to a selected country. The title will update automatically depending on if you've selected a country or not.



May 4, 2021

How to Create a Layered Hex Map with a Spatial File

No comments

In this tip, I show you how to use a spatial file to overlap hexagons on a map. This technique is much simpler, looks better, and is easier to maintain.

Typically when you want to create an overlapping hex map, you will use a template that has x/y coordinates for the rows and columns, hex shapes, then try to pack them together until they look just right. But then you put them into a dashboard and the sizes need to be adjusted again. What a pain!

Watch this tip to see the simple way to create layered hex maps.

RESOURCE: Hex map template via Joshua Milligan here

May 3, 2021

#MakeoverMonday 2021 Week 18 - Realized vs. Granted Compensation for CEOs

No comments
In this session I first reviewed the original visualization, then went into data discovery and analysis before finishing with a new visualization.  Watch the video and interaction with the visualization below.

Charts created: 
  1. Line Chart 
  2. Stepped Lines 
  3. Variance to baseline 
  4. Win/Loss chart 
  5. Comet Chart 
  6. Gantt Chart 
  7. Bar chart w/ reference line 
  8. Connected scatter plot 
  9. Slope Graph 
  10. Circle Timeline 
  11. Heatmap 

  1. Data Set - 
  2. Chart chooser -