Report definitions
10
6 dashboards
Operations
Phase 11 Reporting Foundation. Mock dashboards only — no live exports, scheduled email, or live AI insights.
Phase 11 — Reporting, Dashboards, Analytics & Executive Intelligence Foundation. Phase 11 builds reporting foundations and mock dashboards only. Eleven new tables: report definitions, dashboards, widgets, saved reports, snapshots, paused schedules, preview-only export jobs, a metric registry with snapshots, mock AI insights, and access logs. Scheduled delivery, production exports, external BI, and live AI insights will be activated in later sub-phases.
Report definitions
10
6 dashboards
Metrics registered
8
8 snapshots
Paused schedules
2
No live delivery in Phase 11
Mock AI insights
4
2 preview exports
Six role-aware dashboards. All preview content is mock.
executive
Mr. Pinder's top-level view across the entire firm.
8 widgets registered
operational
Daily operations: follow-ups, event reports due, document reviews, scheduling backlog.
8 widgets registered
personal
Per-agent pipeline, appointments, tasks, personal commission preview.
8 widgets registered
compliance
Document reviews, missing artifacts, restricted documents, compliance bundle readiness.
8 widgets registered
commission
Statement intake, calculation runs, discrepancies, payout previews, override audit.
8 widgets registered
ai
AI agent health, conversations, approvals, guardrails, evals.
8 widgets registered
Phase 11 is preview-only across exports, scheduling, AI insights, and external BI.
Live exports (PDF / Excel / CSV)
All export jobs are recorded as preview-only. The export engine is wired in Phase 11b.
Scheduled delivery (email)
All schedules default to paused. Email delivery is wired in Phase 11c.
Live AI insights
Every insight row is mock-only (insight_type=mock). Live AI is wired in Phase 11d.
External BI integration
Snowflake / Looker / Power BI connectors land in Phase 11e.
RLS enforced
All Phase 11 tables have row-level security forced on. Tenant scope is enforced server-side.
Executive Dashboard
Mr. Pinder's top-level view across the firm.
Operations Dashboard
Donna — follow-ups, document reviews, scheduling backlog.
CRM Analytics
Lifecycle conversion funnel and product-line interest.
Event Analytics
Florida Blue & EA Pinder event performance.
Calendar Analytics
Appointment volume, types, no-shows.
Documents & Compliance
Document volumes, review backlog, bundle readiness.
Sales Process
Four-pillar progress and application readiness.
Policy & Application
Application stages, underwriting, active book.
Communications
Email, SMS, voice — drafts, queued, sent.
Commissions
Statement intake, payout preview, discrepancies.
AI Operations
Agent health, approvals, guardrails, evals.
Report Catalog
Every report definition.