IMPLAN Data Library

INTRODUCTION

IMPLAN has launched an improved option for comparing data across regions, industries and even time! Data Library is a new IMPLAN data product powered by Looker that allows you to produce data queries and reports.  

Access includes all of the following Data Library Sections for the all county and state level data throughout the United States for available IMPLAN Data Years (2001 - 2019 and the COVID 2020-Q2, unless otherwise noted below):

Commodity Data	Commodity Data include, for each region, Data Year, and Commodity:   foreign exports gross final demand by institution institutional sales by institution Commodity Data details from the Data Team
Core Competency Data	Core Competency Data include, for each Occupation: Knowledge Skills Abilities Education Required Work Experience Required On-the-Job Training Required Core Competency can also be viewed by Industry and by region. This section also includes Location Quotients for each Competency.  2018 Core Competency ratios are applied to Data Years 2001 - 2018 in this data set. 2019 Core Competency Data coming soon.  Core Competency Data details from the Data Team
Deflator Data	Deflator Data includes Deflators for all Data Years for Dollar Years 1997 - 2060.  This Data contains Deflators for: Output in each IMPLAN Industry Commodity Output for each IMPLAN Commodity Value Added Factor (and the components of Value Added) Trade Institutions Households Other Institutions (each government institution, Capital, Enterprises, and Inventory)  Deflator Data details from the Data Team
Demographic Data	The Demographic data include, for each region and year: number of households by 9 income categories land area population population density  Shannon-Weaver Index (S-W Index) Demographic Data details from the Data Team
Employment & Wages by NAICS (Imputed CEW Data)	The Employment & Wages by NAICS Data include the Census of Employment and Wages (CEW) data from the Bureau of Labor Statistics (BLS) with added imputed values for non-disclosures. Choose the level of granularity by selecting from NAICS levels two digit through six digit. This data includes, for each NAICS:  Employment Establishments Wages Employment & Wages by NAICS Data details from the Data Team
Environmental Data	Environmental Data include, for each Industry, the ratio of physical environment unit value per dollar of Output. This information has been applied to Industry Output across all regions, producing the amount of each Environmental indicator for each region, year and Industry.  Environment Satellites include:  Criteria Pollutants Greenhouse Gas Emissions  Land Use  Mineral Use  Nitrogen and Phosphorus Release to Water  Pesticide Emissions  Toxic Chemical Releases  Water Use 2018 Environmental ratios are applied to all available IMPLAN Data Years. Environmental Data details from the Data Team
Industry Data	The Industry Data include the following, for each region, year, and Industry: Average Employee Compensation Average Proprietor Income Employee Compensation Intermediate Inputs Intermediate Inputs as a share of Output Other Property Income (OPI) Output Output per worker Proprietor Employment Proprietor Income Taxes on Production and Income net of subsidies (TOPI) Total Employment Total Value Added Value Added as a share of Output Wage & Salary Employment Industry Data details from the Data Team
Occupation Data	Occupation Data include the following for each Occupation Classification: Average Employee Compensation Average Employee Compensation per Hour Average Hours per Year Average Supplements to Wages and Salaries Average Supplements to Wages and Salaries per Hour Average Wage and Salary Income  Average Wage and Salary Income per Hour Employee Compensation Hours Worked  Occupation Count Supplements to Wages and Salary Wage and Salary Employment Wage and Salary Income Location Quotient Regional Occupation data is a reflection of the mix of Industries in the region. 2018 Occupational ratios are applied to Data Years 2001 - 2018 in this data set. 2019 Occupation Data coming soon. Occupation Data details from the Data Team
Tax Data	The Tax Data include, for each region and year: Tax dollar value by unit of government Tax dollar value by transaction type This data provides details on regional tax authorities. Tax Data is available for Data Years 2001 - 2019. Tax Data details from the Data Team
Trade Flow Data	IMPLAN’s domestic Trade Flow Data, for each region, and year, include: Count of unique Commodities traded between regions Dollar value of trade between regions by Commodity Trade Flow Data details from the Data Team

This article will introduce you to the Data Library Help Center, along with the two dropdown menus at the top of the page: Browse and Explore. Within this support site section, find articles explaining the three main ways you’ll interact with data in the Data Library (linked below):

• Explore: where you build and run data queries in Looker by filtering, selecting, and pivoting Dimensions and Measures 
• Looks: saved reports; results of a data query
• Dashboards: collection of tiles with an answer to a particular question; answer to related Looks on one page (a collection of data query visualizations)

DATA LIBRARY HELP CENTER

Upon logging into IMPLAN, you will be directed to the Data Library Help Center Welcome Page, which includes the following:

• Welcome to the Data Library
• In Support Materials links back to this section of Zendesk
• Helpful Links
  • One for each of the designated Data Library Section pages: From each page, jump to the LookML Dashboard (created by IMPLAN developers) or to the Explore for the given Data Library Section. Each page also provides links to the articles relevant to the prospective Data Library Section here on support.implan.com.
  • Looker Support Links
    • Looker Getting Started
    • Looker User Guide
    • Looker Documentation
• Note about Login Issues with IMPLAN
• Data Library Office Hours information
• Contacts
  • Need more help? Phone support is not available, however you can email [e-mail] and expect a response within 3-5 business days.

Navigate to any of the Help Center sections from the left pane.

There are three ways to navigate back to the Help Center in the Data Library. 

1. Click on the IMPLAN logo in the upper left corner 
2. Click “Browse” and then choose “Home”
3. Click the help menu   in the upper right and choose “Looker at IMPLAN”

From the help menu you’ll also see “Docs” and “User Guide”, which will direct you to Looker’s support documentation. We recommend referencing Looker’s Docs and User Guides for Looker application functionality questions. 

BROWSE

The Browse dropdown menu allows you to access your saved reports, called Looks, and saved Dashboards. Search through all saved content by clicking the magnifying glass on the toolbar in the upper right corner.

As covered above, the first option in the Browse menu is Home which directs you to the Homepage. 

• Overview will direct you to Dashboards and Looks contained in shared folders.
• Recently viewed will direct you to a list of Looks and/or Dashboards you most recently viewed. 
• Favorites will direct you to a list of your Favorite Looks and/or Dashboards. Add items to Favorites from another folder by clicking 🤍 next to the Look or Dashboard. 
• Popular will direct you to a list of Looks and/or Dashboards accessible to you that are most frequently visited. 
• Application & Tools: underdevelopment.
• [Your Username] folder contains the Looks and/or Dashboards saved to your personal folder.  Start new Dashboards by clicking “New” from this folder. 
• All folders will direct you to a list of folders that you can access such as your folder and shared folders. LookML dashboards is where you can find Dashboards developed by IMPLAN. 

EXPLORE

Start building queries from scratch by navigating to the section of the Data Library from the Explore dropdown menu.  

 

Written October 20, 2020