Category Archives: events

Data Visualization Fundamentals in Tableau

Virtual Training

Live Instruction Dates:
October 19, 22, 26, 29
2:00 PM – 5:00 PM ET

Agenda

PDF Registration Form

(Online registration at bottom of page)

This virtual, 12-hour course introduces economic development researchers and public data users to the fundamental concepts of data visualization using Tableau Desktop. Over the course of four sessions, you will gain familiarity with the Tableau Desktop interface and practice applying the powerful tools Tableau provides. Completing this course will equip you to import data into Tableau, perform basic analytic functions to identify patterns and answer questions, and create and share dashboards. In exploring Tableau’s range of tools, we will initially use the sample “Superstore” data that ships with Tableau. In week two, public datasets will be introduced for lessons, data challenges, and assignments. This course is designed for beginners—those who have never used Tableau before or who want to refresh their skills. No prior technical or analytical background is required.

Live, instructor-led sessions will take place from 2:00 – 5:00 PM ET October 19, 22, 26, and 29. The instructor will also offer one-on-one office hours appointments upon request.

Training pre-requisites

Skills: No prerequisite experience is needed

Tools: Laptop, wired mouse, Tableau Desktop (personal, professional, or public version)

Public version of the Tableau desktop is available at:  https://public.tableau.com/s/download

2021 APDU Data Viz Award Presentations

Are you’re a fan of attractive and useful data visualization? Attend this presentation of 2021 Data Viz Award winners to learn how some great visualizations were made. APDU gives annual awards to creative and meaningful graphic designs that use publicly available data (for example, data from the Census Bureau or Bureau of Labor Statistics) to convey a compelling point or story. Register today!

2021 Winners Include:

Equity Focus Areas Story Map, Montgomery County, MD

Pamela Zorich, Montgomery Planning Department, M-NCPPC

Jay Mukherjee, Montgomery Planning Department, M-NCPPC

Shruti Punjabi, Montgomery Planning Department, M-NCPPC

Susanne Paul, Lay of the Land Studio

Mapping Child Opportunity

Clemens Noelke, diversitydatakids.org; Institute for Child, Youth and Family Policy, Heller School for Social Policy and Management

Nomi Sofer, diversitydatakids.org; Institute for Child, Youth and Family Policy, Heller School for Social Policy and Management

Nick Huntington, diversitydatakids.org; Institute for Child, Youth and Family Policy, Heller School for Social Policy and Management

“COVID-19 Data Tool” Medicare Current Beneficiary Survey (MCBS) Interactives

Nola du Toit, NORC

Jennifer Titus, NORC

Mike Latterner, NORC

Tracking Progress Indicators Dashboard

Ben Gruswitz, DVRPC

Marc Molta, DVRPC

Becky Maule, DVRPC

2021 Annual Conference

 

AGENDA                 |            REGISTRATION

With economic, public health, and governance challenges arising from COVID-19 and political polarization, trustworthy public data is vital to open and honest policy debates. Federal statistical data is used to understand the shifting American landscape, helping make sense of the new normal at work, in our communities, in governance – the list goes on. With trust in institutions waning among some, accurate public data can help restore trust and encourage cooperation.

Register today for the APDU Virtual Annual Conference to be a part of this important discussion. APDU is where users, producers, and disseminators of government statistical data come together to learn of changes in public data, provide feedback to statistical agencies, and share best practices in the use of data.

Loading…

APDU Workshop Series: Making the Best of the 2020 Census

Virtual Workshop

Town Halls: April 14 and May 12, 2021

Trainings: June 16, August 18, and September 15, 2021

Office Hours: Biweekly beginning June 9, 2021

Price: Free

Register Here

Accurate statistics about 2020 will rely on much more than the decennial census data collection. Developing reliable data will require an understanding of challenges resulting from the pandemic, combined with greater use of non-traditional sources like administrative records. The solutions to these problems will impact how data is gathered going forward for a variety of purposes: education, housing, economic development, public health, and more.

Register today for this series of town hall events and trainings. During this workshop series you will learn more about the quality of the data that state and local leaders rely on and how you can improve and supplement it.

Town Hall #1: April 14, 2021 (3:00 – 4:00 PM ET)
2020 Census was “Different” – A Rundown of Issues

Recording

Facilitators:

  • Amy O’Hara, Research Professor, Massive Data Institute, Georgetown University
  • danah boyd, Principal Investigator, Microsoft Research & Founder, Data & Society

With the COVID-19 pandemic, political interference, and disclosure avoidance concerns, this census was deeply impacted. Amy and danah will discuss what happened with the census, where we are now, what researchers are hearing from the Census Bureau, the updated timeline, and what the Census Bureau can still fix.

Town Hall #2: May 12, 2021 (3:00 – 4:30 PM ET)
Solving Data “Differences” – Assessing the Use Cases

Recording

Summary

