Joon Han | Digital Diagnostics

ChatGPT Image Apr 30, 2026, 01_50_31 PM.png

Power BI & Dashboarding

A collection of case studies using Power BI to model data, design dashboards, and translate business patterns into decision-ready views.

These projects show how interactive reporting, KPI design, and DAX-based analysis can reveal concentration, performance drivers, and business structure.

DAX · Data Modeling · KPI Design · Interactive Reporting · Business Intelligence

ChatGPT Image Apr 30, 2026, 01_59_58 PM.png

Olist Marketplace Dependence Analysis

Focus:
Power BI · DAX · Data Modeling · Marketplace Business Intelligence

A Power BI case study examining whether Olist’s marketplace growth was broadly distributed or shaped by visible seller and category concentration.

Key insight:
Seller concentration was meaningful, but not extreme. The top 10 sellers contributed 13.15% of total revenue, while the top category contributed 9.26%, suggesting growth was broad enough to show participation but still shaped by leading sellers and categories.

View case study