This tutorial addresses how to find important regional industries; those that are providing lots of jobs, paying well, are unique to your region, and competitive in the national scope. In this example we’ll look for industries important to Newcastle Upon Tyne. The numbers used to determine importance will vary from region to region.
- Click Research Industries
- Click Industry Table
- Under ‘Select Industries’, choose All Available
- Under ‘Select a Region’, enter your region (example region is Newcastle Upon Tyne)
- Click Custom Data Selection and select:
- Under ‘Jobs’, select Start Year and End Year
- Under ‘Change’, select Jobs Change
- Under ‘Earnings’, select Current Total Earnings
- Under ‘Location Quotient’, select Current Year
- Under ‘Shift Share,’ select Competitive Effect
- Click Select
- Click Run
In the left sidebar options under “Timeframe” select a period including 2-3 years of historic figures. We’ll use 2012 – 2017 here. Under “Class of Worker” select Employees and Proprietors, We now have a listing of all industries in Newcastle Upon Tyne, with job counts, earnings, concentration (LQ), and competitiveness. Let’s refine this list a bit.
- In the table, click the Location Quotient column header to sort the industries by concentration
- Click Filter at the top of the table
- In the first menu bar select 2014 Jobs
- In the second menu, select greater than or equal to
- In the last menu, enter 100
- Click +Add Filter, and repeat the steps to add the following filters:
- AND >> Current Total Earnings >> greater than or equal to >> £22,000 (regional average for Newcastle upon Tyne is about £22,000)
- AND >> Competitive Effect >> greater than or equal to >> 1
- Click Apply
You now have a list of industries that employ at least 100 people, pay above average, are more concentrated in Newcastle than the national average, and are performing above expectations based on national trends.