Credits to: Ye Joo Park, Sandip Sonawane from the University of Illinois Urbana-Champaign
Project Overview 📜
The Fortune 1000 is a list of the 1,000 largest American companies ranked by revenues. The list includes publicly held companies, along with privately held companies for which revenues are publicly available.
<aside>
📌 The Fortune 1000 dataset entails much valuable information for us business analysts. And in this project, I will try to discover some insights through the dataset and answer the following 17 questions using Tableau visualization.
</aside>
- What are the top 20 profitable companies?
- What are the market capitalizations of the Fortune 1000 companies?
- What are the top 20 loss-making companies?
- What are the market capitalizations of loss-making companies?
- How did the ranks change from 2019 to 2020?
- What are the top 10 companies with the largest number of employees?
- What is the total number of employees by sector?
- Are the Revenue Per Employee metrics different between specific sectors?
- What are the average profits by sector?
- How many Fortune 1000 companies are there in each sector? What is the breakdown?
- How many Fortune 1000 companies are there in each state?
- In which cities do the Fortune 1000 companies generate the most revenues?
- What are the profits of the top 100 ranked companies?