Andres Gonzalez Ortega | Actuarial Science, UNAM (Mexico)
A collection of end-to-end data analysis projects demonstrating business storytelling, dashboard design, SQL fluency, and statistical thinking across insurance, e-commerce, finance, and operations domains.
| # | Project | Domain | Tools | Output | Status |
|---|---|---|---|---|---|
| 00 | Airbnb CDMX: Market Analysis | Real Estate | Next.js, Recharts, Static JSON | Next.js dashboard (zero-backend) | Complete |
| 01 | Insurance Claims Dashboard | Insurance | Next.js, SQL, Python, FastAPI | Next.js dashboard + executive summary | Complete |
| 02 | E-Commerce Cohort Analysis | E-Commerce | SQL, Python, Streamlit | Jupyter notebook + Streamlit app | Complete |
| 03 | A/B Test Analysis | Product | Python, Next.js, FastAPI | Next.js dashboard + statistical analysis | Complete |
| 04 | Executive KPI Report | Operations | Python, Next.js, FastAPI | Next.js dashboard + automated PDF reports | Complete |
| 05 | Financial Portfolio Tracker | Finance | Python, Next.js, FastAPI | Next.js dashboard + notebooks | Complete |
| 06 | Operational Efficiency | Operations | Next.js, D3.js, FastAPI, Python | Next.js dashboard + analytical notebooks | Complete |
Languages: SQL (PostgreSQL, BigQuery) -- Python (pandas, plotly, seaborn, scipy, streamlit) -- TypeScript/Next.js
BI Tools: Next.js + Recharts/D3.js dashboards -- Streamlit -- Jupyter Notebooks
Techniques: Cohort analysis -- A/B testing -- KPI design -- RFM segmentation -- Time series analysis -- Process mining -- Financial risk metrics
Domains: Insurance/Actuarial -- E-Commerce -- Finance -- Operations
The docs/ folder contains an Obsidian-compatible knowledge base covering the full analyst workflow:
- Analyst Workflow Overview
- SQL Analytics Patterns
- Dashboard Design Principles
- Templates for project READMEs and executive summaries
git clone <repo-url>
cd data-analyst
python -m venv .venv && source .venv/bin/activate
pip install -r requirements.txt- Portfolio Website -- Astro-based professional portfolio
- Data Science -- ML and predictive modeling projects
- Data Engineering -- Pipeline and infrastructure projects