Facilitators:

  • Amy O’Hara, Research Professor, Massive Data Institute, Georgetown University
  • Connie Citro, Former Director, Committee on National Statistics
  • Joe Salvo, Former Director, NYC Department of City Planning
  • Chris Dick, Founder, Demographic Analytics Advisors

In this town hall, we will solicit your concerns and questions about upcoming census products – specifically about urban/rural, housing, workforce, health, and justice use cases. We will discuss data sources and methods for these different use cases. Since 2020 census products are delayed, we will discuss alternative data sources that may support population measurement.

Training #1: June 16, 2021 (1:00 – 3:30 PM ET)
Addressing the Census – Why Address Data is Crucial and How to Use It

In the first of a series of trainings focused on preparing data users to use the 2020 census data, we will begin by familiarizing the group with types of address data to lead to a high-quality census enumeration, help to validate the census publications that come out, and potentially how to mount a Count Question Resolution challenge. In this session, we will review coverage and classification issues, how to evaluate data sources and tools to assess your data.

Recording

Training #2: August 18, 2021 (1:00 – 3:00 PM ET)
Age Bins – Where to Find More Data

In our second training, we will discuss the importance of obtaining accurate data on different age categories. The Census Bureau has released demonstration data on their disclosure avoidance system; however, age bins have not been a component. Accurate age bins are critical for urban planning, public health, social research, and funding, and we know that the census has traditionally undercounted very young children and overcounted the elderly. We will discuss how possible imprecision in published census results may affect the age distribution and consider how age bins can be smoothed. We will also explore other datasets that can be used to understand key population subgroups.

Recording

Training #3: September 15, 2021 (1:00 – 2:30 PM ET)
Beyond COVID – Identifying Public Health Data to Prevent Disaster

Whether it’s a global pandemic or an overdose crisis in your community, we want to empower you with the tools and resources to identify patterns and be prepared to respond. This training will go over the new administration’s Executive Order, which datasets can drive insights around health, highlighting differences between statistical and tactical data. We will also discuss measuring migration and service utilization. With these tools, we are hoping to prepare our attendees to identify the best data and methods to deal with future public health crises or natural disasters.

Office Hours

The 2020 Decennial Census faces a number of potentially significant impacts to data quality for a variety of stakeholders with varying levels of data expertise. The Association for Public Data Users and the Massive Data Institute at Georgetown University are partnering up to facilitate Office Hours for census stakeholders. These virtual meetings are dedicated spaces to speak with a team of experts to answer questions related to census data quality. Please click on the links next to the expert you would like to schedule office hours with to be directed to a customizable calendar invite link. You can also send your questions or topic ideas to mdi-research@georgetown.edu, and we’ll be sure to find the answer or find an expert who knows the answer. All persons interested are welcome to attend. 

Meet Our Census Data Experts:

Biweekly Open Office Hours:

Amy O’Hara: General Questions, Administrative Records, Data Linkage

Every other Wednesday at 5pm (June 9, 23; July 7, 21; August 4, 18; September 1)

https://georgetown.zoom.us/j/93504860306 

One-on-One Office Hours:

Claire Bowen: Data Privacy, Differential Privacy

Schedule with Claire 

Chris Dick: Population Estimates, Administrative Data, Data Use in State and Local Government

Schedule with Chris

Ron Prevost: Administrative Records, Population Estimates, Data Privacy

Schedule with Ron

Special Topics & Emerging Issues in Public Data: Advanced Techniques to Increase Data Availability & Maintain Privacy

Big data has created complex new challenges to data privacy. One advantage of administrative big data is the enhanced feasibility of large scale record linkage. How can we make more data available to inform decision making without creating “Big Brother”? How can we inform this needed revolution in privacy protection without cutting back access to data?

In this webinar, Cavan Capps and Micah Altman will review their comprehensive analysis of an ACS use case that can be used to inform key decisions on how to protect data privacy while leveraging the latest data technologies. The results suggest that a multi-tiered access system to the data may be warranted in the future, potentially including traditional tabulations and regressions protected by Differential Privacy or variants of Secure Multi-party Computing (SMC) in software or in hardware using SGX, among other options. The webinar will  discuss some of the strengths and weaknesses of the tools mentioned above and propose how such an infrastructure might be constructed.

Finally, the webinar will provide an update on our work continuing work to examine the practical use of SGX-SMC and software based SMC for data collection and integrating shared confidential data from different sources. This enables data sharing while maintaining individual privacy of individual during any analysis. Differential privacy will be used to ensure that any outputs remain confidential.

Presenters:
Micah Altman, Head Research Scientist, MIT Libraries
Cavan Capps, Big Data Lead, U.S. Census Bureau

Fundamentals of Data Science and Visualization

Virtual Training

November 9 – 19, 2020

Classes: Nov 9, 10, 16, 17, 19 from 2:00-4:00 pm Eastern

