Some examples of our work
Viewing entries tagged
ITSM
An IT Service Management (ITSM) Dashboard built for a global investment bank using Microsoft Excel and VBA to report on SLA and KPI performance.
It used a large data set of 92 data fields to calculate 4 SLAs, 14 KPIs and 46 measures, presented in a variety of graphs and blocks. There were 23 filters enabling the user to interrogate the data and isolate the cause of any issue.
A Project Portfolio Management and Workflow application built for a global pharmaceuticals company using Microsoft Excel with VBA and delivered via SharePoint.
This one is incredibly complicated and specific, and demonstrates just how much is possible with Excel and VBA.
An IT Service Management (ITSM) dashboard built for an international Commercial Insurance Company using Microsoft Excel and VBA code. The solution took data from the client’s ITSM ticket system, calculated performance against SLAs and presented the results in a dynamic dashboard.
A Service Level Agreement (SLA) reporting system built for an outsourced service provider using Microsoft Excel. The solution included extensive conditional formatting to highlight SLA breaches and VBA code to perform complex calculations.
Although the design is very traditional – old fashioned even – it is a prime example of Excel being used to bridge the gap between a system’s capabilities and the users’ requirements.
