Hello! There

I'm John Zapata

Data Analyst & Developer

I'm John Zapata, a Data Analyst & Developer from Medellín. I transform data into clear insights using Python, SQL, and Power BI to help businesses grow and optimize decisions.

About Me

I'm Data Analyst & Developer based in Medellín, Colombia

I specialize in transforming raw data into powerful insights that help businesses optimize performance, increase revenue, and make better decisions. My toolbox includes Python for automation, SQL for deep data analysis, and Power BI for building interactive dashboards.

What I Do

Featured Services.

Data Analysis

Python
SQL

I analyze raw datasets, clean them, and extract insights to support strategic decision-making and optimize operations.

BI Reports

Dashboards
Metrics/KPI's

build dashboards that turn complex data into clear visuals to track performance and guide decisions.

Process Automation

Python
Scripts

I automate repetitive tasks using Python to save time, reduce errors, and streamline business operations.

Portfolio

Selected Works.

SQL
Report

Sales Dashboard

An interactive sales dashboard built with SQL, Python, and Streamlit, designed to uncover business insights from regional and customer-level sales data.

View Details

SQL
Python
Power BI

GameZone Sales Dashboard

An interactive sales dashboard built with Python and Power BI, uncovering product trends, marketing performance, and global sales insights from 21K+ e-commerce orders.

View Details

SQL
Report
Web Dashboard

Stack Overflow Developer Survey 2024 – Insights

An interactive sales dashboard built with SQL, Python, and Streamlit, designed to uncover business insights from regional and customer-level sales data.

View Details