# Esther Bahati - Operations Data & AI Specialist Portfolio

Public portfolio for operations, analytics, AI, automation, reporting systems, GA4 instrumentation, Looker Studio, Google Sheets, and confidential dashboard case studies.

## Public portfolio page

- GitHub Pages landing page: [index.html](index.html)
- Asset placement instructions: [assets/README.md](assets/README.md)

## Public project links

- Looker Studio dashboard: [Open Looker Studio](https://datastudio.google.com/s/mzac46DbYlE)
- Unified Marketing Reporting Sheet: [Open Google Sheet](https://docs.google.com/spreadsheets/d/1Jb6ThjeA4Yh59ytm_vs3oh-uj4N6mCaCMycv1Am5vJk/edit?usp=sharing)
- Donor Journey & Membership Funnel Sheet: [Open Google Sheet](https://docs.google.com/spreadsheets/d/1yRjlZdXVFjySUQVqpP2nDmzuz1Gtw4lxJ_zyzdFmxhA/edit?usp=sharing)

## Project structure

### HopeTrack Demo Site - GA4 + UTM Framework
- Public page: [projects/hopetrack/index.html](projects/hopetrack/index.html)
- UTM framework: [projects/hopetrack/utm-framework.html](projects/hopetrack/utm-framework.html)

### Unified Marketing Reporting Template
- Public case study: [projects/unified-marketing-reporting-template/index.html](projects/unified-marketing-reporting-template/index.html)
- Source notes: [projects/unified-marketing-reporting-template/README.md](projects/unified-marketing-reporting-template/README.md)

### Donor Journey & Membership Funnel Analysis
- Google Sheet: [Open Google Sheet](https://docs.google.com/spreadsheets/d/1yRjlZdXVFjySUQVqpP2nDmzuz1Gtw4lxJ_zyzdFmxhA/edit?usp=sharing)
- Companion page: [projects/donor-journey-analysis/index.html](projects/donor-journey-analysis/index.html)

### Cross-Channel Campaign Insights One-Pager
- Public page: [projects/cross-channel-campaign-insights/index.html](projects/cross-channel-campaign-insights/index.html)

### Security Intelligence Dashboard - Confidential Case Study
- Public case study: [projects/security-intelligence-dashboard-drc/index.html](projects/security-intelligence-dashboard-drc/index.html)

### Virunga Performance Dashboard - Confidential Case Study
- Public case study: [projects/virunga-dashboard/index.html](projects/virunga-dashboard/index.html)

## Confidential work

Some professional projects in this repository are presented as sanitized case studies rather than public code samples. This keeps the portfolio credible while protecting sensitive data, private systems, and organizational confidentiality.