Manasvi Gupta

Manasvi Gupta

Data Analyst Intern

Delhi, IndiaData Analytics
5roles
45skills
4education
5credentials

About

Aspiring Data Analyst with hands-on experience in Python, SQL, Power BI, Tableau, and Advanced Excel, focused on transforming business data into actionable insights.

Experience

Data Analyst Intern

Top Notch Energy Solutions

May 2026 – Jul 2026 · On-site

Developed interactive Power BI dashboards and KPI reports; performed data cleaning, validation, and transformation using Excel and Power BI; automated reporting workflows and collaborated with stakeholders.

Coordinator

Horizon College Society

House Captain

Senior Coordinator

Team Horizon

2 yrs 4 mos

Summer Intern

Top Notch Energy Solutions

3 mos · Ghaziabad, Uttar Pradesh, India

Education

Ajay Kumar Garg Engineering College

B.Tech, Computer Science and Engineering (Data Science)

2023–2027

CGPA: 8.77/10

St. Thomas’ School

CISCE Class XII

2022–2023

88%

St. Thomas’ School

CISCE Class X

2020–2021

97%

St. Thomas' School Gopiganj Bhadohi

Apr 2017 - Apr 2023

Skills

PythonSQLC++PandasNumPyMatplotlibSeabornScikit-learnExploratory Data AnalysisData CleaningFeature EngineeringStatistical AnalysisPower BITableauAdvanced ExcelPivot TablesPivot ChartsPower QueryXLOOKUPINDEX-MATCHDashboard CreationMySQLGitGitHubVS CodeJupyter NotebookDAXEvent PlanningData VisualizationMatch ReportsData AnalyticsNatural Language Processing (NLP)DashboardsSentiment AnalysisSports AnalyticsData ScienceMicrosoft ExcelLeadershipSQL Database AdministrationHTMLPandas (Software)Microsoft OfficeProblem SolvingPython (Programming Language)Oratory

Projects

Sales Performance Dashboard

Designed an interactive sales dashboard using Advanced Excel, Pivot Tables, Pivot Charts, Power Query, slicers, and advanced formulas. Analyzed sales, revenue, profit, and regional performance; automated KPI reporting; and created dynamic product-wise and region-wise reports.

Customer Churn Prediction

Performed exploratory data analysis on 7,000+ customer records using Pandas, NumPy, and Seaborn. Built a Logistic Regression model with nearly 80% prediction accuracy and applied feature engineering, preprocessing, missing value handling, and categorical encoding.

Open Access Energy Consumption Dashboard

Developed an interactive Power BI dashboard using Power BI and Excel to monitor energy consumption, billing, and financial KPIs. Created DAX measures, drill-through reports, bookmarks, and slicers, and integrated multiple Excel datasets using Power Query.

IPL Analytics Dashboard

IPL 2022 Batting Analytics Dashboard | Power BI • Analyzed 1,500+ IPL matches & 20,000+ ball-by-ball records • Built DAX KPIs: Strike Rate, Dot Ball %, Economy, Total Runs • Created interactive slicers for season, venue & batting team • Delivered player & team-level batting insights Tools: Power BI, DAX, SQL, Excel