Data Analyst Intern with experience in Data Analysis, Data Cleaning & Validation, Exploratory Data Analysis, Dashboard Development, and KPI Reporting. Demonstr…
Data Analyst Intern with experience in Data Analysis, Data Cleaning & Validation, Exploratory Data Analysis, Dashboard Development, and KPI Reporting. Demonstrated ability to process over 800K+ website session records and clean sensitive datasets using SQL, Python, Power BI, and Tableau. Skilled in applying strong Communication, Leadership, and Adaptability to deliver actionable insights and impactful business solutions.
Evaluated 8,442 customer records using Python to address traditional RFM segmentation limitations, driving ₹1.26M revenue. Developed 2 customer segmentation models in Python using Pandas and K-Means Clustering to resolve RFM analysis limitations. Overcame segmentation limitations by deploying Python models, where traditional RFM identified 963 champions generating ₹0.64M, while behavioral analysis identified 1,688 shoppers generating ₹1.26M revenue. Built 4 Tableau dashboards comparing traditional and behavioral RFM segmentation, and used Python analysis to show that the most engaged customer segment also had the highest cart abandonment rate.
Examined $10.12M in revenue across 8 categories to solve pricing strategy challenges, driving optimal inventory- allocation results. Evaluated KPIs across discount bands to address deep discounting risks, maintaining 35.04% conversion while revenue per order dropped from 1,992 to 1,382. Designed a 4-panel Power BI dashboard to resolve pricing strategy challenges, tracking $10.12M in revenue across 8 categories and optimizing inventory allocation. Concluded that deep discounting was not justified by conversion gains in this dataset, since it primarily eroded revenue per order without meaningfully increasing purchase rate a finding with direct implications for margin and stock planning.
Resolved data quality challenges by purifying 800K+ web session records in SQL, executing null handling and deduplication across 16 fields. Leveraged SQL CTEs to address high bounce rates, evaluating 800K+ web sessions across 16 fields. Overcame reporting gaps by creating 4 summary tables and a 5-page interactive Tableau dashboard for 803K+ visits and 2.83M pageviews. Found Organic Search drives the most traffic, mobile lags desktop in engagement, and an overall 52.3% bounce rate points to landing page issues.