1. Does the council provide adults and/or children services? If so, which case management system is used for each(e.g., Mosaic, FRAMEWORKi and Care Director).
Childrens Services – Eclipse & MASH guardian
Adults Services – CareFirst 6 by OLM
2. What, if any, business intelligence software do you use against the above systems(e.g., Tablio, PowerBI and Business Objects)?
Childrens Services – PowerBi
Adults Services – Power BI
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 etc.
Childrens Services – Combination, some reports are via a data warehouse (& data flows) some use direct connections
Adults Services – Mostly via a data warehouse with some limited use of dataflows
4. Do you use a KPI management system to collect internal indicator data, commentary etc?
Childrens Services – No
Adults Services – No
5. Can you briefly describe the process around how you collect internal KPI data and commentary etc?
Childrens Services – This is done by the Children’s Management Information team working in conjunction with senior managers
Adults Services – This is done by the Adults Management Information team working in conjunction with senior managers