APDU Weekly – September 8, 2022

September 8, 2022

FEATURE

Power BI Basics Training

Class Starts in 19 Days!

Power BI Basics

September 27, 29 and October 4, 6, 2022

4:00 PM – 6:00 PM ET

Hosted on Zoom

This course will provide participants with the skills necessary to take data from excel files and turn it into a finished, multi-page report ready to use internally or publish on the web. You will follow along as the instructor guides you through the process of creating a sample report. By the end of the course, you will know how to: import and format data, set up a data model, add visuals and filters, set up your page layout for PC and mobile view, and load your completed report to the Power Bi service and embed it into your organization’s website.

The course will focus on data and visualizations frequently used by workforce development and community service organizations. Regional and time series data from the Bureau of Labor Statistics and Census Bureau will form the core of the data model. Visualizations (including maps, charts and tables) will present summary level data that can be drilled down on for specific insights

NEWS

Arab Americans, Tired of Being Invisible in Federal Data, Demand to Identify as MENA, Not White 

BLS Now Publishing Monthly Data for Native Hawaiians and Other Pacific Islanders and People of Two or More Races 

Census Bureau Finishes Some Local Count Challenges 

Statistical Uncertainty Could be Problematic for Evidence-Based Policies, Study Finds 

Statement by U.S. Secretary of Labor Walsh on August Job Report 

We Welcome Your Ideas for a Better 2030 Census!

U.S. Hiring Slows but Remains Strong, as Economy Adds 315,000 Jobs

COVID-19 NEWS

How Long COVID Is Impacting the Nationwide Labor Shortage 

National Test Scores Dropped To Lowest In Decades Due To Pandemic 

‘No Man’s Land’: Long COVID Knocks Young Workers Out of the Job Market 

U.S. Life Expectancy Has Seen Its Biggest Two-Year Decline During COVID in Almost a Century, Report Finds 

NEW AND UPDATED DATA SOURCES

Improved NAEP Data Explorer Now Available

New Health, United States Website 

DATA VISUALIZATION

The Inflation Factor: How Rising Food and Energy Prices Impact the Economy

UPCOMING WEBINARS

Census Bureau 

Your Tribal Nation by the Numbers: Accessing American Indian and Alaska Native Statistics

September 27, 2022

2:00 PM – 3:00 PM ET

More Information 

Census Bureau 

Using the American Community Survey Summary File

September 28, 2022

2:00 PM – 3:00 PM ET

More Information 

Bureau of Justice Statistics

Sexual Orientation and Gender Identity Measures in BJS Survey Data Collections

September 29, 2022

1:00 PM – 2:30 PM ET

More Information 

Census Bureau

Exploring Census Data: Professional, Personal, and Other Services Sectors

September 29, 2022

2:00 PM – 3:30 PM ET

More Information 

APDU EVENTS

Association of Public Data Users

Association of Public Data Users (APDU) Annual Conference

September 20, 2022

Online or In-person

More Information

APDU Online Training Class

Power BI Basics

September 27, 29 and October 4, 6, 2022

4:00 PM – 6:00 PM ET

More Information

APDU Online Training Class

Data Visualization with Tableau

November 2 – 4, 2022

2:00 PM – 4:30 PM ET

More Information

EVENTS

Community Indicators Consortium

The Future of: Communities – CIC Impact Summit

September 20 – 21, 2022

Online or In-person

More Information

American Planning Association

2022 APA Policy and Advocacy Conference

September 28 – 29, 2022

Online

More Information

American Statistical Association

2022 Women in Statistics and Data Science Conference

October 6 – 8, 2022

St. Louis, MO

More Information

Economic Research Service

International Food Acquisition Research and Methods (iFARM) Workshop

October 20 – 21, 2022

College Park, MD

More Information 

Federal Committee on Statistical Methodology

2022 FCSM Research & Policy Conference

October 25 – 27, 2022

Washington, D.C.

More Information 

National Association of Health Data Organization (NAHDO)

37th Annual Conference – Putting Healthcare Data to Work

October 25 – 27, 2022

Virtual

More Information 

American Public Health Association

APHA 2022 – Annual Meeting & Expo

November 6 – 9, 2022

Boston, MA

More Information 

Bureau of Justice Statistics

Analyzing Data from the National Crime Victimization Survey Workshop (American Society of Criminology Conference)

November 15, 2022

Atlanta, GA

More Information

DATA PUBLICATIONS

GOVERNMENT

