JUAN JOSÉ VALENCIA

JUAN JOSÉVALENCIA

DATA ANALYST · BUSINESS ADMINISTRATION
TULUÁ, COLOMBIA

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.

Behind the desk

With a background in Business Administration (9th 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 built Autaller, a SaaS platform for automotive workshops covering clients, inventory, employees, billing, and operational dashboards.

TECHNICAL CAPABILITIES

  • Excel 95%
  • Power BI 60%
  • SQL 50%
  • Python 50%

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.

U.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
GLOBAL WEATHER INSIGHTS POWER BI
03

Diabetes Risk Econometric Analysis

Pythonstatsmodels OLSEconometrics

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
04

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
05

Autaller, Automotive Workshop SaaS

SaaSFull-stackCRM

Built 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
VISIT AUTALLER ↗
06

Univalle Vocational Test

Full-stackSupabaseAPIPower BI

An assessment tool with 18 questions designed to recommend university careers based on student interests and skills. Leads are captured in a Supabase database and consumed via API to power an interactive Power BI dashboard. Currently deployed in production for Universidad del Valle (Tuluá).

  • Career matching
  • Supabase DB
  • API Integration
  • Power BI Dashboard

Certifications

HELLO.

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