We were brought in on the basis of our strong work on search and web for the client. We began by demonstrating the art of the possible, giving inspiration as to what we could do for the business. This built confidence and allowed us to propose the best way to take the work forwards.
We took an iterative approach in delivery, allowing key stakeholders to constantly feed back on solution delivery. Due to data issues we needed to overcome multiple blockers. As we improved the data and overcame obstacles, we produced increasingly optimal versions of the solution.
Next we defined KPIs. We looked at which of the KPIs we defined already had data available to report upon, and in so doing we established where there were gaps that needed to be overcome. We resolved those KPIs we could and then worked on bringing others online in automated fashion as we were able.
Next, we built a data model and considered what an ideal dashboard would look like for the business. We fed reports back to our client for validation, allowing client colleagues to truly own the solution and shape it to exact stakeholder needs.
We built the dashboards desired by our client, as well as creating the ability to filter the data in our new data model, allowing the users to independently drill down into the data as required. We also connected Power BI to Sharepoint – joining up the data and giving greater linkage and visibility.
Our approach updated the look and feel of BI for the brand – moving them from basic reports and spreadsheets, to being able to graphically see what the insights were, making it instantly engaging and inspiring to interact with.
Lastly, we coached the client to understand how best to work with their data for reporting purposes in the future. We were able to demonstrate the impact of consistency and clarity in data being fed into the system, so the client could go on to follow best practice with the Power BI tool. This training was essential to secure the buy-in of wider non-data-specialist stakeholders to the importance of accuracy etc. in working with Power BI.