FOI request (FOIR-464349604)

Business Intelligence Functions

Requested Wed 09 November 2022
Responded Fri 11 November 2022

This is mainly a request for Business Intelligence functions.

1. Does the council provide adults and/or children services? If so, which case management system is used for each (for example, Mosaic, FRAMEWORKi and Care Director)?

2. What, if any, business intelligence software do you use against the above systems (for example, Tableau, PowerBI and Business Objects)?

3. If you use PowerBI, how do you access the underlying data? For example, is it via a data warehouse, using dataflows or direct access, and so on?

4. Do you use a KPI management system to collect internal indicator data, commentary, and so on?

5. Can you briefly describe the process around how you collect internal KPI data, commentary, and so on?