Bureau of Economic Analysis

• Gross Domestic Product for American Samoa, 2021

Bureau of Justice Statistics

• Indicators for Crime Estimates Using NIBRS Data

Bureau of Labor Statistics

• 79 Percent of Private Industry Workers Had Access to Paid Vacation in 2021
• Introducing Modeled Wage Estimates by Grouped Work Levels
• July Jobless Rates Down Over the Year in 383 of 389 Metro Areas; Payroll Jobs up in 99
• Spotlight on State Productivity Statistics
• Total Factor Productivity Declined in 60 of the 86 Manufacturing Industries in 2020
• Workers Age 65 and Older Account For Smaller Share of Total Work-Related Deaths in 2020

Bureau of Transportation Statistics

• U.S. Airlines’ July 2022 Fuel Consumption Down 9.5% from Pre-Pandemic 2019; Aviation Fuel Cost per Gallon Drops 8.2% in July from June 2022 All Time High
• U.S. Transportation Sector Unemployment Rate of 4.6% in August 2022 Was Below the August 2021 Level of 6.4% And Was Just Below the Pre-Pandemic August Level of 4.8% in 2019

Census Bureau

• Does Marrying Younger Mean Marrying More Often?
• Language Use in the United States: 2019
• New Survey of Income and Program Participation Available
• Who Has Retirement Accounts?

Economic Research Service

• Comparing Food Sector Employment Headcount and Sales Data in the National Establishment Time Series Database to Federal Data
• Farm Income and Wealth Statistics
• Trends in USDA Foods Ordered for Child Nutrition Programs Before and After Updated Nutrition Standards

Energy Information Administration

• EIA Expects U.S. Ethane Production to Grow by 9% In the Second Half of 2022
• OPEC Oil Export Revenues Forecast to Increase in 2022 but Decline in 2023
• Pre-Labor Day Retail Gasoline Prices Are the Highest in the United States Since 2014
• Record Numbers of Solar Panels Were Shipped in the United States During 2021
• U.S. LNG Export Capacity to Grow as Three Additional Projects Begin Construction

National Agricultural Statistics Service

• Census of Agriculture Collects Thousands of Data Points Critical to U.S. Ag

National Center for Education Statistics

• 2022 Long-Term Trend Reading and Mathematics Age 9 Highlights Report

National Center for Health Statistics

• Emergency Department Visits by Adults With Chronic Conditions Associated With Severe COVID-19 Illness: United States, 2017–2019
• Life Expectancy: Historical Trends
• Mental Health Treatment Among Adults Aged 18–44: United States, 2019–2021
• PODCAST: Life Expectancy Fell in 2021 for the Second Year in a Row
• Provisional Life Expectancy Estimates for 2021
• QuickStats: Percentage of Children and Adolescents Aged 6–17 Years Who Have Roads, Sidewalks, Paths, or Trails Where They Can Walk or Ride a Bicycle, by Urban-Rural Status and Family Income

FEDERAL RULEMAKING AND CALLS FOR COMMENT

APDU maintains a list of open calls for comment on proposed federal data collections. We periodically alert APDU members to newly added calls for comment. 

Over the last several weeks, calls for comment on the following proposed data collections were published in the Federal Register (with due date):

Bureau of Labor Statistics

• Multiple Worksite Report and the Report of Federal Employment and Wages (October 6, 2022)

Bureau of Transportation Statistics

• National Census of Ferry Operators (NCFO) (October 31, 2022)

Census Bureau

• Generic Clearance for Census Bureau Field Tests and Evaluations (September 26, 2022)
• National Sample Survey of Registered Nurses (September 17, 2022)
• Soliciting Input or Suggestions on 2030 Census Preliminary Research (November 15, 2022)
• Survey of Income and Program Participation (September 21, 2022)

Institute of Education Sciences

• National Public Education Financial Survey (NPEFS) 2022-2024 (September 21, 2022)
• National Teacher and Principal Survey of 2023-2024 (NTPS 2023-24) Preliminary Field Activities (October 3, 2022)
• School Pulse Panel 2022 Quarter 4 Revision (September 26, 2022)
• Study of the Impact of English Learner Reclassification Policies (October 17, 2022)

National Agricultural Statistics Service

• Organic Survey (September 13, 2022)

National Center for Science and Engineering Statistics

• Standard Application Process (SAP) Portal (October 31, 2022)

Office of Science and Technology Policy

• Equitable Data Engagement and Accountability (October 3, 2022)