accurate delivery of and accounting for benefits delivered to almost 2.5 million DHS public assistance clients. Michigan has been ambitious in its attempts to solve real-life problems through the...

accurate delivery of and accounting for benefits delivered to almost 2.5 million DHS public assistance clients.

Michigan has been ambitious in its attempts to solve real-life problems through the innovative sharing and comprehensive analyses of data. Its approach to BI/DW has always been “enterprise” (statewide) in nature, rather than having separate BI/DW platforms for each business area or state agency. By removing barriers to sharing enterprise data across business units, Michigan has leveraged massive amounts of data to create innovative approaches to the use of BI/DW, delivering efficient, reliable enterprise solutions using multiple channels.

1. Why would a state invest in a large and expensive IT infrastructure (such as an EDW)?

2. What are the size and complexity of EDW used by state agencies in Michigan?

3. What were the challenges, the proposed solution, and the obtained results of the EDW?