The Industry Table is designed to help you understand industry statistics and trends in any given region. The table table organises industries by SIC hierarchy from 1-digit down to 4-digit level. It can show data related to jobs, growth, earnings, GVA, demographics, and more.

To begin the report, decide if you would like to see data for All Available industries in the region or Limit by Industry. Then begin typing your region of choice (local authority, county/unitary authority, Government Office Region, home nation or country) and select an option from the dropdown menu, or select a region Group (Groups option).

In this example, we will be showing data for all available industries in the Basingstoke and Deane local authority area.

Next, under Select the data you would like to display, choose data groups from the provided options or click Custom Data Selection (as we did below) to narrow your results further. Here is what we used for our table:

Keep in mind that you can adjust the timeframe of the table when you’re inside the report. Once you’ve narrowed your search results, click Select. Then click Run.

The report now shows a table containing the data selected from the start page: all industries in the Basingstoke and Deane local authority by SIC code, job count, job change, average wages, location quotient, business establishment count, GVA and female representation. Clicking any one label at the top of the table will organise the data by that specific dataset–for example, clicking “GVA” will sort the table to rank industries by highest to lowest GVA.

To filter the data further, you can change the industries from 4-digit SIC to 1-, 2-, or 3-digit SIC using the button above the table; you can also explore the SIC hierarchy by selecting all levels . You can also use the Filter and Add/Remove Columns buttons to refine your search results.

Note that for industries with less than 10 jobs in the selected region, you will see “Insufficient Data” (abbreviated as “Insf. Data”) displayed in some columns. This occurs when the small number of jobs makes it impossible to calculate meaningful data for a given metric..

If you would like to pull data for the same group of industries in another report within Analyst, simply click the checkboxes on the left of the table for all applicable industries and click +Create Group. Name the group and save it for quick access in other reports.

You can also save your project or export this report using the buttons in the upper right-hand corner.