visualizing data comparisons - pasdc conference · • a collection of graphs, maps, and tables...

Visualizing Data Comparisons: A Case Study Using the Pennsylvania Autism Needs Assessment

Paul Turcotte, MPHKate Verstreate, MPH

Pennsylvania Autism Needs Assessment Background

3 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment

• Goal: Quantify and qualify service experiences and needs• Pairs with the Pennsylvania Autism Census

– Administrative census – Cross-system data

• Link to 2010 Pennsylvania Autism Needs Assessment • Funded by Pennsylvania Bureau of Autism Services

– Initiatives include: • Adult Community Autism Program (ACAP) • Adult Autism Waiver • Autism Services, Education, Resources, and Training Collaborative (ASERT) • Special Populations Unit

4 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Distribution

• Letters mailed to Medicaid-enrolled individuals with an ASD claim/encounter • Distributed via

– Social media – Listservs

• Provider Organizations in PA• Behavioral Health Partners Partner organizations• PA Department of Human Services

– Office of Mental Health and Substance Abuse Services (OMHSAS)– Office of Developmental Programs (ODP)– Office of Medical Assistance Programs (OMAP)

• Available online or in paper copy• Translated into 22 languages

5 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Survey Domains

• Demographics

• General Health

• Health insurance

• Hospitalizations

• Justice system interactions

• Child welfare/foster parent

• Activities of Daily Living

• Employment

• Living Situation

• Education

• Long Term Planning

• Service Use

• Transportation

• Advocacy/Community Engagement

6 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Respondents

7 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Respondents

8 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Respondents by Age

0

50

100

150

200

250

300

350

< 5 9 14 19 24 29 34 39 44 49 54 59 64 69 74

Num

ber o

f Res

pond

ents

Age

Caregiver Individual

Data Visualization

10 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Data Visualization

• Consolidating robust survey results into digestible, usable products• Several target audiences

– Individuals/Families with ASD – Policy Makers – Research community

• Important to allow end users to interact and manipulate data

11 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Static Graphing

• Inefficient for large amounts of data

• Not as engaging for end users

• Still necessary in certain cases– Publications – Printed materials – Reports

12 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Community Participation Figure

13 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Community Participation Figure

14 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Advantages of Dynamic Graphingin Tableau

• Efficiency– Point and Click software – No need for multiple graphs/reports

• Allows for large amounts of data to be presented in a compact view

• Filter to see data that is of interest • Easily make comparisons between groups • View changes in data over time

15 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Tableau Dashboards

• A collection of graphs, maps, and tables that are linked together through the data

• Filters on demographics or specific responses can be applied to one or multiple graphs on a Dashboard, resulting in a custom report

• Useful for both internal and external reporting

16 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Internal Dashboard

Dashboard Filters

17 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Mapping in Tableau

• Create maps more quickly and easily than most other mapping software

• Several types of maps – Choropleth maps, Heat Maps, XY/Address locations, Animated

Maps, etc. • Tooltips allow for more data to be presented • Ability to use maps as a filter for Dashboards

18 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Pennsylvania Autism Needs Assessment: Philadelphia Service Needs Map

19 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Animated Graphs & Maps

• Allows end users to seamlessly see how data changes over time

• Can be applied to Maps and Graphs

• Helpful when looking at data comparing dates or ages

20 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Tableau Public & Embedding Dashboards

• Tableau Public allows for Dashboards to easily be embedded into webpages

• Allows for results to reach more people

Tableau Exercise

22 | Visualizing Data Comparisons: A Case Study Using the PA Autism Needs Assessment

Tableau Resources

• Tableau Public – https://public.tableau.com/en-us/s/

• Tableau Resource Library – https://www.tableau.com/resources

• Tableau YouTube - https://www.youtube.com/user/tableausoftware

www.phillyautismproject.orgPhillyAP@drexel.edu

Support group map

www.paautism.orginfo@paautism.org

Resource bundles: www.paautism.org/act62

www.paautism.org/justice