A large Minnesota county Health and Human Services (HHS) department provides a variety of services to county residents consistent with other counties in Minnesota, such as housing support, child welfare, and home and community based care. Leaders in the HHS department wanted to increase the ability to access and use data to improve operational efficiency and planning, thereby lowering administrative costs and improving service. The department uses a combination of manual and automated systems in the execution of its work, including the Social Services Information System (SSIS) provided by the state and Excel spreadsheets. There was no centralized store of data for use in analysis and reporting and it was difficult to get useful information out of these systems.
Superior Consulting Services built a reporting and analytics solution using the Microsoft Business Intelligence stack, including data extraction and transformation processes and Power BI dashboards, allowing the HHS staff to comprehensively view and analyze data.
