Reference no: EM133571180

Case Study: Michigan's budget, management, and technology department has 10,000 users in 5 major departments, 20 agencies, and more than 100 offices. They all depend on a data store. EDW is called the Michigan data store. Everyone depends on this data store to do their jobs more effectively and serve Michigan residents. This data warehouse achieves financial benefits of one million dollars per day. The data store managed to help reach $200 million in annual financial benefits from the health department alone, but another $75 million from the human services department. These savings include avoiding costs of integrity benefits due to improved results, avoiding penalties, operational efficiencies, and improper recovery of payments within your Medicaid program (medical aid) The data storage provides innovative critical information for the efficient operation of the agency at both the strategic and tactical levels. For over 10 years data storage has produced a cost-effective ratio of 15 to 1. Consolidated Data Warehouse Information (DW) now contributes to almost every function of the department including accurate distribution and accounting of benefits provided to more than 2.5 million public assistance customers. Michigan has been very ambitious in its attempt to solve real-life problems by sharing data and analyzing them in a very innovative way. Your approach to Business Intelligence / Data Storage has always been a company in nature, instead of having separate platforms of Intelligence Business Intelligence/ Data Storage, for each business area or state agency. Overhauling the barriers of data sharing across different business units, the state of Michigan has managed massive amounts of data to create innovative approaches to the use of business intelligence and data warehouses, delivering efficient and reliable solutions using multiple channels.

Questions:

1. Why should a state make such a large and expensive investment as an EDW?

2. How large and complex was the EDW used by Michigan state agencies?

3. What were the challenges, the solutions proposed, and the results obtained from the EDW?