Data Lab:

Links for Data Lab

• Presentations and Some Data Examples: http://internet-librarian.infotoday.com/2019/Presentations.aspx
  • Greg's PowerPoint
  • Amy's PowerPoint
• Test Drive 1: Evaluate Data: NPS
  1. https://irma.nps.gov/Stats/Reports/Park/GLAC
  2. Choose Glacier NP YTD Report
  3. Change Month to August 2019 -or- view PDF
  4. Take a few minutes and look for anomalies, unusual changes, and possible data issues
• Test Drive 2: Data Manipulation
  1. https://www2.calstate.edu/csu-system/administration/sdlc/documents/LibStatsRpt01-02.xls
  2. Download and Open in Excel or Open in Google Sheets
  3. Delete ROW 1, 2, & 4
  4. Delete COLUMNS B through J
  5. Delete Image
  6. Excel: Select Top Row and FILTER
  7. Freeze Panes
• 7 Basic Rules for Making Charts and Graphs https://flowingdata.com/2010/07/22/7-basic-rules-for-making-charts-and-graphs/
• Test Drive 3: Pie vs. Bar
  1. Open Monterey County Educational Attainment spreadsheet in Excel or Google Sheets: https://1drv.ms/x/s!AtrxHmsEBttmhrVE0rtb8UT5qcT7wA?e=cce92U
  2. Create a Pie Chart with this data
  3. Create a Bar Chart with this data
  4. Compare How Well Each Communicates
• Does Your Data Visualization Say What You Think It Says? http://mediashift.org/2016/02/checklist-does-your-data-visualization-say-what-you-think-it-says/
• Google’s Data GIF Maker https://datagifmaker.withgoogle.com/
  • Blog Post on How/Why to Use: https://www.blog.google/outreach-initiatives/google-news-initiative/using-data-gif-maker-compare-data-and-tell-stories/
• Test Drive 4: Data GIF Maker
  • Link: https://datagifmaker.withgoogle.com/
  • Use this data

US Smart Display Market Share Q3 2019

Amazon 59%

Google 33%

Google Partners 6%

Facebook 2%

Amy's Session

• Tips for Making Data Relatable: hbr.org/2019/08/3-ways-to-help-people-understand-what-your-data-means
• Test Drive 5: Wordle: http://www.wordle.net/
• Infogram: https://infogram.com/
• Test Drive 6: Create an Infographic Using a Template on Canva or Piktochart
  • Piktochart: https://piktochart.com/
  • Canva: https://www.canva.com/
  • Dokk1 Fast Facts: https://dokk1.dk/sites/default/files/uploaded_files/Facts%20about%20Dokk1%20-%20UK.pdf
• Test Drive 7: Tableau
  • Tableau Public: https://public.tableau.com/s/
  • Data Source: https://www.edureka.co/blog/tableau-public/
    1. Download “source file” of USDA data
    2. Drag .xls over Tableau desktop icon
    3. Click “Sheet One”
    4. Experiment with clickable fields
    5. Create a range of charts under “Show Me”
• Additional Datasets for Tableau
  • https://tabsoft.co/2mCOAaM
  • https://community.tableau.com/docs/DOC-10635