OBJECTIVE
A new team with a high volume and rapid turnover of work, needed a system to track and allocate, display historical data, and measure performance against SLAs and other metrics.
​
I designed and built a system, that captured data and displayed it back with context and in aggregate format, within the closed HMRC software environment; with minimal friction on the team’s ways of working.
OUTCOME
The system is running successfully for over 2 years. It was central to the business case of new Data Analysis headcount within the team, and providing additional data products to the department leadership group.
METHOD
I designed the system as the team were working out how to fulfil their remit. It became clear that we would be accumulating data rapidly, and the system could not only allocate new work & track where expertise was being built, but could also display back consolidated views of previous work.
I taught myself PowerBI to display data, to Microsoft Associate standard, including learning to code in M language and DAX for data manipulation. I modelled the data, designed the workflow and product interface including the UI, & built the schema.
​
I included security and access protection, and connected data to the system, using PowerAutomate to automate updates and frictionless data transfer (such as from a single email mailbox), using SharePoint as the central respository. The result was a single application embedded into MS Teams as a seamless part of day to day work.
The uses of the sytem were socialised through a video I generated using Premier Pro.