The Pennine Care NHS Foundation Trust collects thousands of data points every day through more than 15 different information systems. Data collection ranges from clinical patient information to internal financial costs, incident reporting, and child services activity. Internal employees, commissioners, and NHS statutory bodies all rely on this data to effectively manage business processes.
Before Tableau, the Trust was reliant on Excel and manual SQL queries for analysis, leading to long development cycles with poor data quality. And by the time a report came out, it was already outdated. As a result, many management staff simply didn’t trust the data and were ignoring the reports altogether.
In response, the Trust’s information team adopted Tableau. Instead of Excel-based monthly reports, the team distributes Tableau dashboards to all operational managers in the organization. Staff can also connect directly to the Trust’s data warehouse in Tableau, which contains data from both clinical and corporate systems.
Today, teams can view comprehensive reports containing clinical, workforce, finance, and clinical governance data on a daily basis instead of waiting for weeks in long reporting queues. “This allows the Trust to understand what the services are doing and how they are performing,” explains Ella Worsdale, Head of Information at Pennine Care NHS Foundation Trust.
“All of a sudden, we can present data back really quickly,” shares Ella. “Now we've got reports in Tableau that people can access every single day and it's as live as we can make it. People can get what they need now, rather than waiting until next month.”
As a result, the information team has also seen a significant improvement in data quality and collaboration. This has allowed the information team to combine key information from all the Trust’s different systems to determine what's really going on, both internally and externally.
“Now people trust the information they're getting and can make real service decisions based on it,” adds Ella. “It's really changing the way we look at data and how that can influence decisions within the Trust. Tableau makes it accessible.”