07-27-2018 04:28 AM - last edited 07-30-2018 17:04 PM
Every year, Inc. magazine publishes a list of the 5,000 fastest growing private companies in America. The list, called the Inc. 5000, has existed in its current form since 2007. The Inc. list includes statistics about each company including the previous year’s revenue, industry, year founded, 3-year sales growth rate, number of employees, and the company location.
We wanted to analyze the Inc. 5000 data and share our insights on successful companies. Our analysis needed to be publicly accessible without requiring setting up and maintaining additional servers.
We created a Power BI solution to collect 11 years of Inc. 5000 data and transform it into easy-to-use interactive visuals for entrepreneurs. The Power BI solution is shared on a public URL and is open for public interaction.
We created a Power BI report that pulls data from a large data source and compiles it into interactive visuals on a publicly accessible website.
We prepared the Inc. 5000 data in an Excel spreadsheet before incorporating it into the Power BI report. We then published the report to the web, which is an option available to all Power BI Pro account holders. This allowed access to the Power BI report from any web-enabled device. This also eliminated the need to store the Inc. 5000 data on a separate database server. Finally, we embedded the Power BI report in a frame on our website.
The Power BI report loads with an overview of the compiled data for 11 Inc. 5000 lists. Users can see the total number of companies that made the lists (out of 55,000 spots), the average revenue for each company, the maximum 3-year growth, the average 3-year growth, and the minimum 3-year growth. Users can also see a ring chart displaying the most prevalent industries and a map showing the locations of companies.
The prominent buttons at the top of the dashboard allow users to select individual years or combinations of years. The statistics, ring chart, and map update automatically when a different year is selected. Users can narrow results using the search box, or sort by industry, state, or times on the list.
The second page of the Power BI dashboard contains charts detailing the age of companies when they first appeared on the list, the minimum and maximum growth rates each year, the average growth, and the median revenue of companies each successive year they make the list. Users can filter these charts by industry and state.
The Inc. 5000 Power BI report lets users interact with data that would normally occupy 55,000 lines on an Excel spreadsheet. Using Power BI, we were able to create an interactive report, accessible on any device, without requiring html coding or adding extra strain to our web servers.
Click here to learn more about our Power BI expertise.