Data Visualization
En resumen
Data Visualization is the shared presentation layer over every rollup in this domain: interactive dashboards composed from query-bound tiles, a chart library covering bar, line, pie, radar, and heatmap, embeddable signed widgets for federation and club websites, unified PDF/Excel/CSV export, scheduled email delivery against closed periods, and a guided custom report builder for ad-hoc analysis.
Cómo funciona
Dashboards (F10.06.01) are composed from tiles, where each tile is bound to a rollup query (player, match, competition, federation, or global) plus a chart type from the supported set (F10.06.02): bar, line, pie, radar, and heatmap. Tile queries hit the pre-computed AnalyticsRollup layer, so render time stays under a second even on dense federation views, and the live-delta layer keeps today's bucket fresh. Embeddable widgets (F10.06.03) wrap the same tiles in an iframe-friendly bundle with a signed widget token that scopes the read to a specific OrgNode and a public dataset; federations drop a one-line snippet into their CMS site and get auto-updating tiles.
Report export (F10.06.04) sends the underlying query through a unified renderer that produces PDF (paginated, with cover and footer), Excel (one sheet per tile, with raw data), and CSV (flattened tabular). Scheduled report delivery (F10.06.05) is a cron-managed job: the user picks a report, a cadence (daily, weekly, monthly), recipients, and format; the job runs against the closed rollup for that period and emails the artefact. The custom report builder (F10.06.06) is a guided UI that exposes the rollup catalogue (dimensions: player, club, region, season, format, position; measures: count, win-rate, points, revenue), validates the combination against capability scopes, and persists the saved query for re-use, scheduling, or embedding.
Sensitive measures (revenue, lapsed members, identifying user data) are capability-gated at query time, and every export records who downloaded what for the privacy-first dashboard's data-access history.
Capacidades clave
- Tile-based dashboards bound to pre-computed rollup queries
- Bar, line, pie, radar, and heatmap chart library
- Signed embeddable widgets for federation and club CMS sites
- Unified PDF, Excel, and CSV export from the same query
- Scheduled email delivery against closed rollup periods
- Guided custom report builder with dimension/measure catalogue
- Capability-gating + access-log audit on every sensitive export
En la práctica
A regional sport coordinator builds a quarterly report in the custom report builder. She picks the membership-growth measure, splits by club, filters to her region, and previews a bar chart that loads in under a second from the monthly_close rollup. She switches to the radar chart to overlay age groups, saves the report as Quarterly Region Health, schedules a PDF delivery on the first of every quarter to the regional board, and copies the embed token for the public participation tile into her federation's WordPress site.
Two days later her chair downloads the same report from the email, and the access log on her privacy dashboard shows exactly who opened it.
Funcionalidades de este subsistema
6| ID | Status | Funcionalidades |
|---|---|---|
| F10.06.01 | Entregado | Interactive dashboards ✅ PL-F1006 |
| F10.06.02 | Entregado | Chart types (bar, line, pie, radar, heat map) ✅ PL-F1006 |
| F10.06.03 | Entregado | Embeddable widgets for federation websites ✅ PL-F1006 |
| F10.06.04 | Entregado | Report export (PDF, Excel, CSV) ✅ PL-F1006 |
| F10.06.05 | Entregado | Scheduled report delivery (email) ✅ PL-F1006 |
| F10.06.06 | Entregado | Custom report builder ✅ PL-F1006 |