Office Hours: Nov 9, 10, 16, 17, 19 from 4:00-5:00 pm Eastern

DOWNLOAD AGENDA

PDF Registration                                                          Online Registration

Data analysts can use a variety of methods and tools to accomplish their goals. With a deeper understanding of data visualization software packages, your organization can produce more intuitive data visualizations in less time and identify the best software solutions to optimize your team’s workflows.

In this course, we will review best practices in data visualization design and use cases for Excel, Tableau, and R (programming language).

Learn how to clean and format data in Excel, create interactive dashboards in Tableau, and clean and visualize data in R. This course will help participants identify use-cases for each software package that maximize impact with minimal effort, expanding participants’ toolbox as an analyst.

Join us to learn about how your organization can better leverage data visualization software!

Meet Your Instructor:

Lee Winkler joined the Center for Regional Economic Competitiveness (CREC) in 2018 after graduating with a Master’s in Public Policy from the George Washington University. He currently supports projects analyzing state-level certification and license attainment and the prevalence of educational and workforce credentials. Lee regularly uses Tableau to clean data, mine insights and create interactive visualizations and is excited to help the class find how Tableau can add value to their workflow.

Registration:
APDU Members: $390
Non-Members: $715

Intermediate Data Visualization Techniques in Tableau

August 25-September 3, 2020

Virtual Training

AGENDA

A picture is worth a thousand words. Use data to state your case using easy-to-understand data visualization tools. Give your audience the freedom to adapt your data in new ways in interactive dashboards that answer immediate questions and uncovers new insights. Data visualization tools can help you communicate better both internally and with your partners.

Tableau can help you produce more intuitive data visualizations, and we can show you how. In this course, you will build your skills in making appropriate graphics, but you will also incorporate complex calculations in ways that improve insights, make charts more relevant, and create the most impactful dashboard graphics.

Learn how to clean, shape, aggregate, and merge frequently used public data in Tableau Prep. Then, organize your visualizations into sleek dashboards in Tableau Desktop. We will provide helpful tips on how to analyze, design, and communicate these data in ways that will wow your supervisor and organization’s customers.

Training Prerequisites:

Skills: Participants must have a basic understanding of how Tableau works before attending this class, including knowledge of Tableau terminology, uploading data, editing data sources, and creating basic charts. Attendees should be familiar with all materials presented in the Pre-Session Videos: Overview of Charts and Calculated
Fields.
Tools: Laptop, wired mouse, Tableau Desktop (personal, professional, or public version), and Tableau Prep.
• Public version of the Tableau desktop is available at:
https://public.tableau.com/s/download
• Tableau Prep Software can be downloaded here:
https://www.tableau.com/products/prep/download

**Zoom will be required for this training – if you have Zoom restrictions for a work laptop, we recommend using a personal laptop or desktop. We do not recommend using an iPad for this training.
Pricing
APDU, C2ER, LMI Institute Premium Organizational Members $ 495
APDU, C2ER, LMI Institute Individual & Organizational Members $ 575
Non-Members $ 715

CANCELLATION POLICY: APDU must confirm cancellation before 5:00 PM (Eastern Standard Time) on August 14, 2020, after which a $135 cancellation fee will apply. Substitute registrations will be accepted.

Intermediate Application of Data Sets: BLS Unemployment Data

Did you know that there are at least three sources of unemployment statistics in the United States? In this APDU webinar you’ll learn about the three primary data sources—Current Population Survey (CPS), Local Area Unemployment Statistics (LAUS), and American Community Survey (ACS)—and how they differ. Then we’ll explore how to access the official national and state unemployment statistics, based on CPS.

Presenter:
Garrett Schmitt, Senior Economist, Bureau of Labor Statistics

Intermediate Application of Data Sets: CDC Mortality Data

Mortality data are in the news on a daily basis. Accurate data is key to tracking the spread of COVID-19. However, there are important nuances that data users need to know:

  • How are mortality data collected?
  • When are data released?
  • Where can you access the data?
  • What are the differences between provisional and final mortality data?

Register for this APDU webinar today to learn more about mortality data from the CDC.

Presenter:
Robert N. Anderson, Ph.D., Chief, Mortality Statistics Branch, National Center for Health Statistics

Intermediate Application of Data Sets: New Coronavirus Household Pulse Survey from the Census Bureau

The coronavirus pandemic is unprecedented in recent history. To meet this challenge, the U.S. Census Bureau, in collaboration with other federal statistical agencies, has developed two new experimental surveys: a Household Pulse Survey and a Small Business Pulse Survey. This webinar will provide an overview of the household survey, including the following:

  • What type of information is collected in the household survey?
  • What is the data collection method?
  • What levels of geography are being reported?
  • Where can someone find the data?

Presenter:
Jason Fields, Senior Researcher for Demographic Programs, U.S. Census Bureau