Power BI migration & implementation process & outcomes for North Bristol Trust (NBT) – pt2

Background

When North Bristol Trust (NBT) was tasked with migrating their existing reporting tool to Power BI, CACI was their trusted partner that supported the successful production of a migration readiness package. This readiness package included a detailed report of all quantitative and qualitative findings, a newfound understanding of existing functions and capabilities, a reassessment of future requirements and definitive progression of next steps in the Trust’s migration from business case creation to sign-off.

NBT possessed over 100 reports in their pre-existing analytics platform, ranging from list-based for front line, operational workers to more backend, dashboard and analysis reports for email distribution. Once these reports needed to move from NBT’s pre-existing system to Power BI, the Trust wanted to understand and reconsider their design, particularly its contents and data structure.

Customer lead

Andrew Elliott, Head of Data Analytics at North Bristol Trust, has handled analytics platform outputs and has been a key player in the Trust’s Power BI migration.

Project mapping & planning

The first course of action identified for NBT was the need to improve efficiency when creating reports. This was a multi-step action, not simply addressing the speed at which reports are updated, but the efficiency and maintenance of data.

To achieve this, Andrew’s team revisited their hospital data analysis practices to ensure they would remain up-to-date, reliable and accurate.

There was also an emphasis on redesigning the data models that fed the reports to meet requirements. This required a substantial amount of analysis to understand where data was coming from and what NBT was doing with that data to display the report. Once this analysis was complete, NBT had to consider how it could be streamlined to become more efficient and recreate that logic in a new location within their data warehouse.

With these needs in consideration, Andrew’s team reached a consensus on the requirement for a new reporting database, as well as a redesign of the data models that would facilitate the moving of their reporting tool.

Action

This process took the Trust a lot of time and input from CACI to execute, as the initial input stages were focused on providing business knowledge and data understanding, with CACI possessing the technical knowledge. CACI’s Richard Brennan, Principal Consultant, worked on the mapping process and provided ongoing support to Andrew’s team.

Determining the best design for that data followed this. Andrew’s team had ambitions on what the Trust wanted to do with their data, one of which was knowing that through Power BI, other analysts from across the hospital could be brought on board. The board was an especially important and crucial factor as NBT approached the Power BI go-live date. For Andrew’s team, this included ensuring alignment on decision-making, gaining organisation-wide buy-in and keeping motivation up.

“We weren’t putting our head in the sand, we were very honest with any issues that we had and [the board was] immensely helpful in their responses, particularly around communication,” Andrew shared.

In the weeks prior to going live, Andrew’s team liaised with key individuals in the Trust across various departments and divisions on the status of upcoming reports. Power BI also began to be displayed on the intranet’s homepage of the intranet for collective awareness on Power BI going live. NBT followed an additional CACI recommendation of forming a Power BI developer group for regular meetings to take place on what Andrew’s team was doing, how they were using Power BI, encourage others to use Power BI and share best practises.

All licenses were in place and once the reports were signed off as tested, they were moved into the appropriate workspace apps for users. A soft launch using advanced functionality for several areas took place a week prior to go-live to ensure comfortability of using Power BI and iron out any final issues before eradicating their pre-existing BI tool. The final step was adding users to groups for immediate access and turning off the original platform.

By Friday afternoon, users were given access while the original platform remained available over the weekend, and by Monday morning, a blocking page prohibiting access was implemented, marking the official introduction of Power BI.

Supporting our customer

The diversity of requirements and revisiting the data design were two pivotal focal points to be reprioritised over the course of the implementation.

The ambition around optimised data design was initially obfuscated due to the comparatively little data available from various clinical divisions and departments across the hospital that used Excel. This prompted Andrew and his team to encourage the use of one cohesive reporting platform to ensure data sufficiency, accuracy and reliability, creating an environment that analysts would engage with and host their reporting on and unite users.

The immense size of this ambition quickly became clear to the Trust, particularly regarding the data scope, the systems it took from, the amount of available data and the data that was also being used by divisional analysts. The Trust also acknowledged the fixed date by which this project had to be completed. Upon further investigation into the data sources, an added layer of complexity came to be: rebuilding all the data sources into a new data model would not be possible to achieve by the stringent deadline. With CACI’s help, however, the situation took a positive turn.

“CACI provided helpful support and advice [during this time], even during times where I think our project had gone from a green to an amber stage where we were coming into the last couple of months,” Andrew shared. “CACI was incredibly supportive of the decisions that we were making, also contributing to those decisions themselves.”

Success

Richard’s Power BI configuration has set up Andrew’s team for a successful first few weeks of post-go-live, with the team receiving about 600 hits on reports in the first two days post-go-live and receiving approximately 60 support requests (mainly access requests or general functionality enquiries). While some minor accuracy issues with outpatients arose and were resolved quickly, the reporting has remained accurate and was very well received by the end users.

According to Andrew, Richard’s continued support in demonstrating any changes to the semantic models, identifying any issues with uploading data or explaining the environment’s functions has been particularly useful.

“We had Richard in the background with any small changes that we wanted to do with the data loads or semantic models, and that support was useful in the run-up and afterwards, because we’ve watched how to look after this system as Richard has built it, but when you’re actually live and you’ve got to look after yourself, it’s nice to have that bit of hand-holding as you learn,” he explained.

That brings us to present day, where NBT has moved out of the post-go-live period of constant close monitoring and rapid issue resolution towards a business-as-usual position. Plans for future enhancements to the environment and the data behind it can now be reviewed, along with an assessment of the Trust’s future and the potential of reaching a similar outcome with NBT’s partner, UHBW, enabling both data teams to have the same view of data across Trusts and share it seamlessly. The project’s success also led to Andrew and his team being nominated by NBT’s Operations leadership for their annual staff award, an internal mark of excellence and recognition for a project well-delivered.

“This project has been a lot of hard work, but it’s been a great project and fantastic to work with [CACI],” Andrew concluded. “I really enjoyed it and [CACI] brought a lot of experience and expertise to the vision and ambition that we had, so I really appreciate it.”