Skip to content

Latest commit

 

History

History
34 lines (27 loc) · 2.45 KB

README.md

File metadata and controls

34 lines (27 loc) · 2.45 KB

Data Analytics Projects Repository

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.

Projects Overview

  1. 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.

  2. 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.

  3. 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.

  4. 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.