Your team has the data. The problem is they cannot use it without calling someone.
Government and recreation teams collect enormous amounts of operational data across revenue, registrations, facility usage, and program hours. Most of it ends up in spreadsheet exports that take hours to analyze and are outdated before anyone acts on them. The City of Frisco Parks and Recreation Department changed that in four days.
Does this describe your team?
- Program and revenue data lives across multiple exports with no unified view
- Staff spend hours assembling reports that are stale before leadership reads them
- Facility and service performance is compared manually with no consistent framework
- Any change to a report means calling IT or an outside consultant
- Power BI training uses generic examples that have nothing to do with your actual data
- Leadership cannot answer basic questions about peak demand or top-performing programs without a manual pull
What Armely delivered for Frisco Parks & Rec
The City of Frisco Parks and Recreation Department needed a way to understand revenue, registrations, facility performance, and service demand from one trusted view. They also needed their own staff to maintain it.
Armely delivered a 4-day, 24-hour hands-on Power BI workshop built around real Frisco Athletic Centre data. Staff learned the full reporting lifecycle across eight modules and finished with a working three-view dashboard covering Activity, Facility, and Services.
At a glance
| Before | After |
|---|---|
| Revenue, registrations, and hours split across CSVs and manual spreadsheets | Structured Power BI model connecting all data sources in one reporting environment |
| No single view of resident vs. nonresident revenue or registration trends | Activity View shows revenue, registrations, hours, withdrawals, and utilization by month and channel |
| Facility performance compared manually with no consistent framework | Facility View compares revenue and KPIs across Frisco Athletic Centre and FAC Indoor Aquatic |
| Service rankings required custom reports each time | Services View ranks services by revenue with drill-down across date, status, and type |
| Staff depended on outside support for reporting changes | Internal team trained across eight modules to maintain and extend reports independently |
| Training used generic data unrelated to the department's actual work | Workshop built on real Frisco Athletic Centre activity, facility, and services data |