Joon Han | Digital Diagnostics

The Pivot Protocol:
Clinical Systems Thinking Applied to Digital Growth

Flagship Case Study

A systems-driven case study applying diagnostic thinking to digital measurement and growth optimization.

Explore Flagship Case Studies

Case Study Catalog

Browse case studies by analytical capability:
SQL, Power BI, Python, and behavioral exploration.

Each category opens into a focused set of projects, organized by method, business question, and analytical approach.

ChatGPT Image Apr 29, 2026, 02_08_03 PM.png

SQL Analysis

Querying · Cleaning · Segmentation · Business Logic

Case studies using SQL to clean datasets, structure analysis, compare segments, and answer business questions with clear logic.

Browse SQL projects

ChatGPT Image Apr 29, 2026, 02_17_54 PM.png

Power BI & Dashboarding

DAX · KPI Design · Data Modeling · Interactive Reporting

Case studies using Power BI to build KPI views, interactive dashboards, and business intelligence reports for decision-making.

Browse dashboard projects

ChatGPT Image Apr 29, 2026, 02_26_39 PM.png

Python Analysis

Pandas · Segmentation · Visualization · Diagnostic Analysis

Case studies using Python to clean messy datasets, compare groups, detect patterns, and turn raw data into clearer analytical findings.

Browse Python projects

ChatGPT Image Apr 29, 2026, 02_34_17 PM.png

Behavioral & Exploratory Analysis

User Behavior · Pattern Recognition · Open-Ended Investigation

Case studies focused on observing behavior, identifying hidden signals, and exploring questions that do not start with a fixed dashboard or query path.

Browse exploratory projects