I’m working on a writing case study and need a sample draft to help me understand better.
Read Application Case 3.4: EDW Helps Connect State Agencies in Michigan located in Chapter 3 of the textbook.
In 50-100 words each, address the questions presented at the end of the case study.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
Application Case 3.4 EDW Helps Connect State Agencies in Michigan
Through customer service, resource optimization, and the innovative use of information and tech-nology, the Michigan Department of Technology, Management and Budget (DTMB) impacts every area of government. Nearly 10,000 users in 5 major departments, 20 agencies, and more than 100 bureaus rely on the EDW to do their jobs more effectively and better serve Michigan residents. The EDW achieves $1 million per business day in finan-cial benefits.
The EDW helped Michigan achieve $200 million in annual financial benefits within the Department of Community Health alone, plus another $75 million per year within the Department of Human Services (DHS). These savings include program integrity benefits, cost avoidance due to improved outcomes, sanction avoidance, operational efficiencies, and the recovery of inappropriate payments within its Medicaid program.
The Michigan DHS data warehouse (DW) pro-vides unique and innovative information critical to the efficient operation of the agency from both a strategic and tactical level. Over the last 10 years, the DW has yielded a 15:1 cost-effectiveness ratio. Consolidated information from the DW now con-tributes to nearly every function of DHS, including accurate delivery of and accounting for benefits delivered to almost 2.5 million DHS public assis-tance clients.Michigan has been ambitious in its attempts to solve real-life problems through the innovative shar-ing 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 solu-tions using multiple channels.
QUESTIONS FOR DISCUSSION
1. Why would a state invest in a large and expen-sive IT infrastructure (such as an EDW)?
2. What is the size and complexity of the EDW used by state agencies in Michigan?
3. What were the challenges, the proposed solution, and the obtained results of the EDW?
Sources: Compiled from TDWI Best Practices Awards 2012 Winner, Enterprise Data Warehousing, Government and Non-Profit Category. Michigan Departments of Technology, Management & Budget (DTMB), Community Health (DCH), and Human Services (DHS). TDWI What Works, 34, 22; michigan.michigan.gov.
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."