Project 1: Supply Chain Analysis
The project focuses on analyzing supply chain operations for a retail business using real-world data. Using Power BI, the analysis explored delivery times, return rates, shipping modes, and regional logistics performance. The goal was to identify operational inefficiencies, such as delays and high-return areas, and understand their root causes. Key insights included region-based delivery bottlenecks and product-level return patterns. An interactive dashboard was developed to support real-time monitoring. Strategic recommendations were proposed to optimize delivery processes and enhance overall supply chain efficiency.
Skills Applied:
-
Define operational metrics such as delivery time, return rate, and shipping mode efficiency.
-
Connect & prepare logistics datasets for regional and product-level analysis.
-
Analyze & visualize supply chain performance in Power BI with geographic and category segmentation.
-
Publish dashboards for monitoring and decision-making to optimize logistics.
Project 2: App Optimization Analysis
The project analyzes the decline in bill payment success rate on an e-wallet app since August 2025 using transactional, session, event log, and error data. Power BI and the MECE framework were applied to identify failure points across the payment journey, including authentication, gateway redirects, and app version issues. Key insights highlighted correlations between failure rates and user segments, device types, and network quality. The analysis led to actionable recommendations to optimize payment flows and reduce error impact.
Skills Applied:
-
Define optimization objectives & KPIs for payment success rate, error frequency, and user flow completion.
-
Connect, clean & integrate multi-source datasets (transactions, sessions, logs, error categories).
-
Analyze & visualize payment journey bottlenecks in Power BI using MECE breakdown.
-
Publish interactive dashboards to help product and engineering teams track and resolve issues.
-
Prepare slides & use storytelling techniques to present insights and solutions to stakeholders.
