E-Commerce · Funnel Analysis · Conversion Optimisation
E-Commerce Customer Journey & Conversion Analysis
Problem: Map the full purchase funnel, identify where customers drop off, and surface the highest-impact opportunities to improve conversion yield.
Approach: Analysed 12,000+ customer interactions segmented by acquisition channel (Google, Email, Social, Direct, Referral), device type, cart behaviour, and peak activity windows. Assessed referral channel ROI and conversion rates at each funnel stage.
Output: Funnel visualisation identifying 3+ major drop-off points, recommendations for mobile checkout optimisation and targeted channel investment — projecting a 12–15% conversion yield improvement.
- Python
- Pandas
- Matplotlib
- Seaborn
- SQL
- Funnel Analysis
HR Analytics · KPI Dashboard · Attrition Forecasting
HR Metrics Analysis Dashboard
Problem: Identify key drivers of attrition and training outcomes across a workforce dataset, and surface insights HR leadership can act on.
Approach: Built KPI dashboards for performance, attendance, and training completion using SQL, Tableau, and Excel. Integrated multiple data sources, defined KPIs, and built an attrition-risk forecasting model using regression analysis.
Output: KPI views, attrition model, and an HR insights report that contributed to a 12% improvement in training completion rates and supported workforce planning decisions.
- SQL
- Tableau
- Excel
- Python
- Pandas
- Attrition Modelling
Revenue Analysis · Regional BI · Sales Dashboard
Sales Performance Dashboard
Problem: Understand revenue leakage and performance drivers across regions and product SKUs.
Approach: Analysed 10,000+ transactions across four regions to identify discounting patterns, low-margin SKUs, and seasonal performance swings. Designed KPI views and an interactive dashboard for ongoing performance monitoring.
Output: A stakeholder-ready dashboard and insight report highlighting where margin and revenue improvements are most likely — projecting a 10% revenue improvement opportunity.
- Tableau
- Excel
- SQL
- Python
- Revenue Analysis
- KPI Design