CASE STUDY | PERSONAL PROJECT
2024 Health Data
Turning one year of iPhone Health data into an Apple inspired interactive Tableau dashboard built from raw XML export, CSV files and personal data.â
CLIENT
Personal project
SCOPE
Data, Design, Dev
YEAR
2025
TOOLS
Python, SQL, Tableau
01
THE PROJECT
Every day our phones, watches, and smart devices collect data about us, whether we're paying attention or not. This project set out to find what an iPhone actually knows — what Apple Health measures, what it ignores, and what a full year of that data reveals once there's an interface built to explore it. The Apple Health export itself is a single, enormous XML file: messy, inconsistently structured, and impossible to make sense of without the right tools.
02
DATA AND ANALYSIS
The project started with a raw XML export from Apple Health. Python was used to parse and clean the file, restructuring it into a clean SQL database. Additional sources — smart scale measurements, gym reservations, and activity logs — were downloaded as CSV files and joined in Tableau, merging five data sources into a single connected view.
Data analysis and first visual discovery in Tableau
03
DESIGN SYSTEM
With clean data in place, the challenge was surfacing meaningful relationships across five data layers at once. The solution: a multi-layered circular diagram, inspired by Ludovic Tavernier's Weather Memories, paired with five connected charts (bars, lines, bubbles) driven by a single month-selector dropdown. The visual language leans on Apple's own Health app aesthetic — using Apple's styleguide, fonts, and icon set as a starting point — refined into a cleaner, original version.
Recreation of the iPhone health app aesthetic using Apple's styleguide, fonts and icon package. I ended up choosing my own cleaner version.
04
RESULTS
The finished dashboard merged 5+ data sources into one interactive view covering 365 days of health data, surfacing patterns invisible in the default Health app — the link between sleep quality and next-day activity, seasonal shifts, and dips in training consistency. It was awarded Tableau "Viz of the Day" in March 2025, was featured in a podcast, and has drawn over 20,000 views on Tableau Public.
>20kâ
Views on Tableau public
