Contents
Central Business Intelligence Tool
Reference: 24-25387
Date response sent: 11/12/2024
Details of enquiry
I am writing to submit a request under the Freedom of Information Act 2000. Please find attached a spreadsheet containing the details of my questions and the preferred response format for ease of reply.
Specifically, I am seeking information on the following:
- The central access business intelligence (BI) tool used by the Trust.
I would appreciate it if you could complete the attached spreadsheet with the requested information and return it to me within the statutory time limit of 20 working days.
Response sent
| FOI – Central access to data | ||||
| BI Solution | Which BI Tool/solution does your information department utilise? | (X) | Comments | |
| PowerBI | X | |||
| Tableau | ||||
| SSRS | X | |||
| Qlikview | ||||
| Other please state: | ||||
| DWH Solution | Please select the appropriate options from below regarding your data warehousing: | (X) | Comments | |
| Cloud solution – Developed and managed internally by Trust | ||||
| On prem solution – Developed and managed internally by Trust | X | |||
| Cloud solution – A purchased and supported product (pls name product) | ||||
| On prem solution – A purchased and supported product (pls name product) | X | |||
| Other please state: | ||||
| Information Portal | Please select the appropriate option from below regarding your central information portal which supports access to reports in your Trust | (X) | Comments | |
| In house built solution based on your BI tool | X | |||
| In house built solution based on a SharePoint site | ||||
| In house built web based solution | ||||
| Purchased product (pls name the product) | ||||
| Other | ||||
| Does your information portal have the below features? | Yes/No | Comments | ||
| Report Publication | Enable access to published Trust reports of multiple types e.g. Tableau, Excel, SSRS, Power BI, PDF etc. | Yes | ||
| Report Search | Does your information portal allow users to search and find reports based on: | Yes/No | Comments | |
| Google type based search – Find reports based on free text search against the meta data and related keywords for available reports | N/A | The Trust does not have a central information portal | ||
| Category based search – Find reports via a hierarchy of structured folders/sub-folders. | Yes | |||
| Data-source/System search – find reports related to a system or dataset | Yes | |||
| Report Access | Does your information portal allow users to more effectively access regular reports based on | Yes/No | Comments | |
| Favourite reports – added to the user’s favourite reports list by the user directly or based on reports frequently accessed by the user. | Yes | They can save favourites | ||
| Profiled reports – added to the user’s profiled reports list, based on the user’s role e.g. Nurse, Operational manager. The reports available for that role are defined by a key stakeholder. | Yes | Based on the services | ||
| Recommended reports – These are new and sometimes existing reports added to the users recommended reports list. Recommendations are made by the informatics department or a key stakeholder for the user’s role. | No | |||
| Adhoc Report Request | Are data requests for new reports made via | (X) | Comments | |
| Your information portal | ||||
| A separate system from your information portal ( pls provide name of system) | X | |||
| Other | ||||
| Does your information request process enable the below | Yes/No | Comments | ||
| – you to effectively process and track information requests for your team | Yes | |||
| – your users to effectively track the progress of their information request? | Yes | |||
| Contact | Would an information portal with all or some of the above functionalities be of interest to you | Yes/No | Comments | |
| (if yes pls provide appropriate contact details) | No | |||