makeover Monday week 7

This week’s exercise looked at Valentine’s day spending in the US. I liked the original viz – the color scheme seemed appropriate for the topic. I liked the images and felt the size and images conveyed what they were intended.

After setting up the data set I started creating the calculated fields I needed:

  • The first was to create a date field from the Year field in the dataset – DATE(“02″+ “/” + “14” + “/” + STR([Year])) .
  • I then created a couple of measures fields for the % Buying and the Avg Net Spend – IF [Metric] = ‘Percent Buying’ THEN [Measure] END and IF [Metric] = ‘Net Average Spend’ THEN [Measure] END

I wanted a custom shape for whatever I ended up creating – I found a free clip art heart online bought that into PowerPoint did a couple of updates to it and saved it to my custom shapes file.

After creating a few different views I decided to keep it simple and focus on what people were buying for Valentine’s day from 2010 – 2016. I tried line charts and bar charts with the hearts and then thought this may be a good time to give a bump chart a try.

Matt Chambers has a great post on his site that walks you through how to create a bump chart and I used that as a refresher. In order to get the bump chart to work I had to create a couple of more calculated measures:

  • Rank for the % Buying – RANK_UNIQUE(SUM([% Buying]))
  • Prior Year Ranking – LOOKUP([Rank % Buying],-1)
  • Difference From Prior Year – IF [Rank % Buying] > [Prior Year Ranking] THEN ‘down from the prior year’
    ELSEIF [Rank % Buying] = [Prior Year Ranking] THEN ‘the same as the prior year’
    ELSEIF  [Rank % Buying] < [Prior Year Ranking] THEN ‘up from the prior year’
    END

I wanted the prior year and difference from prior year for the tooltip.

After getting the bump chart working I tested out a couple of different color schemes and found the purple to be a bit easier on the eyes than the red I had intended on using.

There is a lot more I could have done with the dataset this week, but, overall I’m pretty happy with what I created. The color scheme is different for me and I was happy with the custom shape and the bump chart. For the next few months I’m going to experiment more with the design side.

momvalentines

 

Published by

Kate Brown

golfer, yogi, history major data loving person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s