Executive KPI Dashboard Template

📌 The Problem

Most BI dashboards are built by analysts for analysts. They're dense, unlabeled, and assume the viewer knows what "YoY delta" means at a glance. Then they get shared with an executive team who has 90 seconds and needs a single answer: "Are we on track or not?"

I built a dashboard template designed backwards from that question.

🏗️ What I Built

• A parameterized Power BI template with live SQL connectors — plug in any database and the dashboard auto-populates with relevant KPIs for that business context
• Each visualization paired with a plain-English narrative: not "revenue is $2.4M" but "Revenue is 8% above target, driven primarily by the Enterprise segment"
• One-click drill-down panels for viewers who want more detail, without cluttering the executive summary view
• Automated weekly PDF digest generated via Python and distributed by email — no manual work required after initial setup
• Designed with WCAG accessibility standards and mobile-friendly layouts so it works on any device in any meeting room

📊 Outcomes

🛠️ Technologies Used

💡 Key Learnings

• The narrative layer is not optional — a chart without context is a Rorschach test, not a business tool
• Parameterization is the difference between a dashboard and a product — one serves one client, the other scales
• Designing for non-technical audiences requires ruthless simplicity: every element that requires explanation is a failure of design