ANALYSE is the quickest way to understand a list of companies on our platform.
Table of Contents
| Introducing Analyse |
| Starting Points for Analysis |
| The Analysis Summary Box |
| Locations |
| Website Analysis |
| Company Details |
| Jobs and Skills |
| RTICs and Sectors |
| Financials |
Introducing ANALYSE
ANALYSE is the home of summary statistics on our platform. ANALYSE offers the ability to conveniently understand the total employment, amongst many other metrics, of a list of companies.
The list of companies could be in the form of companies in an RTIC, a machine learning list that has been built, or simply a list of company numbers.
The creation of summary statistics requires careful interpretation and careful consideration of the companies that are included in a list.
This article will provide a summary of the considerations to be made for each data point, with more detail available in the relevant Knowledge Base article for that data point.
Starting points for analysis
Analysing RTICs
The filter bar, shown above, contains all of the filters you need to hone and then analyse your list. From here you can choose to analyse RTICs.
Analysing Personal Lists
If you have created your own Machine Learning (ML) list using our tool, then you can also analyse these here. Click lists in the top left, and from the dropdown, select the ML list you have created.
Analysing a List of Company Numbers
If you want to quickly get a sense of the size of a set of companies you can paste in a list of Company House numbers.
In the Companies filter, select the COMPANY NUMBERS tab, and paste your list of company numbers into the box at the bottom. Click update and you will now analyse these companies.
How to save a list? If you want to access this view again, you can save these companies as a list. At the top of the page, select VIEW LIST.
Then from the dropdown, select SAVE LIST. Give your list a name and click save. From here you can share your list with other platform users. Sharing is caring, especially with lists. How do I share a list?
Click SHARE LIST, and enter the email address of the user you would like to share the list with. The list will appear under the user's MY LISTS page. Users are not automatically notified that a list has been shared with them.
The Analysis Summary Box
When you analyse the list or RTIC that you've selected, the first thing you'll see is the Analysis summary box. This is shown below.
Within ANALYSE, the summary box is the quickest way to understand a list. There is one thing to bear in mind when interpreting these numbers: employee count and turnover includes multination organisations. This means that summary statistics should not be taken at face value.
Companies Considered: The unique number of companies in the list.
A company can be in multiple RTIC verticals or multiple RTICs. You can use companies considered to report the total number of companies without double counting.
Total Employees: The number of employees that belong to the companies in the list. Not all companies have declared employees for every year. The Data City estimate employees where it is accurate to do so. The number of companies for which employees are declared and estimated are also provided.
Total Turnover: The total turnover of companies in the list. This will include global turnover, for UK registered multinational companies. This turnover is across all of a company's operations and is not specific to a selected RTIC.
Total Investment Funding: This is the total amount of funding received by the companies, according to Dealroom. Get more information on this data.
Total Innovate UK Grant Funding: This is the total value of Innovate UK grants won by companies in this list.
Estimated Growth Per Year: The Data City provide an estimate of growth for companies in the list. This is based on a combination of turnover and employment.
Best Estimate Total GVA: The Data City provide an estimate of Gross Value Added for the list of companies or selected RTIC. Please read this note before using this metric in your analysis.
Estimated GVA Per Employee: This is the estimated Gross Value Added per employee. Please read this note before using this metric in your analysis.
Women Founded Companies: This contains information on the number of women founded companies, the number of women led companies, and the number of women directors. Read more on this information. The asterisked number refers to the total number of directors.
Locations
You are able to analyse the following geographies on our platform: local authorities, OECD functional urban areas, constituencies, LEP and ITL1 and ITL2 regions. Make sure you understand the differences between these geographies.
You can analyse the geographical distribution of businesses, employees and turnovers.
Employees and turnovers are split equally across locations for multi-site companies.
If you apply a filter to your analysis, for example, looking at a specific sector, or apply financial criteria, you'll be able to analyse using location quotients.
NOTE: It is possible to download the data behind many of the visualisations, by clicking the download button in the top right corner of the widget.
Website Analysis
As you scroll down the page, the next tab is Website keywords.
From the field dropdown you are able to choose either sector keywords or innovation keywords.
What are sector and innovation keywords?
Sector keywords are from a dictionary of keywords that we created alongside partners. Sector keywords identified the keywords for 18 broad sectors and themes.
Innovation keywords are keywords associated with innovative processes. The keywords range from "new markets", "continuous professional development" and "lean".
The Data City have scraped up to 90 pages of website text for companies. We then count how many times the sector or innovation keywords are mentioned; this is the keyword count.
Keyword enrichment
Keyword enrichment is a measure of how overrepresented a key word is compared to the average website. In this case "small molecule" is found 1209% (or 13x) more than the typical website.
Sector keywords are not keywords from the machine learning output. If you are interested in machine learning based keywords for a list that you have made, you should read about the classifier terms.
Company Details
The following tab contains demographic information on the companies.
From the field dropdown, you can choose to look at data related to people, company growth, or founding dates.
People
Business counts by founder gender
The business counts by founder gender contains a breakdown of business counts by the founder type. Get more information on the founder data, including an explanation of why there are no known founders.
Company size by employees and employees by year
Company size by the number of employees shows the distribution of employees. In this case there are 1400 companies with zero (or unknown) employees.
Employees by year is the total employment of the list or RTIC. The dashed line shows our estimated value of employees. The solid line is the measured level of employees. Read more on why we estimate turnover and employment.
You can change the line chart to a bar chart using the controls at the top of the widget.
Company growth
Company size
The distribution of company sizes. This takes into account the number of employees as well as turnover to define company size. Specifically, it uses the Companies Act 2006 definition.
Company growth rate
This shows the distribution of growth rates for companies. For example, there are 508 companies in this list that are shrinking fast.
Founding dates
The last field of company details looks at the founding dates of companies.
At the time of writing The Data City only track active companies. Younger companies are more likely to be active than older companies. This can suggest that the sector is growing quickly in business count, but older companies have dissolved.
The Data City are working to add company births and deaths, so the rate of incorporation over time can be more accurately tracked.
Jobs and Skills
We partner with Lightcast to be able to offer granular labour market insights on our platform. If you have subscribed for Lightcast, you will see widgets focussed on jobs and skills.
SOC4 code
Our widgets here show the job postings and average advertised salary by Standardised Occupational Code (SOC). Think SIC, but for occupations.
Skills
We show the number of advertised job postings for:
These are advertised job postings and may not necessarily be filled positions.
RTICs and Sectors
We provide a breakdown for all types of sectors on our platform: RTICs, CICs and SICs.
It's worth noting that a company can be in multiple RTICs, CICs, or SIC codes. The visualisations here show the number of companies in a sector. This does not remove double counting.
At the time of writing, there are 212,000 companies that are in an at least one RTIC. Because a company can be in multiple RTICs, or multiple RTIC verticals within the same RTIC, if you sum the data from the widgets below, you will be double counting. Summing RTIC sector counts results in a number of 280,000. Be aware of double counting here.
Financials
Our final tab focusses on financial details and funding information.
Financial details
Net worth: Total current assets - Total liabilities for companies in this list.
Turnover by year: Total revenue for companies in this list
Profit after tax: Profit after tax for companies in this list. Not all companies declare this. A more simplistic method of estimating profit after tax is used.
Total current assets: Assets that can be converted into cash in the next year.
Total liabilities: Total amount due.
Funding
Total investment funding by year: The value of funding received in each year, from Dealroom.
Total investment funding rounds by year: The number of rounds of funding in each year. Some rounds do not have data on the amount raised.
Total Innovate UK grants by year The value of Innovate UK grants received by this list.