Jahangir Alam
Aspiring Data Analyst | Skilled in Excel,MySQL, Power BI & Python | Turning Data into Business Insights
- Role
- Data Analyst (Project) at Ess Pee Electro Components Ltd
- Location
- Gurugram, HR, IN
- LinkedIn followers
- 500 followers
Experience
Data Analyst (Project)
Ess Pee Electro Components Ltd
Jan 2025 — Present · Gurugram, IN
Amazon Sales Dashboard (Data Analyst – Self Project)Description:• Analyzed 89K+ Amazon transactions using Power BI & Excel to uncover sales trends and customer insights.• Built an interactive dashboard with KPIs (Revenue, Category Performance, Regional Sales).• Improved stakeholder decision-making with real-time insights & automated reporting.[https://github.com/Jahangir23-Alam/Amazon-Sales-PowerBI-Dashboard] Diwali Sales Analysis (Data Analyst – Self Project) Description: • Performed EDA on 11K+ sales records using Python (Pandas, Seaborn, Matplotlib). • Applied data cleaning (null handling, type conversion) & created visualizations for customer segmentation. • Discovered that married women aged 26–35 in IT/Healthcare/Aviation were the top buyers. • Recommended targeted festive marketing strategies to improve ROI.[https://github.com/Jahangir23-Alam/Python_Diwali_Sales_analysis] Hospital Emergency Dashboard (MIS Executive – Self Project) Description: • Designed an Excel dashboard with Pivot Tables, Charts & Conditional Formatting to monitor hospital ER data. • Tracked patient admissions, critical cases & resource utilization in real-time. • Automated reports, reducing manual effort by 40% and improving hospital decision-making.[https://github.com/Jahangir23-Alam/Final-dashboard-of-Hospital-Emergency-Room] Pizza Sales SQL Analysis (SQL Analyst – Self Project) Description: • Queried a 70K+ record Pizza Sales database using MySQL & Excel. • Used Joins, Aggregations & Window Functions to analyze sales, revenue trends & customer demand. • Answered 13+ business questions (top-selling pizzas, peak hours, revenue contribution). • Identified top 5 pizzas contributing the most to sales revenue.[https://github.com/Jahangir23-Alam/PIZZA-SALES-ANALYSIS-USING-SQL]
Education
University of Delhi (DU)
Bsc (H)
2021 — 2024
Delhi University
Bachelor of Science - BSc
2022
University of Delhi (DU)
Bachelor of Science - BSc
2021 — 2024
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.