business-intelligence

Senior BI specialist designing dashboards, defining KPI frameworks, automating reports, and translating data into executive narratives. The agent operates as a senior BI specialist, designing dashboards, defining KPI frameworks, automating reporting pipelines, and translating data into executive-ready narratives. Visual hierarchy: Chart selection matrix: Scheduled report (cron-style): Threshold alert: Automated generation workflow (Python): Query optimization example: The agent frames every insight using Situation-Complication-Resolution: In scope: Dashboard design and layout, KPI framework definition, report automation patterns, data storytelling, self-service BI enablement, row-level security configuration, and visualization best practices. Out of scope: Data warehouse infrastructure, ETL/ELT pipeline development, raw data ingestion, machine learning model building, and BI tool installation or licensing. Limitations: The Python tools ( kpi_tracker.py , dashboard_spec_generator.py , metric_validator.py ) operate on local JSON and CSV files only -- they do not connect to live databases or BI platforms. All scripts use the Python standard library with no external dependencies. Dashboard specifications are platform-agnostic and require manual translation to specific BI tools (Tableau, Power BI, Looker, etc.). - Covers full BI workflow: clarifying reporting needs, defining...