Group Projects and A Graph Remix

Dr. Nathaniel Cline

Agenda

1

Finalizing Groups for Projects

2

Data Viz Remiz

Warm-up critique

Finalizing Groups and Project

Groupings and projects

• find your group and sit with them in the back

• if you do not have a group come up front and write a topic on the board that interests you

Data Viz Remix

A Client Approaches

Creating the sample client graph

Code

dat_long %>%
  ggplot(aes(id, percent, fill = factor(type, levels = c('null', 'accuracy', 'error')))) +
  geom_col() +
  labs(
    title = 'Warehouse Accuracy Rates',
    x = 'Warehouse ID',
    y = '% of total orders',
    fill = element_blank()
  ) +
  scale_fill_manual(values = c("null" = "#000000", "accuracy" = "#FF0000", "error" = "#FFD700")) +
  scale_y_continuous(labels = ~scales::percent(., accuracy = 1), breaks = seq(0, 1, 0.1))

What is wrong with this?

• There is a lot of information here!

  • the original full data set was actually 66 warehouses

• Could we focus on just one rate?

• This is overly busy?

• No story! Is this good or bad?

• Color

• hard to see numbers??

Hit em with the Reeeeemixxxx

How to think about the remix

1. context

2. graph choice

3. declutter

4. focus

5. story

Can we build all this into a single visual?

Context

Imagine you work for a national retailer with warehouses across the United States. Recently, customers have been returning their orders at a higher volume than usual.

Your team has been tasked with investigating where the issues are happening and reporting back to the VP of Fulfillment.

Our next slide is a real slide sent back to the VP of Fulfillment.

• data is from ProTip dashboard from Q4 2021. Null = 5%
• Warehouses shown are the top volume (>200 orders fulfilled per day)
• Overall accuracy rate (all 66 warehouses) is 85%

Graph type

• is this an effective way to present the data?

• open the data set in excel/google sheets/whatever you use

• talk with your group about appropriate graph types for this data

Graph type?

• Bar chart

• Histogram

• Stacked bar chart

• Line graph

• others? Play around in excel or sketch.

Line chart?

Does this make sense if the data is not time oriented?

Vertical or horizontal?

• might allow space for the names of warehouses?

• maybe visualling more appealing?

A potential remix

Start with grey

Add reference points

Order your data

Highlight your story points

Clean up axes

Move and format axes

Align labels

Being picky about axes

Add text labels

Category descriptions

Add Story Text

Add main message as new title and subtitle

A presentation from the pros