My Scuba Diving Data Extraction and Analysis
This personal project mirrors real-world data challenges — taking raw, unstructured logs and turning them into something meaningful for decision-making.
Raw Data Challenge (analytical thinking and problem-solving)
- Connect the watch through serial port
The watch only exported “raw numbers” with no context.
I had to reverse-engineer what those numbers meant (depth, time intervals, duration, temperature, etc.).
Data Transformation (PowerShell Script / Automation)
I wrote a PowerShell script to parse the raw text and convert it into a structured CSV table.
Data Modeling & Enrichment
After conversion, I loaded the CSV into Power BI.
Added calculated fields (e.g., fast ascend warning).
Visualization & Insights
KPIs (total dives, max depth, average duration).
Trends (depth changes over time).
Safety/interesting insights (Number of warnings per dive).
