layer 1 layer 2 layer 3 layer 4 layer 5 abstract shapes

Covid-19 dashboard replacement harnessing Azure

  • Azure
  • Power BI

Acting on a referral from two NHS organisations, Liverpool CCG approached BCN to replace a Power BI Covid-19 dashboard within a 14-day deadline, and move their existing performance data into an optimised, easy-to-use analytics reporting system

  • Customer

    • NHS Liverpool CGC (Clinical Commissioning Group)
  • Sector

    • Healthcare
  • Project

    • Fast track Covid-19 Dashboard Replacement and performance data migration
  • Technology

    • Microsoft Power BI
    • Microsoft Azure Blob Storage
    • Azure Data Factory
    • Azure SQL Database
  • Timeline

    • 14 day deadline met. Replacement Dashboard delivered in just 2 days

Challenge

Acting on a referral from two NHS Wirral organisations, Liverpool CCG approached BCN and asked us to:

  • Replace a Power BI Covid-19 Dashboard before the contract expired (14 day deadline)
  • Move existing performance data into optimised, easy-to-use analytics reporting system

Results

Using Azure we delivered a Covid-19 Dashboard in just 2 days during one of the busiest periods in NHS history.

  • We met an immovable deadline to migrate and improve the expiring Covid-19 Dashboard
  • Our development team ensured the new dashboard was fully compatible with multiple stakeholder IT systems throughout Cheshire and Merseyside
  • Our unique Power BI report templates are designed to make life much easier for users and speeded up reporting processes by 75%
  • Cloud2 provided high-level consultancy support to guide and inform the client’s decision-making process

We worked to a very tight deadline of just two weeks to migrate and replace an existing Covid-19 Dashboard that had been created in Microsoft Power BI by a multinational professional services company.

We created a ‘read only’ dashboard that is simple to access and accommodates the different knowledge levels of Microsoft Power BI users.

We designed new, sophisticated architecture by incorporating a range of Azure services, including Azure Blob Storage, Azure Data Factory and Azure SQL Database. We also created data tables before re-connecting Power BI reporting to the data source.

Our working knowledge of Microsoft Azure allowed us to deliver this fully tested and operational replacement dashboard in just two days. The second objective was to move existing performance data into amore intuitive analytics-based reporting system.

We carried out a Power BI Readiness Assessment before introducing Cloud2’s unique Microsoft Power BI Kickstarter programme to ensure best practice was followed.

We created a Power BI Data Cube which managed the client’s existing data set and used our unique IP templates to create reports that offer faster and better insights while also providing end users with a consistent user-friendly interface.

Our tailored analytics-driven solution has increased reporting process speeds by 75% and the new dashboard is fully accessible by multiple stakeholders throughout Cheshire and Merseyside.

Testimonial

BCN have been integral to our Power BI launch. At all levels, they have been informed, insightful, friendly and proactive; always available to answer a question or provide a quick solution. They have shown great awareness in pitching their advice to the technical knowledge of their customer and making our transition to cloud-based reporting as pain free as possible.

Tim Caine

Head of Business Intelligence

Related success stories

Back all customer stories down

01 02 03  / 03

Hampshire Hospitals NHS Trust

Employing over 8,000 staff, Hampshire Hospitals provides acute care services to over 600,000 patients. Despite initial hesitations, the Trust were impressed with the granularity in which Public View enabled performance monitoring, benchmarking, and comparison of other Trusts, causing Hampshire to sign a 3-year contract for Public View.

View Case Study right
  • Healthcare
  • Public View

Walsall Healthcare NHS Trust

Walsall NHS Foundation Trust wanted to replace their existing intranet with the LiveTiles Enterprise and Reach platform to improve workplace communication and upgrade user experiences.

View Case Study right
  • Healthcare
  • LiveTiles

East London NHS Foundation Trust

East London NHS Foundation Trust (ELFT) is renowned across the UK’s public health sector as a pioneer of continuous quality improvement. ELFT now uses SPC Charts to provide its teams with intelligent insights in near real-time to support the prediction of future trends, the identification of variations and data-informed decision-making.

View Case Study right
  • EasySPC
  • Healthcare
  • Power BI
prev prev

Ready to grow your business? Let’s talk tech.

Follow the link or speak to one of our experts on 0345 095 7000

Get in touch down down down