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.



Profile
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.

Power 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.

  • Power Bi
  • Report

Sales Dashboard

This project analyzes January sales data to evaluate key metrics and uncover trends to improve sales efficiency.

  • Power Bi
  • Dashboard

Financial Dashboard

This project analyzes out-of-pocket revenue using Google Colab and Power BI to optimize patient retention and financial strategies.

  • Python
  • Optimizationn

Lead Generation Optimization

This project analyzes patient responsibility trends and optimizes lead generation through data cleaning, EDA, and visualizations to improve revenue and lead conversion.

I don’t just work with companies— I build with visionaries.

Python
SQL
Power BI
Data Visualization
JavaScript
Frontend Development

Get In Touch

Get In Touch

Get In Touch

Get In Touch

Get In Touch

Get In Touch

Get In Touch

Get In Touch

Contact Me

Contact Me

Contact Me

Contact Me

Contact Me

Contact Me

Contact Me

Contact Me