About Camilo Sierra — Business Analytics Portfolio, Data Analyst & Business Analyst
Hello,
I'm Camilo!
I am an Economist and Business Analytics professional with a strong foundation in data analysis, business intelligence, and decision-making. I use SQL, Python, R, Tableau, Power BI, and Looker Studio to turn raw data into dashboards, insights, and recommendations that support business, financial, and operational decisions.
My work focuses on identifying trends, understanding performance drivers, detecting process bottlenecks, and communicating insights clearly to both technical and non-technical audiences. My current focus is Business Analytics, BI, Operations Analytics, and Data-Driven Strategy.
Core Skills
How I Work
A pragmatic, iterative process that turns raw data into decisions.
Frame the problem
Translate a business question into a clear analytical objective, defining metrics, scope, and the stakeholders' expectations up front.
Prepare the data
Ingest, validate, and profile the data. Resolve missing values, outliers, and inconsistencies before analysis.
Model & explore
Apply statistics, SQL queries, and machine learning to detect patterns, test hypotheses, and isolate performance drivers.
Build the story
Design dashboards and visualizations that highlight the key findings and make complex data intuitive.
Drive the action
Deliver clear recommendations with trade-offs, so non-technical stakeholders can act with confidence.
Projects
Turning complex datasets into clear stories.
Airline Flight Performance Analysis
Interactive Tableau dashboard analyzing 98K+ synthetic airline records to uncover patterns in flight delays, cancellations, and on-time performance by continent, demographics, and airport.
Consumer Complaints EDA (2011–2024)
Exploratory analysis of 6.9M CFPB cases spanning 13 years. Uncovers credit-report errors as the top complaint driver, a post-2020 volume spike, and geographic hotspots using SQL, GCP, and Looker Studio.
US Stocks Indicators
ML pipeline to classify US stocks by price variation using 173 financial indicators (2014–2018). Compares Logistic Regression, Random Forest, SVM RBF, and XGBoost, complemented by unsupervised segmentation with PCA, t-SNE, UMAP, and K-Means.
Online Retail Sales
Interactive dashboard analyzing online retail sales performance, customer segments, and product categories using Tableau Public.
Oil Iran Shock: Crude Inventories vs. Pump Prices
Short data analytics case study using the U.S. Energy Information Administration (EIA) API. Explores how quickly crude oil inventory changes passed on to retail gasoline prices after the Iran conflict began on February 28, 2026 — a classic case of confounding driven by geopolitical risk.
Web Scraping MLS 2024
Scraped and analyzed soccer league data to extract insights on player stats and team performance using Python and BeautifulSoup.
Power BI Sales Dashboard
Interactive business intelligence dashboard built in Power BI, analyzing sales performance, profitability trends, and regional KPIs with dynamic filtering.
PDF Presentation Viewer
Interactive slide viewer with paginated navigation, fullscreen mode, keyboard shortcuts, and a mobile‑responsive fallback.
Get in Touch
Open to opportunities, collaborations, and interesting data conversations.