Workforce Information: Power BI

Exciting Changes Coming to Our Workforce Information Platform

We’re pleased to announce some exciting updates to our Workforce Information platform that will be rolling out over the next few weeks. These changes are designed to enhance your experience and improve access to the data you need.

What’s Changing?

We’re transitioning to an app-based approach in Power BI, which will streamline how you interact with the platform. Your access will remain unchanged, and the transition should be seamless. However, you’ll notice updates to the navigation and menu structure. We’ll provide guidance to help you get familiar with the new layout. You will also need new links to access existing reports.

Growing with You

Our platform now hosts over 20 reports and dashboards, and we’re continuing to expand. Upcoming additions will support key areas such as:

• Pay Governance and Control
• Employment Services
• Medical Productivity

These enhancements are designed to better meet the evolving needs of the Trust and the wider organisation.

Collaboration Across Teams

We’re actively collaborating with Education and Strategy to develop new reports and dashboards that support service delivery. Future partnerships will include teams such as Information Compliance, ensuring our platform continues to grow in both scope and value.

Platform Developments

To meet the increasing demand for high-level, detailed, and sensitive reporting, we’ve introduced a new structure with two distinct spaces:

• Workforce Information Oversight Reporting: Offers high-level data and analysis, with drill-down capabilities by Trust structure and staff group.
• Workforce Detailed Reports: Provides access to more granular data, including staff names. Access to this space requires an approval process and compliance with Information Governance training.

This new structure allows us to develop and share sensitive reports in a secure and controlled environment.

When will this happen?

Changes have already started in the background with a new approval process tested and ready to launch, access has migrated over, and we plan to do the switch on Monday 1/9/2025. You will receive an email to confirm you have been migrated and any new links to reports you should use.

Further information is available here in the Staff HUB……………..

If you have any questions or need further information, please don’t hesitate to get in touch

WorkforceAnalyst@liverpoolft.nhs.uk

Using Power Bi to Improve Use of  Data within the Organisation

Why use Power BI?

Power BI is a powerful tool for several reasons:

In order to enable and support effective workforce management a suite of Pay and Management control Reports and Dashboards have been created.

You can Access the Power BI Platform for LUHFT by clicking the following link: Power BI

You will need to be given access to the LIGHT workspace, but once you have this you can access all the reports. To request access email WorkforceAnalyst@Liverpoolft.nhs.uk 

Data has been taken from various key sources such as ESR, the Financial General Ledger and Health Roster, and dashboards have been developed to show information at all levels in organisation making the dashboards useable for all levels of management in the trust.

The reports below are currently live and plans to enhance and develop new reports. For the most up to date report and dashboard link use the Power Bi link above.

A guide which shows some of the key features and functionality of the reports can be found here, and at the foot of this page.

If you need further support or guidance using the NEW Power BI platform the team are at hand to help just drop us an email to WorkforceAnalyst@Liverpoolft.nhs.uk and one of the team will be in touch.