INC 5000 Companies Analysis

This is an analysis of the fastest growing companies in the United States in 2019. This analysis was carried out using SQL and Power BI.

The INC list shows the fastest growing companies in the US. This analysis is focused on the fastest growing 5000 companies in 2019. The revenue from the companies on this list in 2019 was $237.92bn, there were about 1m workers in the companies., and the avgerage growth rate was 454.98%. There was 5012 companies in this analysis, the companies were distributed accross 27 industries.

Analysing the Average Revenue by Company shows that Prime Pharmaceuticals generated the highest revenue of $21.4bn, Uber Technologies and Allied Universal also generate high revenue. It is important to note that there is a significant difference between the revenue generated by Prime Pharmaceuticals and the other companies. Lumber One Services generated the lowest average revenue of $35.20M. It is also important to note that Lumber One Services has only 10 workers.

Business product and services department has the highest number of companies with 492 companies. This industry generates a total of $14bn of revenue. The Computer Hardware industry has the lowest number of companies with 32 companies and generates $998M in revenue.

The average growth rate by industry shows that the logistics & transportation industry has the highest growth rate with 717.56%. The IT services industry has the lowest increase in growth rate, with 70.58%.

Looking through revenue and change in workers show that Prime Pharmaceuticals was able to generate a huge amount of revenue even though it reduced its workers. The workers at Prime Pharm went from 3900 to 3300 workers.

Analysing the change in workers shows that Allied Universal has the highest increase in workers. It is important to note that Allied Universal is not among the highest growing company or the company with the highest revenue.

Most of the companies are in North America with CA having 712 companies which is the highest number of companies. And of course, the highest Amount of Revenue is generated in North America. Most of the revenue is also generated in North America, the region with the highest number of companies.

Some of my SQL analysis shows that the health industry generates the highest amount of revenue, generating about $38.9bn, with consumer products & services coming in second with $22.7bn and the Construction industry with $20bn

Further SQL queries show that from the $38.9bn revenue generated by the health sector, Prime Pharmaceuticals generates about 54.98% of the revenue generated from this industry.

Using SQL analysis to check the percentage of revenue generated by each industry shows that Prime Pharm generated 16.36% of the total revenue, consumer products & services 9.54% and construction 8.59%.

Putting all the visuals together shiws this:

RECOMMENDATION

• An increase in workers doesn’t necessarily translate to an increase in revenue as seen in the case of Prime Pharm. It is important for Allied Universal and other companies that have significantly increased their workers to check and ensure that increase in workers translates to an increase in revenue and or growth of the company.

• The logistics and transportation industry witnessed the highest increase in average growth rate. However, the revenue from this industry is far below the revenue from the leading industry. It is important for an increase in the growth rate to translate to an increase in revenue in the long run.

• The business Products and services industry has the greatest number of companies. The number of companies here is not translating to high revenue. This could be closely looked at and worked on.

The link to the slides I prepared for this anslysis is here: https://bit.ly/3iydPEY

The link to the SQL queries is here: https://github.com/Okaks/INC_5000_Analysis