Transcript QWI Explorer

QWI Explorer
Unlocking the Powerful Laborforce Information
of the Quarterly Workforce Indicators
Heath Hayward
Geographer
LEHD Program
What is QWI Explorer?
 Analysis tool for accessing the
Quarterly Workforce Indicators
(QWI) dataset
 All 32 indicators available in a
pivot chart/map and table
interface
 Compare, rank, map and
aggregate QWIs by time,
geography, and firm and worker
characteristics on the fly
 Companion application to the
raw data outputs from the LED
Extraction Tool
2
What’s New in QWI Explorer?
 Line Charts for Longitudinal
Analyses
 Thematic Maps for Spatial
Analyses
 Exports available for table data
(XLS and CSV), images (PNG and
SVG), geography (shapefiles), and
glossy PDF Reports
 Save Analyses via sharable URLs
or social media
 Bug fixes and improvements to UI
4
Application
Guide
Download/ Share
X-Axis
State and Indicator
Filters/ Aggregations
Line/Bar Chart or
Map
5
Group
Features of the Application
 X-Axis – Control the Rows of Table and XAxis of Chart or Geography shown in Map
 Group – Control the Columns Table and
Groupings of Chart or characteristics
shown in Map
 Filters – Refine Analysis by one
Characteristic
 Aggregations – Filter by more than one
Characteristic to Create Sums/Averages
6
Features of the Application
 Interactive
Chart/Map
 Interactive Table
Click to Navigate
Hover to Highlight
Click to Navigate
Click to Sort
Hover to Highlight
7
Click to Navigate
Longitudinal Analysis
 View Changes Over Time
 Compare Characteristics
from the Selected Group
Category
 Create Single Quarter,
Continuous, or NonContinuous Time-Series
 Filter by Geography
and/or Worker/Firm
Characteristics
8
Categorical Analysis
 Compare Characteristics
from the Selected X-Axis
Category
 Group the Chart by an
Additional Category
 Pivot Table to Transpose
Chart
 Filter by Time, Geography
and/or Worker/Firm
Characteristics
9
Spatial Analysis
 View differences across
Sub-State Geographies
 Cycle through
Characteristics from the
selected Group Category
 Filter by Time and/or
Worker/Firm Characteristics
10
Functionality In Development




Share of Total/Data Normalization
Group by Indicator
National Indicators
Cross-State Analyses
11
Tentative Release Schedule
8/2015 – Group by Indicator and Data Normalization
10/2015 – National QWIs and Cross-State Analyses
12
Useful Links
Application
 Help and Documentation:
http://lehd.ces.census.gov/applications/help/qwi_explorer.html
 Video Walkthrough:
http://lehd.ces.census.gov/applications/help/qwi_explorer.html#!video
_walkthrough
 Example Scenarios:
http://lehd.ces.census.gov/applications/help/qwi_explorer.html#!examp
le_scenarios
Data
 QWI 101: http://lehd.ces.census.gov/doc/QWI_101.pdf
 Data Notices: http://lehd.ces.census.gov/doc/QWI_data_notices.pdf
 Raw Data Access: http://lehd.ces.census.gov/data/#qwi
13
Thank You!
 Please submit feedback to
[email protected]
 Questions?
14