Salary Analysis of US County

This project is based on a data of salary accoring to different industries. The goal of this project was analysis of average salary acros industries of different county and the requirements of the analysis was

1. Average annual salary by county displayed on a map
2. Top 5 highest earning industries by county.
3. Time series analysis of average annual salary by county.
4. Have to show on a single sheet all the above analysis.

Another challenge of the project is clean the data according to my need. Dataset contains a large ammount of data around 1,84,747 rows. First the database need filter out according to county and remove the subcategory.

Atfter the done some analysis on the given rewuirements. First create the map, average salary chart and year wise time series analysis.

Finally merge these sheets to a one sheet by using tooltip tool to map a pop-up chart according to county.

Technologies:

• - Tableau
• - Excel

Different Industries Wise Analysis

County Wise Time Series Analysis