Esteban Garzon
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.

Portfolio Layer20

Visible analytics deliverables across BI, visualization, graph analysis, applied reporting, databases, optimization, and strategy briefs.

Featured Cases6

The strongest pieces are separated from the broader archive so the narrative stays sharp and every link stays live.

Download TypesPDF / PBIX / TWB / PPTX / DOCX / Briefs

The page combines direct downloads with internal case briefs so every analytics item remains accessible without broken links.

Analytics Report

Applied Analytics Final Report

A polished long-form analytics report included as a public artifact to show structured analysis, report composition, and executive-facing presentation.

Adds a substantial document to the portfolio that shows Esteban can package analysis into a complete deliverable, not only dashboards and code.
Applied Analytics
Reporting
Business Framing
Documentation
Power BI

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
Data Visualization

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
Neo4j

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
Graph Analysis

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
Conceptual Design

Business Intelligence Concept Map

A visual support piece that complements the applied BI work with a structured overview of business intelligence concepts and relationships.

Shows that Esteban can communicate analytical structure clearly, not only deliver implementation files.
BI
Concept Mapping
Analytical Communication
Structure
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 artifact or an internal case brief so the full analytics footprint stays visible without broken links.

Big Data

Big Data Use in a Custom Manufacturing Operation

Applied essay on operational, customer, logistics, HR, and financial data inside a U.S. manufacturing context.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Big Data

Factors Affecting Big Data Adoption in a Service Operations Company

Technology and organization analysis using TOE and UTAUT perspectives.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Big Data

Comparative Review of Big Data Technologies

Comparison across storage, NoSQL, batch, real-time, ML, and visualization platforms.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Analytics

Case Analysis S1

Case-based analysis of analytics applications in Ecuador with a business-value lens.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Analytics

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
Analytics

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
BI

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
BI

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
Visualization

Data Visualization Assignment 1

Additional visual work included to broaden the portfolio footprint beyond one Tableau project.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Graph Databases

Graph Database Design and Exploration Task

A Neo4j-oriented task artifact that broadens the graph-analysis footprint of the portfolio.

PDF
Public portfolio artifact
Integrated into the site without changing the main brand direction
Databases

MongoDB Exploration and Querying Task

Collection exploration, filters, counts, and query interpretation in a document database setting.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Optimization

Linear Programming Task S1

Production-planning model solved with Excel Solver and AMPL.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction
Optimization

Integer Programming Task S3

Capacity-constrained product-mix optimization with multiple what-if scenarios.

Case Brief
Public portfolio artifact
Integrated into the site without changing the main brand direction