Showcase Excel - Maven Careers

About this project

This makeover Excel dashboard - PART I is a product of the Maven Analytics course, "Advanced Excel Dashboard Design". This course is a key component of the Maven Analytics "Business Intelligence Analyst Learning Path".

The passage provides insights into the top 3 industry’s “Information, Finance and Business Services” in 2020, focusing on wages, employment share, employment trends, and geographic distribution.

Industry: Information

Wages: The industry recorded the highest average annual wages at $94K in 2020, with a notable positive trend in wages from 2017 to 2020, reflecting an 18.01% increase from $75.58K to $93.59K.

Employment Share: Despite high wages, the industry only accounts for 2% of total employees (2,677,815), with the remaining 98% (113,971,524) employed in other industries (Total # employees 116,649,339).

Employment Trend: There's a noticeable decline in total employees within this sector in 2020, marking the lowest point between 2017 and 2020.

Geospatial Distribution: Washington $242K and California $218K stand out with the highest average annual wages, while Washington 20, New York 14, California 13, and Colorado 13 have the highest number of employees per 1,000 population.

Conclusion: information industry offers high wages, it represents a small and decreasing share of total employment. Washington and California are key states in terms of both wages and employee concentration.

Industry: Finance

Wages: Finance industry recorded the second highest average annual wages at $90K in 2020, with a notable positive trend in wages from 2017 to 2020, reflecting an 12.71% increase from $77.33K to $90.04K.

Employment Share: Despite high wages, the industry only accounts for 7% of total employees (8,142,043), with the remaining 93% (108,507,296) employed in other industries (Total # employees 116,649,339).

Employment Trend: There's a decline in total employees within this sector in 2020 (0.11M) but is still higher than 2017 0.12M and 2018 0.2M.

Geospatial Distribution: New York $207K, California $124K and Illinois $122K stand out with the highest average annual wages, while New York 36, Nebraska 35, and Iowa 35 have the highest number of employees per 1,000 population.

Conclusion: Overall, the Finance industry offers high wages and a significant but relatively small share of total employment, with strong geographic disparities in both wages and employment concentration.

Industry: Business Services:

Wages: Business Services recorded the third highest average annual wages at $75K in 2020. There was a significant positive wage trend from 2017 to 2020, with an 15% increase from $64.71K to $74.71K.

Employment Share: Business Services accounts for 17% of total employees (20,065,896), making it the third-largest industry by employment share. This is notably higher than the Information and Finance industries, with the remaining 83% (96,583,443) employed in other industries (Total # employees 116,649,339).

Employment Trend: The industry experienced a decline in total employees in 2020, with a reduction of (0.89M) workers, marking nearly the lowest point since 2017, except for a similar dip in 2016.

Geospatial Distribution: Massachusetts $125K, New York $109K, and California $106K. Virginia 88, Massachusetts 85, and Colorado 76 have the highest number of employees per 1,000 population

Conclusion: Business Services industry offers competitive wages and a significant share of total employment, despite a downward trend in employment numbers in 2020. The industry is particularly strong in states like Massachusetts, New York, and California.

Overall Conclusion:

Dashboard provides insights to explore US job market by industry (10) , AVG annual wages, trend development and geospatial analysis segmented by state!

The Information, Finance, and Business Services industries all offer high wages. The Information industry has high wages but a small, shrinking employment share. Finance provides high wages with a moderate share and notable geographic disparities. Business Services has competitive wages and a large employment share, despite a recent decline. Key states across these industries include Washington, California, Massachusetts, and New York.