I will clean, analyze, and visualize my Asian Unemployment Rate dataset in this project using Excel and Tableau. This project aims to determine the relationship between educational level, geography, and unemployment rate.
- REMOVE DUPLICATES
- TRIM WHITESPACE
- CONDITIONAL FORMATTING
- VLOOKUP,...
- Symbols Map
- Multiple lines graph
- Horizontal Bar
- Building dashboard
- There are four database in my project:
- Source: U.S BUREAU OF LABOR STATISTICS
- Overall: The page has data about the Unemployment rate, Educational attainment by Race
- Tool: Excel to clean data, Tableau to visualize
- Source: U.S BUREAU OF LABOR STATISTICS
- Overall: This database contains information about the unemployment rate of different degrees.
- Tool: Excel to clean data, Tableau to visualize
- Source: World Population Review
- Overall: This database contains information about the percentage of Asians in each state in America.
- Tool: Excel to clean data, Tableau to visualize
- Source: Economic Innovation Group
- Overall: This database contains information about the states/cities that are economically distressed.
- Tool: Excel to clean data, Tableau to visualize