Workshop Prezi:

Video of Workshop:

Poster for Workshop

Data Vis.dig.sign

Files for Workshop

Workshop-Excel-Files
Tableau-Excel-Files


Mohonk Preserve Weather

  1. Freeze header row
  2. Make font condensed
  3. Observe data types
  4. Apply conditional formatting: categorical and diverging

********************************

Highest Grossing Films

  1. How does Titanic stack up?
  2. Freeze header row
  3. Make font condensed
  4. Observe data types
  5. Apply conditional formatting: categorical and diverging (optional)
  6. Data > Filter > genre > Drama
  7. Data > Sort > Worldwide gross
  8. Make pivot table: genre for rows; budget for values
  9. Copy and paste in new worksheet > paste values only
  10. Make a chart of this data

********************************

Titanic passengers

  1. Who was most likely to survive the Titanic? Who was least likely to survive the Titanic?
  2. Freeze header row
  3. Make font condensed
  4. Observe data types
  5. Apply conditional formatting: categorical and diverging (optional)
  6. Data > Filter > column attribute > ?
  7. Data > Sort > column attribute > ?
  8. Make pivot table: 1, 2, and 3 class for rows (count); survived (sum) for values; filter by demographic category
  9. Duplicate worksheet and make a new pivot table
  10. Copy into new worksheet and paste values only. Sort and clean data. Transform into percents if need be (normalize data
  11. Make a chart of this data

Resources

Data-Visualization-Resources
data-design-infoactive
Korenblat-Data-Visualization-Principles-3-15-16