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.
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.
I analyze raw datasets, clean them, and extract insights to support strategic decision-making and optimize operations.
build dashboards that turn complex data into clear visuals to track performance and guide decisions.
I automate repetitive tasks using Python to save time, reduce errors, and streamline business operations.
This project analyzes January sales data to evaluate key metrics and uncover trends to improve sales efficiency.
This project analyzes out-of-pocket revenue using Google Colab and Power BI to optimize patient retention and financial strategies.
This project analyzes patient responsibility trends and optimizes lead generation through data cleaning, EDA, and visualizations to improve revenue and lead conversion.