top of page

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.

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
bottom of page