Training Performance Dashboard
A live dashboard of my own training data. A nightly Google Cloud pipeline turns Strava activities into training load, fitness and VDOT in BigQuery.
- Python
- BigQuery
- Google Cloud
- Next.js
Senior Data Analyst
Ahmet Can Özdemir
Turning data into decisions — 4 years in data analysis, dashboard design, and KPI frameworks.
Beyond the resume
4
Years in Data & Analytics
75+
Dashboards & Reports Shipped
About
I'm an Industrial Engineering graduate (Hacettepe University) who found his footing in data. Before graduating, I did a Work & Travel program in the US, followed by an Erasmus exchange in Logistics & Supply Chain Management at the University of Duisburg-Essen. I then joined Turkish Aerospace as a Data Analyst on the Digital Transformation team, building real-time data infrastructure — and in the 4 years since, I've stayed on that Data Analyst track, now as a Senior Data Analyst, designing dashboards, KPI frameworks, and automated reporting systems used across teams and leadership levels.
Outside of work, I lead from the front — three years on my university's diving club board (the last as chairman, now a certified SSI Divemaster), and more recently on the road, finishing my first marathon at 26. More on both further down.
Turning messy data into a dashboard someone actually trusts enough to act on — that's the part of the job I enjoy most, and what I'm always looking for next.
Experience
Jul 2024 — Present
Senior Data Analyst, Turkish Aerospace
I work with stakeholders across the business to turn their needs into data models and KPIs they can act on. One performance-tracking dashboard I built in Power BI was independently recognized as a “world-class” best-practice example. I've also automated resource-planning pipelines, run root-cause analysis on rising cost trends, and built inventory reports that help teams catch fulfillment delays early.
Nov 2022 — Jul 2024
Data Analyst, Digital Transformation, Turkish Aerospace
I led the design of a real-time data architecture connecting our operational touchpoints, then built the monitoring dashboards (Grafana, SQL, ETL) on top of it. I also designed an RFID-based asset-tracking system to cut down on lost material.
Education
B.Sc. Industrial Engineering, Hacettepe University
GPA 3.54/4.0 (High Honour)
Erasmus+ exchange in Logistics & Supply Chain Management, University of Duisburg-Essen (Germany)
Skills
Analysis & BI
- SQL
- Python
- DAX
- Power BI
- Power Query
- Report Builder
- Grafana
- Tableau
Data & ETL
- MS SQL Server
- PostgreSQL
- BigQuery
- Stored Procedures
- Scheduled Jobs
Analytics Methods
- KPI Design
- Data Modeling
- Root-Cause Analysis
- A/B Testing
- Statistical Analysis
- Trend & Variance Analysis
Other
- Docker
- Node-RED
- Claude Code
- AI-Assisted Analytics Workflows
- Jira
Projects
AI Agents & Workflows
Two personal AI systems I designed and use daily on Claude: a coach for my running and CrossFit training, and an assistant that runs my task management. Each has its own skill, connected tools and rules.
- Claude
- Skills
- Connectors
- Workflow design
Real-Time Operational Performance Dashboard
Consolidated real-time data from 130+ machines into a single Power BI dashboard, improving stakeholder visibility by 25% — independently recognized as a company-wide best-practice example.
- Power BI
- SQL
- ETL
RFID-Based Shelf-Life Material Tracking
Built a preventive asset-tracking system with RFID and Node-RED, cutting material loss incidents by 20% by moving tracking from reactive to proactive.
- Node-RED
- MQTT
- SQL
Root-Cause Analysis on a Rising Cost Metric
Used SQL-driven analysis to isolate the drivers behind a rising cost trend, enabling targeted process changes that delivered a 10% reduction.
- SQL
- Root-Cause Analysis
This Portfolio
Designed and built this site end-to-end with Next.js, deployed on Vercel.
- Next.js
- TypeScript
SSI Divemaster
Leading underwater, and in the room
As an SSI Divemaster with 100+ logged dives, I lead certified divers on guided dives — reading conditions, keeping the group calm, and making the call when it matters. Three years on the board of Hacettepe University's Underwater Sports Club, the last as chairman. I organized dive trips and club events, assisted instructors in training new divers, and mentored the next generation of board members.
- SSI Divemaster
- 100+ dives logged
- 3 years on the board
- Chairman, final year
Running
My first marathon, at 26
For now, running is about discipline as much as distance — I set specific goals for myself and train with real intent to hit them. Going into my first marathon, I set a target of 3:30 and hit it exactly. It's also turned into something close to a therapy session — the one part of my day where everything else goes quiet.
- 2025 Istanbul Marathon, Sub 3:30
- 2026 Antalya Half Marathon, Sub 1:30
Contact
I'd love to hear from you — reach out anytime.