This Project shows the Global Ranking of the top 2000 companies in the world based on Revenue, Profit, Asset, and Market value as of 2020, it also includes Global Rank, Country, Continent, latitude & longitude coordinates.
DATA SOURCE: kaggle.com No data cleaning required
TOOL: PowerBI
The data consists of 6 continents
60 countries
1924 companies
DAX FUNCTIONS USED (COUNT & IF) COUNT to get the total number of companies ranked globally = count(Top2000CompaniesGlobally[Global Rank])
IF was used to get the profit size profit_size = IF(Top2000CompaniesGlobally[Profits ($billion)] < 1,"low","high")
The following charts were used to visualize the dataset Multi row cards, Cards, table, Funnel chart, Column chart, Line chart to show the trend overtime, Slicers to filter, Pie chart to show the comparison between 2 values, And Maps to show the continent with the Highest Profit.
VISUALIZATION
1.Ranking top 1 in Sales is the USA with a total of $11,164 billion dollars.
With Walmart making the highest sales in 2020, followed by Royal dutch shell.
- In comparison, Total Asset generated is greater than the market value.
Total Sales made is greater than the profits made.
INSIGHTS
Total Market value: $37,630 billion
Total Profit: $2,359 billion
Total Assets: $152,973 billion
Total Sales: $37,068 billion
-
Ranking top 1 in Country is the USA with a total of $11,164 billion dollars.
-
With Walmart making the highest sales in 2020, followed by Royal dutch shell.
-
North America made the highest Sales as of 2020, using the drill down button, you get to see the country with the highest sales and profit in that continent.
-
Exxon mobil makes above 4 billion dollars in profit and is number 1 in terms of profit , followed by apple.
-
A total of 1321 companies made a profit below 1 billion
-
603 Companies made a profit aboove 1 billion
-
In Africa, South africa had the highest sales in 2020
-
In comparison, Total Asset generated is greater than the market value.
-
Total Sales made is greater than the profits made.
-
Filled Map was used to higHlight the continent with the most Profit.