Turning messy Excel data into an interactive dashboard π In...
Portfolio project
Turning messy Excel data into an interactive dashboard π
In my latest Excel case study, I worked with a raw, unstructured dataset (8,700+ rows) and focused on doing the fundamentals right:
β’ Cleaned inconsistent time, date, and text values
β’ Structured the data for accurate analysis
β’ Built pivot tables with day, month, and time logic
β’ Added slicers and conditional formatting for interactivity
No fancy tools β just solid Excel workflows that make data reliable and easy to explore.
This is exactly how I approach real client data:
clean first β structure next β visualize last.
π Full case study is live on my profile.

0 likes Β· 7 views Β· Jan 16, 2026
Turning messy Excel data into an interactive dashboard π In my latest Excel case study, I worked with a raw, unstructured dataset (8,700+ rows) and focused ...