Visible analytics deliverables across forecasting, BI, visualization, graph analysis, databases, and optimization.
Applied Analytics
Forecasting, business intelligence, graph analysis, visualization, and academic case work curated into one clean archive.
This page adds an analytics layer to the main portfolio without replacing the site's core identity as a systems, automation, and data-engineering portfolio. The strongest case studies stay visible first, while the broader archive keeps the range of work accessible and organized.
The strongest pieces are separated from the broader archive so the main narrative stays sharp.
The page includes source files and supporting reports without disrupting the current premium portfolio style.
Predictive Model for Residential Construction Activity in Texas
A forecasting-focused thesis project designed around construction permits, planning uncertainty, inventory timing, workforce decisions, and commercial readiness.
Frames Esteban as someone who can connect time-series analysis with operational planning and business value.
Forecasting
Time Series
Planning
Business Context
Cycle-Time and Rework Optimization for a Custom Manufacturing Operation
An applied analytics case centered on cycle-time prediction, rework risk, process mining, and KPI-driven operations improvement for a custom manufacturing business.
Adds predictive and operations-oriented depth without overlapping the current ETL and automation portfolio.
Operations Analytics
ML Strategy
KPI Design
Process Improvement
Executive BI Dashboard for Commissions, Market, Pareto, and Traders
A multi-page Power BI project covering commissions, market participation, Pareto logic, decomposition views, and trader-level reporting.
Shows that Esteban can translate data into managerial dashboards, not only backend systems.
Power BI
Executive Reporting
Market Analysis
Dashboards
Property and Price Exploration in Tableau
A Tableau workbook focused on property-level analysis, pricing patterns, housing attributes, and real-estate-oriented visual storytelling.
Expands the public portfolio into analytics communication and exploratory visualization.
Tableau
Real Estate
Visual Analysis
Storytelling
Fraud Detection Through Graph Analytics
A Cypher-based report exploring duplicated cards, shared identity data, overlapping products, and risky loan balances in a fraud scenario.
Introduces graph thinking and pattern analysis without repeating the existing code-lab samples.
Neo4j
Cypher
Fraud Analysis
Graph Modeling
Healthcare Relationships and Conflict-of-Interest Analysis
A graph-based healthcare case focused on pharmaceutical influence, overloaded doctors, incompatible treatments, and relational risks.
Broadens the analytical range of the site while staying aligned with structured problem solving.
Neo4j
Healthcare
Risk Analysis
Relational Data
Why this page exists
The home page stays selective, while this page carries the wider analytics footprint.
No duplication of the main story
The core homepage remains centered on CTO-level systems, ETL, automation, and operational software rather than becoming a crowded coursework catalog.
Everything stays in English
All analytics content is presented in English so it fits the public-facing portfolio and domain already deployed on Vercel.
What it adds
Forecasting, BI, graph analytics, visualization, databases, and optimization proof.
01
Forecasting and planning
Thesis and strategy material show Esteban thinking beyond dashboards into planning logic.
02
Business-facing BI
Power BI, Tableau, and reporting-oriented projects expand the visual communication layer of the portfolio.
03
Analytical range
Neo4j, MongoDB, and optimization tasks widen the signal without diluting the premium feel of the site.
Full archive
Additional analytics projects and downloads.
The archive below keeps the project set broad while the main page remains curated. Each item points to a downloadable or viewable artifact inside this public repository.
Big Data Use in a Custom Manufacturing Operation
Applied essay on operational, customer, logistics, HR, and financial data inside a U.S. manufacturing context.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Factors Affecting Big Data Adoption in a Service Operations Company
Technology and organization analysis using TOE and UTAUT perspectives.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Comparative Review of Big Data Technologies
Comparison across storage, NoSQL, batch, real-time, ML, and visualization platforms.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Case Analysis S1
Case-based analysis of analytics applications in Ecuador with a business-value lens.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Case Analysis S2 on Public Procurement
Descriptive and associative analysis of Ecuador's public procurement market using Python.
DOCX
Public portfolio artifact
Integrated into the site without changing the main brand direction
Innovative Analytics Solution S4
Presentation on cycle prediction, rework risk, and phased implementation planning.
PPTX
Public portfolio artifact
Integrated into the site without changing the main brand direction
Business Intelligence Concept Map
Conceptual support piece that complements the applied BI work with a clear structural overview.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Power BI Integrated Project - Phase 1
Initial dashboard structure and model setup for the larger reporting workflow.
PBIX
Public portfolio artifact
Integrated into the site without changing the main brand direction
Power BI Integrated Project - Phase 2
Intermediate iteration with more developed layout and expanded analytical views.
PBIX
Public portfolio artifact
Integrated into the site without changing the main brand direction
Data Visualization Assignment 1
Additional visual work included to broaden the portfolio footprint beyond one Tableau project.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Graph Database Design and Exploration Task
Neo4j modeling work using the movies dataset, meta-model design, and Cypher exploration.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
MongoDB Exploration and Querying Task
Collection exploration, filters, counts, and query interpretation in a document database setting.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Linear Programming Task S1
Production-planning model solved with Excel Solver and AMPL.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Integer Programming Task S3
Capacity-constrained product-mix optimization with multiple what-if scenarios.
PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction