Sarprit Gaidhu

Detail-oriented Data Analyst skilled in SQL, Excel, and Power BI with hands-on experience in end-to-end data analysis projects, data modeling, dashboard creation, and advanced DAX measures. Proven ability to derive actionable insights from large datasets and deliver business-focused solutions.

General Body Member, Rotaract Club, BK Birla College, 2022-2023 

Core Organizer, Cultural Fest, BK Birla College, 2024-2025 

Event Coordinator, Research Conference, BK Birla College, 2024-2025

• Power BI & DAX, Skill Course
• SQL for Data Analysis, Skill Course, Certificate of Completion

• India General Election 2024 Analysis Power BI, SQL, Excel: Analyzed data for 543 constituencies and 900+ candidates across National Overview, State Demographics, Political Landscape, and Constituency Analysis., Applied complex SQL queries and Excel preprocessing on 100,000+ vote records to compute vote shares, margins, and candidate performance., Developed interactive Power BI dashboards with DAX measures, drill-through functionality, and bookmark navigation.
• IPL 2025 Performance Analysis, Power BI, SQL, Excel: Built a dynamic IPL dashboard: Analyzing 50+ matches and 200+ player records covering team and player insights., Integrated DAX calculations and filters for drillable team, player, and venue-based reports.
• Blinkit Grocery Sales Analysis, Power BI, SQL, Excel: Conducted sales trend analysis on 8,500+ transactions across item ratings, outlet performance, and demand forecasting., Solved 17 business-specific queries and visualized results using slicers and custom dashboards.
• Spotify Music Trends Analysis, Power BI, Excel: Analyzed 2023 top music streaming data focusing on genre and artist popularity., Built an interactive dashboard showcasing track rankings and user listening patterns.
• Hospital Operations Analysis, SQL, PostgreSQL: Explored patient, department, and expense data to generate insights on patient stay duration, medical costs, and department efficiency using SQL.