This repository contains data analytics projects completed as part of my internship at Cognorise Infotech. The projects focus on analyzing employment trends and salary distributions using Excel and Power Query for dashboard creation and data analysis.
-
Unemployment in India During COVID-19
- Objective: Analyze unemployment trends in India during the COVID-19 pandemic.
- Dataset: Unemployment in India collected from Kaggle.
- Techniques Used: Data cleaning, aggregation, and visualization.
- Tools: Excel, Power Query.
- Outcome: Created a dashboard to highlight trends in unemployment rates across various states and time periods, revealing the pandemic's significant impact on the job market.
-
Employee Salaries for Different Job Roles
- Objective: Analyze salary distributions across different job roles in various industries.
- Dataset: Employee Salaries for Different Job Roles collected from Kaggle.
- Techniques Used: Data cleaning, aggregation, and visualization.
- Tools: Excel, Power Query.
- Outcome: Developed a dashboard showing salary ranges for different job roles, job locations, employment type etc., to enable a better understanding of compensation trends across industries.
-
80 Cereals
- Objective: Analyze nutritional data for 80 different cereals and identify trends in nutrition labels.
- Dataset: 80 Cereals collected from Kaggle
- Techniques Used: Data cleaning, aggregation, and visualization.
- Tools: Excel, Power Query.
- Outcome: Created a dashboard to visualize nutritional content and highlight key patterns among different cereals.
-
Customer Personality Analysis
- Objective: Analyze customer demographics and purchasing behavior for targeted marketing.
- Dataset: Customer Personality Analysis sourced from Kaggle.
- Techniques Used: Data cleaning, segmentation, and visualization.
- Tools: Excel, Power Query.
- Outcome: Developed a dashboard highlighting customer profiles and purchase patterns for insights into marketing strategies.