UK / Public Services
Analytics Solution to Help More People Get Active and Participate in Sports
"This solution provided the client with an easy means of interrogating the data and generating insight, thereby driving maximum value from this rich resource."
Business issue
Our client commissioned Ipsos to set up a new nationally representative survey, collecting national statistics on activity levels of adults in England. The sample design allowed our client to interrogate data down to local authority level. The survey replaced an existing survey, using an innovative push-to-web design. Over the course of their previous solution, our client had developed dashboards in Excel which helped them interrogate tabulated data. The quantity of data involved meant that the solution was starting to creak, and was also liable to user-error. Our goal was to help support our client in better using their data to drive insight and ultimately shape their strategy.
Our solution
Adopting Microsoft Power BI, Ipsos created a series of interactive dashboards on each of their KPIs. Our approach was developed iteratively. We first designed the dashboards themselves, developing them over time. We then moved the underlying data onto the cloud, such that the dashboards could be hosted on the client's servers, pulling data from the database which is refreshed each year.
For more information on this case study, get in touch here.
Impact
This solution provided the client with an easy means of interrogating the data and generating insight, thereby driving maximum value from this rich resource. The improved visuals also allowed the client to create better reports, more quickly.
