1 / 42

Lee De Cola

DATA to Insight. Lee De Cola. schedule. ....spreadsschedule_daily.xlsx. introductions all ‘round …. name from? studying interests something interesting…. PART 1: BASICS. Principles of datagraphic design. 1. All data represent one of 3 dimensions : WHAT | WHEN | WHERE?

sonel
Download Presentation

Lee De Cola

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATAtoInsight Lee De Cola

  2. schedule ..\..\spreads\schedule_daily.xlsx

  3. introductions all ‘round… name from? studying interests something interesting…

  4. PART 1: BASICS

  5. Principles of datagraphic design 1. All data represent one of 3 dimensions: WHAT | WHEN | WHERE? 2. Every datagraphic visualizes a relationship among the dimensions. 3. There is an appropriate visualizationfor every relationship. 4. The visualization should be efficiently designed. 5. The design should reveal the insight.

  6. 3 dimensions of data WHAT? PHENOMENON WHEN? TIME WHERE? SPACE

  7. PART 2: TIME

  8. time series 318 322 328 334 341 349 356 364 373 384 392

  9. CO2 for half-decades period mean 1955 316 1960 319 1965 323 1970 329 1975 335 1980 343 1985 351 1990 358 1995 366 2000 375 2005 386 2010 393

  10. Excel default (semidec)

  11. Excel reformatted scrippsco2.ucsd.edu

  12. two axes ppm difference

  13. Insights exponential 1.6% growth per year ‘historical’ value about 155 seasonal max in May (beginning of net primary productivity) min in Oct (beginning of heterotrophic respiration)

  14. 60-month means

  15. time serieshandout12 x 10

  16. 1 2 3 4 5 6 7 8 9 10_ 1: 20.3 21.5 22.1 22.9 24.0 23.3 21.6 19.6 18.0 18.1 11:19.7 21.2 22.4 23.1 23.5 24.9 25.6 25.4 24.0 21.5 21:20.7 20.2 22.1 23.8 24.7 25.6 26.1 27.6 28.4 28.1 31:26.6 24.5 23.0 23.0 24.3 25.7 26.8 27.4 28.4 30.5 41:30.6 29.6 27.8 25.8 24.1 24.2 25.8 27.4 28.3 29.7 51:30.4 32.1 32.2 32.1 30.6 28.7 26.4 26.8 28.3 30.0 61:31.4 32.0 32.6 34.4 34.9 34.0 32.3 30.5 28.8 29.1 71:30.2 31.6 32.5 33.7 34.3 36.3 36.4 35.9 34.4 31.8 81:30.9 30.9 32.4 33.6 35.1 35.9 35.8 36.8 38.5 38.1 91:36.3 34.1 33.1 32.8 34.0 35.1 36.6 37.1 38.5 39.6 101:40.2 39.6 38.1 36.1 34.7 34.3 36.1 37.5 38.6 40.1 111:41.0 42.4 43.2 42.2 40.3 38.5 36.8 37.2 38.7 39.8 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

  17. CO2, Mauna Loa Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec_ 2001 370.3 371.5 372.1 372.9 374.0 373.3 371.6 369.6 368.0 368.1 369.7 371.2 2002 372.4 373.1 373.5 374.9 375.6 375.4 374.0 371.5 370.7 370.2 372.1 373.8 2003 374.7 375.6 376.1 377.6 378.4 378.1 376.6 374.5 373.0 373.0 374.3 375.7 2004 376.8 377.4 378.4 380.5 380.6 379.6 377.8 375.8 374.1 374.2 375.8 377.4 2005 378.3 379.7 380.4 382.1 382.2 382.1 380.6 378.7 376.4 376.8 378.3 380.0 2006 381.4 382.0 382.6 384.4 384.9 384.0 382.3 380.5 378.8 379.1 380.2 381.6 2007 382.5 383.7 384.3 386.3 386.4 385.9 384.4 381.8 380.9 380.9 382.4 383.6 2008 385.1 385.9 385.8 386.8 388.5 388.1 386.3 384.1 383.1 382.8 384.0 385.1 2009 386.6 387.1 388.5 389.6 390.2 389.6 388.1 386.1 384.7 384.3 386.1 387.5 2010 388.6 390.1 391.0 392.4 393.2 392.2 390.3 388.5 386.8 387.2 388.7 389.8

  18. data source scrippsco2.ucsd.edu/data/atmospheric_co2.html

  19. Yearly mean

  20. 1.6% per year

  21. PART 2: MEASUREMENTS

  22. World Health Organization The world health report 2002 - Reducing Risks, Promoting Healthy LifeAnnex Table 1: Basic indicators for all Member States http://www.who.int/whr/2002/annex/en/ Annual population growth rate (%) Female life expectancy at birth country names and FIPS codes from ESRI…

  23. Excel default

  24. Yemen WHO :The World Health Report 2001

  25. comparison EXCEL default redesigned_______ legend right inside plot area limits -3 to + 4 -4, + 4 v axis format 3 sig fig 1 sig fig h axis at zero at -4 formatyyyy-mm-dd mmm-dd fillcolors all:dark plot: light exhibit: dark legend transparent gray title none title + year gridlines dark, at .5 light, at 1

  26. PART 3: SPACE

  27. Regional Density region density Alpha 99 Beta 51 Delta 86 Epsilon 71 Gamma 281 Kappa 29 Lambda 35 Mu 74 Pi 73 Rho 256 Sigma 112 Tau 61

  28. ARC MAP default redesigned_____________________ decimal places 6 0 breaks 4 2 breaks 35, 61, 86, 112 70, 90 big values bottom top colors last used? light to dark (gray OK) MAP VIEW legend transparent gray ‘Legend’ layer name title, ‘density’ scale bar divs4minor + 1 major divs 1 units DD 200 km labels ends above

  29. assignment content • create an original datagraphic from real data • (optional) sketch of your datagraphic • default result (Excel, Arc, QGIS, SAS, R, etc.) • redesigned result • answer the 5 principles as questions – see ldecola.net/d2i • provide sources of data, other references • ~1000 words

  30. assignment details due 2014 April 3 Send it to LDECOLA@COMCAST.NET So that I can easily identify your submission, please name the file as follows:flname.ext, where f = first letter of your first name lname = your last name, and .ext is the file extension (.doc, .pdf, .ppt, .zip, etc.)You are welcome to create an HTML document and post in on the web, sending me the URL.

  31. Lee De Cola LDECOLA@COMCAST.NET

More Related