Programme performance improvement for an aerospace and defence contractor
Our client, a large Aerospace & Defence Contractor, were experiencing cost and schedule performance issues on a number of their complex engineering programmes. The client’s leadership team needed stronger visibility, insight and control from their performance data to improve programme execution and delivery.
Our team developed and deployed a comprehensive reporting solution which consolidated information across the clients programme controls, operational and functional support systems. Underpinning this solution, our team developed a data warehouse which has improved data integrity, trust and robustness across the organisation.
These solutions have allowed our client to anticipate and prioritise performance issues and effectively take corrective action to recover cost and maintain schedule adherence, ultimately improving programme performance and delivery.
Dashboards for improving patient care in the NHS
Our client is a large NHS foundation Trust with a £1 billion turnover a year. It provides a large range of health related services as well as specialist services for patients in its catchment area.
It had been suffering from an ageing data warehouse, fed by hundreds of separate clinical systems. The bulk of internal reporting has been confined to circulating large Microsoft® Excel® spreadsheets via email.
Our client wanted to enable its data users to analyse often large, complex datasets, where it was convenient for them – at their desk, in clinic or on the move. It needed to change its internal reporting process to become faster, more flexible and mobile-friendly.
PwC supported the client’s objectives by implementing a trust-wide QlikView reporting system, with an integrated suite of user-friendly dashboards. These dashboards substantially improved the user’s access to information, including via mobile devices, and provided more up to date reporting, including automated data refreshes.
Implementing a BI solution for a Small medium Business (SMB) company
Our client is a UK-based SMB company with an annual turnover of around £200 million. It produces chemicals used to manufacture glass, detergents and several other industry applications.
It is a predominantly paper based organisation, particularly when reporting and tracking KPIs/metrics. There was a lack of comprehensive, regularly produced management information which inhibited the organisation from making informed decisions.
We conducted a range of stakeholder interviews to help the organisation understand its information requirements. We then presented the client with a set of technology options which could address these requirements. After an independent vendor assessment and selection process, we helped the client implement their preferred Business Intelligence (BI) solution.
This solution has really helped the organisation reduce the effort required to produce information, has improved analytical capability and provided better control of operational costs.
Deploying BI tools in a global financial services organisation
Our client is a large global financial services organisation who wanted us to determine if their current suite of reporting tools (OBIEE, SAS and Microsoft® Excel®) had appropriate BI capabilities to enable business users to quickly identify and report complex issues to senior executives.
The initial phase of the project identified that their current tool set required multiple hand-offs to a central development team and significant system reconfiguration in adding non-strategic data sources. This was causing substantial delays in responding to major risk problems.
An analysis of industry leading BI tools identified the most appropriate solution which met the requirements gathered in the initial phase, which PwC then helped to deploy to the rest of the organisation.