Asian-Unemployment-Rate-Project-Excel-and-Tableau-

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.

View my dashboard

1. About the project:

a. Some highlighted features that I will use when I work with Excel:

• REMOVE DUPLICATES
• TRIM WHITESPACE
• CONDITIONAL FORMATTING
• VLOOKUP,...

b. Some highlighted features that I will use when I work with Tableau:

• Symbols Map
• Multiple lines graph
• Horizontal Bar
• Building dashboard

2. About the dataset:

• There are four database in my project:

a. Labor force characteristics by Race and ethnicity:

• 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

b. Learn more, earn more: Education leads to higher wages, and lower unemployment:

• 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

c. Asian American Population by State 2022:

• 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

c. A First Look: EIG’s Distressed Communities Index:

• 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