Published on 11/09/2022 14:25 by Adam Surette

Data Sourcing

I used this dataset from Yarana Kumar as well as a few columns I sourced manually from multiple online sources to create the data seen in this IBM Cognos Analytics Dashboard. I used Excel and Python to clean this data and create a larger dataset to explore the

Dashboard Presentation

Please watch this with the assumption that it is the start of 2023.
The video may be muted.

TLDW Summary

Overview of the top 100 companies’ revenue, growth, and industry trends in 2022:

• Top Revenue Leaders: Walmart, Amazon, and Apple dominate, with Walmart exceeding $570 billion.
• Median Wage Insights: Companies with lower revenue often pay higher wages; Walmart and Amazon employ over 1 million people each and pay some of the lowest wages. Many wages fall below the cost of living benchmarks (e.g., $96k for single-city living).
• Oil & Gas Boom: $700 billion revenue growth (+78%), dominating despite US citizen’s largeley supporting a push for renewable energy.
• E-Commerce Monopoly: Amazon’s $120 billion growth outpaces Walmart’s $45 billion gain since 2019.
• Industry Leaders: Oil and gas top total revenue share while Walmart and Amazon dominate as individual companies.
• Headquarters Clusters: Texas leads oil and gas; California dominates tech; New York excels in finance.
• Employment Insights: Oil and gas employ fewer workers but dominate revenue; retail

Written by Adam Surette