Problem
An Atlanta based non-profit organization had been running a free fitness program for years, using an archaic backend system that did not allow for any data tracking or analysis which resulted in the organization not being able to assess the performance of the program they offered for free to the Atlanta community.
Update: Since the initial project, the client requested me to create dashboards for their non-Fitness programs as well. These were done in Tableau to give them real-time information and updates to dashboards.
Action
I designed a system that allowed them to more effectively capture / track attendee data, as a module of the Smart Studio platform (which I co-founded and own), and then developed a visualization dashboard in Excel that provided them and their partner/sponsor, a large US fitness apparel manufacturer, key insights into the performance of the program, allowing them to slice and dice the data by multiple KPIs.
As mentioned above, I have now also created Tableau versions of the same.
The below screenshots show some of the interactive dashboards and charts that allow the organization to slice and dice the attendee data to provide actionable insights for marketing, soliciting support for the organization or encouraging engagement. All green cells (besides the tiles in the first image) are drop downs that allow filtering (or not) by a particular metric. Some are Excel and some Tableau
Result
The organization is now able to better understand the key demographics of all their Free Programs offered to the community, as well as provide their board as well as their partner / sponsor accurate facts and figures that convey the impact of their programs to the Atlanta community.
Comments