Aspiring Data Analyst skilled in Microsoft Excel, SQL, Python, Power BI, and Tableau. @HumzaAfzal
In this project, I used MySQL to clean and organize data on global layoffs by removing duplicates, handling missing values, and normalizing the data to ensure accuracy and consistency for further analysis. The dataset, acquired from Kaggle, includes data from March 2020 (when COVID-19 was declared a pandemic) to March 2022.
In this project, I used MySQL to conduct Exploratory Data Analysis (EDA) on global layoffs from March 2020 to March 2022, using data from my Data Cleaning Project. The analysis addressed various questions, including identifying which companies laid off 100% of their workforce, determining the number of employees affected, and exploring trends and patterns across different industries.
In this project, Python is used to scrape data on the largest companies in the United States by revenue from Wikipedia. The data is then cleaned and organized into a DataFrame using the Pandas library.
This project utilizes Tableau to create a dashboard containing information about 2016 AirBnB Listing Data. The dashboard answers questions such as prices by ZIP code in the U.S. and average prices for different bedroom counts.