JUAN JOSÉ VALENCIA

DATA ANALYST · BUSINESS ADMINISTRATION · TULUÁ, COLOMBIA · EST. 2024

PORTFOLIO 2026

Turning raw data
into decisions.

✦ I specialize in the intersection of business logic and statistical analysis — transforming complex datasets into clear, actionable narratives that drive real decisions.

5

Data Projects

4

Certifications

1

SaaS in progress

Juan José Valencia – Data Analyst

Juan José · Data Analyst

"Data is only as good as the question behind it."

With a background in Business Administration (8th semester, Universidad del Valle), my approach to data is grounded in organizational value. I don't just find patterns — I find opportunities for optimization, risk mitigation, and strategic growth.

Based in Tuluá, Colombia, I bridge the gap between technical execution and executive decision-making. Beyond analytics, I'm currently building AutoTaller — a SaaS platform for automotive workshops covering clients, inventory, employees, billing, and operational dashboards.

TECHNICAL CAPABILITIES

Excel
95%
Power BI
60%
SQL
40%
Python
30%
SELECTED WORK

SELECTED WORK

Dashboards & Projects

01

U.S. Airline Operational Performance

Power BIStata EDADAX

Analysis of historical flight data (2003–2022) focused on delays, airport and airline performance. Tasks included duplicate removal, missing value handling, feature engineering, and DAX calculations to surface insights on 121M+ flights.

FEATURED DASHBOARDU.S. AIRLINE PERFORMANCE POWER BI
02

ETL Weather Analysis

PythonOpen-Meteo API MySQLPower BIETL

End-to-end weather data pipeline: extraction from APIs, cleaning and transformation in Python, storage in MySQL, and interactive visualization in Power BI. Enables reproducible exploration of temperature, precipitation, and climate indicators across cities and years (2023–2024).

VIEW ON GITHUB —
FEATURED DASHBOARDGLOBAL WEATHER INSIGHTS POWER BI
03
Power BIExcel ABC AnalysisKPIs

Pharmaceutical Inventory Analysis

Inventory turnover, profitability, and medication prioritization within a pharmaceutical service. ABC classification and custom KPI design to optimize the portfolio and support operational decisions.

04
Pythonstatsmodels OLSEconometrics

Diabetes Risk Econometric Analysis

Migrated from Stata to Python. OLS regression examining demographic and clinical factors, VIF multicollinearity diagnostics, and a strong focus on methodological rigor and reproducibility.

VIEW ON GITHUB —
05

Sexual Crimes Analysis – Colombia (2025)

Pythonpandas Data CleaningPower BI

End-to-end analysis of reported sexual crimes in Colombia. Workflow includes data cleaning in Python, exploratory data analysis, feature engineering (year-month aggregation), and Power BI visualization. Emphasizes data quality, temporal trends, and analytical transparency.

VIEW ON GITHUB —
IN DEVELOPMENT
06

AutoTaller — Automotive Workshop SaaS

SaaS Full-stack CRM

Building a complete business ecosystem for independent automotive workshops in Colombia. Covers the full operation: client management, vehicle history, parts inventory, employee tracking, work orders, invoicing, and operational dashboards — designed to help small shops run like enterprises.

Client & vehicle CRM
Parts inventory
Work orders
Employee management
Invoicing & billing
Operational dashboards

ACCREDITATIONS

Certifications

IBM · Coursera

Excel for Data Analysis

Google Cloud · Coursera

Looker Studio Essentials

IBM · Coursera

Databases and SQL for Data Science

Learnkarts · Coursera

Google Tag Manager: Advanced Tracking

HELLO.

Open to analyst roles, freelance data projects, and conversations about how data can solve your most complex business challenges.

LinkedIn / JUANCARDEÑO-V GitHub / JuanValencia27 Instagram / 27juan_valencia