Project 1: HR Performance Monitoring Dashboard
The project analyzes workforce performance and turnover trends using a Power BI dashboard built from HR records. The dataset includes detailed employee information such as employment history, department, position, performance scores, and total compensation. The dashboard provides an interactive and structured view of key HR metrics, enabling insights into staff efficiency, turnover patterns, and compensation distribution. Analysis results support data-driven decisions to improve employee retention, optimize HR costs, and enhance workforce management strategies.
Skills Applied:
-
Define HR KPIs such as turnover rate, performance score, and compensation analysis.
-
Connect, clean & prepare HR records for department- and position-level analysis.
-
Analyze & visualize workforce trends in Power BI across departments and positions.
-
Publish interactive dashboards to support retention strategies and cost management.
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.
