Experiment-Driven Pricing Analytics
Analyzed pricing behavior across 1,200 orders and $1.51M GMV using Python, SQL, statistical testing, and Power BI; found a 3.6% AOV uplift for the pricing variant with strongest response in Electronics and UAE. Built and deployed a live four-tab Streamlit app with a Random Forest revenue predictor and created a four-page Power BI dashboard with DAX measures, KPI cards, and slicers.
HR Attrition Risk Analysis
Quantified $4.78M monthly attrition cost by analyzing an HR dataset using Python, Pandas, Seaborn, and 10 SQL queries. Recommended retention strategies and delivered a four-page Power BI dashboard with five Python visualizations and DAX measures to identify high-risk departments.
Sales Performance Analysis
Analyzed 9,800 sales orders using Python, SQL, and Power BI; found $2.26M total revenue, 47% growth from 2015–2018, Technology as the top category, and West as the strongest region. Used SQL business questions and dashboard visuals to support revenue tracking and growth strategy.
Customer Churn Analysis
Analyzed churn, customer value, and campaign performance across 2,000 customers using Excel and Python; found a 29.4% churn rate, ₹14.75L revenue loss, and Referral as the best-performing channel at 9.1x ROI. Identified 446 at-risk high-value customers and built dashboards to prioritize re-engagement, retention, and campaign budget decisions.
Student Performance Analysis
Analyzed academic performance of 1,000 students using Python, Excel, and Power BI; found test preparation improved scores by 5–10 points and parental education correlated with higher outcomes. Built an interactive dashboard to help educators identify improvement areas and at-risk students.