Welcome to Portland!

The Foundations of Data Visualization in Practice

Tuesday, June 9, 2015

8:30 AM – 4:00 PM

Training Pre-requisites:
Skills:     Familiarity with MS Office & Tableau Software
Tools:    Laptop, wired mouse, Microsoft Office 2010 (or later versions)

Workshop Topics

1.       Introductions

2.       Foundational Basics

Break

3.       Visualization Methods

4.       Best Practices

Lunch

5.       Data Sources

6.       Data cleansing, rounding, making an index, analysis, confidentiality

Break

7.       Overview of Some Data Visualization Tools

8.       Practice Data Visualizations: Hands On

9.       Open Discussion Session

Where to Find Programs Used During Training

Microsoft Excel:

• Information - https://products.office.com/en-us/excel
• Google Sheets is also a very useful tool with similar properties:        https://www.google.com/sheets/about/

Tableau:

• You can download the public version of Tableau here: https://public.tableau.com/s/. To save your work, you'll have to create a username and password.

Highcharts:

• Main website: http://www.highcharts.com/
• To play around with the demos offered by Highcharts, click here:  http://www.highcharts.com/demo. Select any graph, then scroll to the bottom and hit "Edit in JS Fiddle." You can create a JS Fiddle account to save work that you've done.

Infographics:

• Piktochart is a great infographic tool: http://piktochart.com/. You can sign up for a free account today and create infographics. To remove the Piktochart watermark, you'll have to subscribe to the service, but you can still download your pictures with the watermark.
• Microsoft PowerPoint: https://products.office.com/en-us/powerpoint. PowerPoint is another way to make infographics.

Excel Example

Tableau Example

Over the year, the unemployment rate has steadily decreased across the nation. Hover over states to see which areas have seen the biggest decline in unemployment.

Workers in the construction industry suffered badly during the Great Recession. Workers in the 55-64 age group lost the fewest jobs, while those in younger groups lost more jobs. The recovery has been slowest for the younger workers.

Highcharts Example

Infographic Example