University Hospitals Birmingham NHS Foundation Trust (UHB) completed a merger by acquisition of Heart of England NHS Foundation Trust (HEFT) on 1st April 2018. Due to historical differences in data collection/reporting across UHB and the former Heart of England NHS Foundation Trust this response has been provided by hospital site.
Queen Elizabeth Hospital
1.Does the Finance department in your Trust currently use any business intelligence solutions to distribute and disseminate financial information throughout your organisation?
No.
2.If the answer to question 1 is yes, which systems are used? For example but not limited to: Qlikview, Microsoft Power BI, Tableau, bespoke developed internally.
Not applicable.
3.If the answer to question 1 is no, has the Finance department used a business intelligence solution at all in the last 10 years? If so, which systems?
No.
4.If the answer to question 3 is yes, what was the main reason for stopping use of the business intelligence solution?
Not applicable.
5.If the answer to question 1 or question 3 is yes, what financial information is included within the business intelligence solution?
Not applicable.
6.If the answer to question 1 or question 3 is yes what are/were the primary reasons/objectives for using business intelligence solutions for financial information?
Not applicable.
Heartlands, Good Hope and Solihull Hospital
1.Does the Finance department in your Trust currently use any business intelligence solutions to distribute and disseminate financial information throughout your organisation?
Yes
2.If the answer to question 1 is yes, which systems are used? For example but not limited to: Qlikview, Microsoft Power BI, Tableau, bespoke developed internally.
Microsoft SQL Server 2008 R2 (including SSRS and SSAS) with some in house development as well
3.If the answer to question 1 is no, has the Finance department used a business intelligence solution at all in the last 10 years? If so, which systems?
Not applicable.
4.If the answer to question 3 is yes, what was the main reason for stopping use of the business intelligence solution?
Not applicable.
5.If the answer to question 1 or question 3 is yes, what financial information is included within the business intelligence solution?
Budgets, General Ledger Balances, General Ledger Transactions, Sub Ledger Transaction Detail
6.If the answer to question 1 or question 3 is yes what are/were the primary reasons/objectives for using business intelligence solutions for financial information?
To make accurate and timely information available across the department and wider organisation.
