This repository contains a collection of Excel-based analytics projects demonstrating data modeling, KPI development, dashboard design, and business insight generation.
Each project showcases different aspects of Excel analytics including pivot tables, slicers, advanced formulas, lookup tables, conditional formatting, and executive-style dashboards.
Interactive dashboard analyzing a simulated multi-site program portfolio with risk stratification, timeline trends, KPI cards, and composite health scoring.
Key features:
- Dynamic KPI cards (Total Programs, % On Track, Avg Delay, Avg Readiness, Health Score)
- Risk distribution by phase
- Programs completed over time
- Slicer-driven interactivity (Phase, Area, Site, Risk)
- Composite Health Score using weighted lookups
- Conditional formatting for executive visibility
Additional Excel projects will be added to this repository.
Created by Tenekua Dugan