Intensive Study, Fall, 2019: Data Visualization

Updated 2019-11-08

Day #11: Friday, 11/08/2019: Dashboards

·         Some charts to check out.

·         Dashboard notes. Data file.

Homework due 11/15/2019 at 8:00

·         Problem description. Data file: Coffee Chain sales and profit.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #10: Friday, 11/01/2019: Tableau pie charts, tree maps

·         Notes

·         Sample file: Super Store Sales Training

Homework due 11/08/2019 at 8:00

·         Pie chart and tree map. Instructions. Use the Super Store Sales Training file linked to above. Put your tbwx (NOT tbw) file in the drop box.

Day #9: Friday, 10/25/2019: Highlight Tables, Heat "Maps"

·         When the U.S. converted to the metric system.

·         Notes

·         Sample file: Super Store

Homework due 11/01/2019 at 8:00

·         Problem description. Data files: London CO2 emissions, Coffee Chain sales and profit. Put your tbwx (NOT tbw) file in the drop box.

Day #8: Friday, 10/18/2019: Tableau Maps

·         Notes

·         Sample file: Super Store

Homework due 10/25/2019 at 8:00

·         Earthquakes instructions. Earthquakes data. Put your tbwx (NOT tbw) file in the drop box.

Friday, 10/11/2019: NO CLASS. Fall break.

Day #7: Friday, 10/04/2019: Tableau Dates, Box Charts

·         Notes

·         Sample file: Super Store

Homework due 10/18/2019 at 8:00

·         Des Moines Weather. Put your tbwx (NOT tbw) file in the drop box.

Day #10: Friday, 11/01/2019: Tableau Dashboards

Homework due 9/27/2019 at 8:00

Day #9: Friday, 10/25/2019: Tableau Maps

Homework due 9/27/2019 at 8:00

Day #8: Friday, 10/18/2019: Tableau Crosstabs & Heat Maps

Homework due 10/25/2019 at 8:00

Day #6: Friday, 9/27/2019: Tableau

·         Sample files: UK Banking, Math scores

·         Notes

·         Math scores video

Homework due 10/04/2019 at 8:00

·         American League RBIs. Instructions. Data file. Hand in the tbwx (NOT tbw) file in the drop box.

Day #5: Friday, 9/20/2019: Tableau Calculations

·         Notes

·         Sample file: Super Store

Homework due 9/27/2019 at 8:00

·         1961 Yankees home runs. Instructions. Data. Put your tbwx (NOT tbw) file in the drop box.

Day #4: Friday, 9/13/2019: Tableau

·         Sample files: NYC trash, NYC Population

·         Notes

Homework due 9/20/2019 at 8:00

·         Cell phone usage. Instructions. Data. Put your tbwx (NOT tbw) file in the drop box.

Day #3: Friday, 9/06/2019: Intro to Tableau

·         Getting Tableau

·         Sample files: NYC trash, NYC rats, Super store

·         Notes

Homework due 9/13/2019 at 8:00

·         Creating a life expectancy chart with Tableau. Instructions. World indicators file.

Day #2: Friday, 8/30/2019: Data visualization in Excel

·         Intro to data visualization (video)

·         Effective and ineffective charts (video)

·         Excel charts

·         Interesting books: check out some books by Edward Tufte

Homework due 9/6/2019 at 8:00

·         Creating charts in Excel (combo chart, scatter plot). Airline combo chart data. S & P scatter plot data.

Day #1: Friday, 8/23/2019: Data visualization

·         Syllabus

·         Textbook: None. Tableau 8, The Official Guide. 978-007-181-678-6. $26.98 from Amazon.

·         Software: Excel 2019/365 (free for BCU students), Tableau free

·         Read about data visualization.

·         Examples. I don't think that all of these are good examples. (My definition of a good example is one that doesn't require reading a lot of instructions.) What do you think?

·         The five most famous data visualizations of all time.

·         Here's a better view of the cholera map.

·         And the Napoleon map.

·         And Florence Nightingale's war mortality map.

·         State to state migration

·         CO2 emissions

·         Racial percentages by generation

·         Satellites orbiting earth right now

·         Hans Rosling: How not to be ignorant

·         Hans Rosling: The best statistics you've ever seen

·         Hans Rosling: 200 countries, 200 years

·         Hans Rosling has written a book: Factfulness. EVERYBODY should read this book!

·         Here's another book everybody should read: The Design of Everyday Things.

·         NY Times: How people spend their day

·         Visualizing words

·         WordCloud

·         TagCrowd

Homework due 8/30/2019 at class time:

·         Take the graph design IQ quiz. Record your answers (there are 10 questions). Get a screenshot of your score. Put your screenshot and your answers into a Word document. Put the Word document in the drop box.

·         Find the full text of 2 State of the Union speeches 10 years apart. Create a WordCloud for each speech (2 Wordles), and a TagCrowd for each speech (2 TagCrowds). Get screenshots of all four results (trim them appropriately) and put them in the Word document you created earlier. Include a URL for each speech. Which tool do you think is better at comparing the two speeches and WHY? Put a one-paragraph answer in your Word document. Put the Word document in the drop box.

·         Read about how to lie with graphs. Watch the Hans Rosling videos (above). Expect a quiz.

Week 3: Chapter 4: Connections, basic chart types

Get free copy of Tableau

Chart chooser

Choose the right type of chart for your data

Cool visualizations (some links are bad)

Create several (2) kinds of charts

What you can do in Tableau: http://www.tableau.com/public/gallery

Tableau training videos (from Tableau): http://www.tableau.com/learn/training

Week 4: Chapter 5: Filters and parameters

Week 5: Chapter 6: Maps

Week 6: Chapter 7: Calculated fields

Week 7: Chapter 8: Creating dashboards

Week 8: Chapter 9: Sharing

Project

Other tools: Excel add-on

Day #3: Friday, 9/06/2019: Data visualization in Tableau

Video: Essential Design Principles for TableauHomework due 2/20/2015 at 5:00 p.m., Week 1, Types of Visualizations, 5 minutes

·         Standard & Poor's index vs. earnings. Put your Excel file in the drop box.

Homework #3: Tableau line charts

Homework due 3/06/2015 at 11:30 p.m.

Homework #4: Tableau Quick Filters (Chapter 5)

Homework due 3/27/2015 at 11:30 p.m.

Homework #5: Tableau Maps (Chapter 6)

Homework due 4/10/2015 at 11:30 p.m.

Homework #6: Calculated Fields (Chapter 7)

Homework due 4/24/2015 at 11:30 p.m.

Homework #7: Calculated Fields (Chapter 8)

Homework due 5/08/2015 at 11:30 p.m.

·         Dashboards. Put your tbw file in the drop box.