Data Analyst focused on Data Systems, Automation & Geospatial Applications

I build data workflows and analytical tools that turn raw data into reliable, decision-ready outputs using Python, SQL, automation, and geospatial technologies.

Selected Work

Operational Analytics · In Development

Prague Public Transport Operations Intelligence System

  • SQL
  • Python
  • PostgreSQL
  • Data Quality
  • KPI Design
  • Power BI

An end-to-end analytics system that transforms public transport data into validated operational metrics, analytical models, and interactive Power BI reporting.

Geospatial Analytics · In Development

Urban Accessibility & Service Coverage Intelligence

  • Python
  • GeoPandas
  • PostGIS
  • Spatial SQL
  • QGIS
  • Network Analysis

A spatial analysis system for identifying areas with limited access to essential urban services by combining population, transport, and service-location data.

Workflow Automation · In Development

AI-Assisted Data & Operations Intelligence System

  • Python
  • LLM APIs
  • Structured Outputs
  • Function Calling
  • Validation Guardrails
  • Workflow Automation

An automated workflow system that integrates LLM structured outputs and database lookups with strict validation guardrails, audit logging, and human approval gates.

Capabilities

Analytics

SQLPower BIPandasExploratory AnalysisMetrics & Reporting

Data Systems

PostgreSQLData ModellingData PipelinesData ValidationData Quality

Geospatial

GeoPandasPostGISSpatial SQLGISSpatial Analysis

Automation & Engineering

PythondbtDockerTestingGit

About

My background combines software development with environmental and data-focused studies.

Over time, my work has moved from application development toward data analysis and the systems behind it: structuring data, automating repetitive workflows, validating data quality, and building analytical outputs that can support real decisions.

My current focus is on practical data analysis, data systems, automation, and geospatial applications using Python, SQL, and modern analytical tools.

Notes

Technical notes and project write-ups covering data modelling, analytics, data quality, automation, and geospatial analysis.

Data Cleaning Basics: What to Do Before You Analyse
/ Data Quality, Data Systems

Data Cleaning Basics: What to Do Before You Analyse

Analysis is only as good as the data you put in. Here are the essential cleaning steps before you run any numbers.
Read more
When to serve a model with an API vs a batch job
/ Data Systems, Automation

When to serve a model with an API vs a batch job

Not every model needs a real-time endpoint. Here is how to choose between online inference and scheduled batch scoring without overbuilding.
Read more
One feature table for training and scoring
/ Data Systems, Data Integration

One feature table for training and scoring

If training and production scoring use different column logic, the model’s inputs quietly drift. Here is why one shared feature build beats ad-hoc spreadsheets for serious ML.
Read more

Interested in working together?

I'm open to data analysis, operational analytics, data systems, and geospatial data opportunities.

© 2026 Vahdet Karataş. All rights reserved.
Data analysis, data systems, automation, and geospatial applications.