Christian Aguirre
Data analyst focused on operations and decision support. I build dashboards, pipelines, and models that help teams act with clarity.
Areas of Interest
Take a look at some of the things I love working on.
Data Cleaning & Preparation
Wrangled raw datasets using SQL, Excel, and Python to get them ready for analysis or dashboards.
SQL Querying
Built complex queries with joins, CTEs, and aggregations to power dashboards and reporting tools.
Python Analytics & Modeling
Used pandas, scikit-learn, and SHAP to model churn, explain predictions, and drive decisions.
Tableau Dashboards
Created visualizations that highlight trends, monitor KPIs, and support operational strategy.
Excel Automation
Developed trackers and reporting tools using formulas, VBA, and Power Query for recurring tasks.
End-to-End Projects
Led projects from data sourcing to model deployment — shared through GitHub and portfolio site.
My Latest Projects
Take a look at my recent work.
Bellabeat Smart Device Usage Analysis
Fitbit public data used to explain behavior and inform Bellabeat’s marketing & product engagement.
Cyclistic Rider Behavior
12 months of Chicago bike-share data to explain casual vs member behavior and drive membership growth.
Landscape Database Revitalization
Turn a fragmented landscaping DB into an analytics-ready system.
Operations Techniques: Optimization & Decision Models
Applied OR toolkit across six real-world scenarios: queues, payoff/regret, Monte Carlo, LP, decision trees, and BILP.
Operational Performance: Manufacturing KPI Analysis
Excel-based KPI analysis for a lawn equipment manufacturer: on-time delivery, transmission unit cost, and retention.
Telco Customer Churn Analysis
Predict churn and surface drivers to support targeted retention.
World Layoffs: SQL Data Cleaning
SQL-powered data cleaning pipeline to prepare a public layoffs dataset for analysis and business insights.