Portfolio

CASE STUDY

Customer Status & Revenue Dashboard

Category

Professional

Year

2026

Role

Data Analyst

Client

PT Andromega Data Nusantara

Tentang Project

Problem: Customer, package, and billing data was spread across several sources, making it hard to see customer status and revenue at a glance. Approach: I cleaned and transformed the data with Power Query and SQL, then built a three-page interactive Power BI dashboard: a customer status and revenue overview, a breakdown by package and speed, and a registration trend and area analysis. Each page has slicers for status, region, package, and registration year. Outcome: Stakeholders can track active, suspended, and terminated customers in one place and compare performance by region, package, and area. Customer names, billing numbers, and revenue figures have been masked for confidentiality.

Tools

Power BIPower QuerryExcel

Galeri

Customer Status & Revenue Dashboard - 1
Customer Status & Revenue Dashboard - 2
Customer Status & Revenue Dashboard - 3
1 / 3

Click an image to enlarge