This repository contains the projects I completed as part of my 2-Week Fully Sponsored Data Analytics Internship at Elevvo Pathways.
The internship focused on developing practical skills in Excel, SQL, Python, and Power BI through real-world tasks.
The Elevvo Pathways Data Analytics Internship is designed to provide hands-on exposure to:
- Data Cleaning & Preparation
- Exploratory Data Analysis (EDA)
- SQL Queries & Business Insights
- Interactive Dashboards (Excel & Power BI)
- Business Storytelling with Data
I successfully completed the following tasks during the program:
- Built an interactive sales dashboard in Excel using the Superstore Dataset.
- Applied Pivot Tables, KPIs, and Charts to analyze total revenue, profit, and sales trends.
- Added slicers for Segment, Category, Ship Mode, and Year to enable dynamic filtering.
- Skills: Excel, Pivot Tables, KPIs, Data Visualization
- Performed EDA in Python using Pandas, NumPy, Matplotlib, Seaborn.
- Key analysis:
- Survival by Gender, Passenger Class, Age, and Fare
- Impact of traveling alone vs with family
- Correlation analysis of key variables
- 📊 Key Insights:
- Females had a survival rate of ~74% vs males ~19%.
- 1st class passengers had the highest survival (~62%), while 3rd class had the lowest (~24%).
- Higher fare and younger age increased chances of survival.
- Family presence improved survival rates compared to being alone.
- 🎁 Bonus: Visualized survival rates using bar plots and heatmaps
- Analyzed the Chinook Database using SQL queries.
- Exported results into Python for visualization with Matplotlib & Seaborn.
- Insights Generated:
- Top 10 Selling Products
- Revenue per Region
- Monthly Revenue Performance
- Average Monthly Revenue Performance
- Top 5 Ranked Functions (Bonus: Window Function)
- Skills: SQL, Window Functions, Python Visualization
- Developed an interactive Power BI dashboard with KPIs and dynamic filters.
- KPIs: Total Orders, Revenue, Profit, Quantity Sold, Average Discount.
- Visuals: Sales by Region, Sales by Category, Top 5 Products, Monthly Sales Trends, Sales by State (Map).
- Integrated slicers for Region, Category, Segment, Ship Mode, and Customer.
- Skills: Power BI, Data Modeling, DAX, Dashboard Design
- Excel → Dashboarding & KPI Analysis
- SQL (SQLite/MySQL) → Data Extraction & Querying
- Python (Pandas, NumPy, Matplotlib, Seaborn) → EDA, Data Visualization
- Power BI → Interactive Dashboards & Business Intelligence
These projects were completed as part of my Data Analytics Internship at Elevvo Pathways, which provided valuable hands-on experience in applying analytics techniques to real-world datasets.