Project: Data Cleaning of FIFA Dataset
Description:
Cleaned and pre-processed the FIFA 21 dataset to prepare it for data analysis, ensuring data accuracy and consistency.
Key Contributions:
- Loaded and inspected the dataset using Pandas.
- Corrected data inconsistencies, including string handling for club names.
- Identified and addressed missing values.
- Ensured proper data types across all columns.
Project: Sales Dashboard in Excel
Description:
Developed a dynamic sales dashboard in Excel to visualize key business metrics and trends.
Key Achievements:
- Created interactive dashboards displaying sales by category, monthly sales trends, and top customers.
- Analyzed year-on-year profit and sales performance by state.
- Automated data updates using Excel macros for real-time insights.
Project: Vrinda Store Data Analysis
Description:
Conducted comprehensive data analysis for Vrinda Store, focusing on sales performance, customer demographics, and order trends.
Key Achievements:
- Analyzed sales channels and order status to identify key performance drivers.
- Compared sales between men and women, and across age groups.
- Developed reports on top-performing states and overall store performance.