mohit sengar

mohit sengar

Data Analyst
India

About Me

Aspiring Data Analyst with demonstrated ability to build full-stack analytics pipelines — from raw data ingestion and SQL querying to Power BI dashboard delivery. Analyzed 10,000+ retail records and 150,000+ IPL match re…

PROJECTS

IPL Franchise Strategy Analysis (2008–2024)

Duration : 28-Apr-2026 - 30-Apr-2026

• Built a 3-page Power BI dashboard (Match Overview, Batting Intelligence, Franchise Strategy) simulating a real franchise consultant's decision toolkit — resolving 16 years of inconsistent team naming via Power Query before analysis. • Quantified AB de Villiers as the most valuable death-overs finisher in IPL history: 223.78 strike rate across 1,421 runs — combining volume and efficiency into a single franchise metric. • Discovered Gujarat Titans perform significantly better away (70.83%) than at home (52.38%) — the only franchise with this anomaly across 16 years of IPL data.

Superstore Sales Intelligence Dashboard

Duration : 24-Apr-2026 - 27-Apr-2026

• Built end-to-end data pipeline: cleaned raw CSV in Python, loaded into MySQL via SQL Alchemy, and wrote advanced SQL queries for KPI extraction — delivered through a 4page interactive Power BI dashboard. • Discovered that discounts above 40% consistently produce negative profit across all product categories — identifying a recurring pricing flaw with direct impact on quarterly margins. • Revealed that profit grew 85% from 2023–2026 against 51% sales growth — proving the business is becoming operationally efficient, not just scaling revenue

Certifications

Data Analytics Course

pw skills · Aligarh, India · 2026

Skills

Excel MySQL Python NumPy Pivot Tables Power BI SQL Pandas Seaborn SQLite3 Matplotlib DAX Power Query VLOOKUP Data Cleaning EDA Feature Engineering KPI Analysis Business Reporting SQL Alchemy Jupyter Notebook Google Collab Git
Report this Profile?