How does data integration can lead to better data quality?

and Help answer Application Case

Application Case 3.4 EDW Helps Connect State Agencies in Michigan Through customer service, resource optimization, delivered to almost 2.5 million DHS public assis- and the innovative use of information and tech tance clients. nology, the Michigan Department of Technology, Michigan has been ambitious in its attempts to Management and Budget (DTMB) impacts every solve real-life problems through the innovative shar- area of government. Nearly 10,000 users in 5 majoring and comprehensive analyses of data. Its approach departments, 20 agencies, and more than 100 to BI/DW has always been "enterprise" (statewide) in bureaus rely on the EDW to do their jobs more nature, rather than having separate BI/DW platforms effectively and better serve Michigan residents. The for each business area or state agency. By removing EDW achieves $1 million per business day in finan barriers to sharing enterprise data across business cial benefits. units, Michigan has leveraged massive amounts of The EDW helped Michigan achieve $200 million data to create innovative approaches to the use of in annual financial benefits within the Department of BI/DW, delivering efficient, reliable enterprise solu- Community Health alone, plus another $75 million tions using multiple channels. per year within the Department of Human Services (DHS). These savings include program integrity ben QUESTIONS FOR DISCUSSION efits, cost avoidance due to improved outcomes, 1. Why would a state invest in a large and expen- sanction avoidance, operational efficiencies, and sive IT infrastructure (such as an EDW)? the recovery of inappropriate payments within its Medicaid program. 2. What is the size and complexity of the EDW used The Michigan DHS data warehouse (DW) pro- by state agencies in Michigan? vides unique and innovative information critical to 3. What were the challenges, the proposed solu- the efficient operation of the agency from both a tion, and the obtained results of the EDW? strategic and tactical level. Over the last 10 years, the DW has yielded a 15:1 cost-effectiveness ratio. Sources: Compiled from TDWI Best Practices Awards 2012 Winner, Enterprise Data Warehousing Government and Non-Profit Consolidated information from the DW now con- Category. Michigan Departments of Technology. Management & tributes to nearly every function of DHS, including Budget (DTMB), Community Health (DCH). and Human Services accurate delivery of and accounting for benefits (DHS). TDW7 What Works, 34, 22: michigan michigan.gov