1 / 20

Michigan Data Warehouse Strategy Update

Learn about Michigan's progress in data sharing, the state's strategic alignment, and the next steps in governance and business intelligence. Find out how the state is maximizing resources and leveraging expertise to improve information sharing across government.

emanuelu
Download Presentation

Michigan Data Warehouse Strategy Update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MDIT Data WarehouseStrategy Update Michigan Data Warehouse 2007 Annual User Group Conference November 6, 2007 Kenneth D. TheisChief Deputy Director

  2. On tap today • More progress • Going to the next level • Governance • The Score Card

  3. More progress

  4. 180,000+ queries per dayMore progress Michigan currently is sharing over 2 terabytes of information, which equates to about 1/10 of all the books in the largest library in the world

  5. Data SharingMore progress More than 9,000 users in 5 major departments, 20 agencies and 100+ bureaus make use of the BI/data warehouse - Michigan’s Statewide Data Warehouse -

  6. Going to the next level

  7. Michigan Strategic AlignmentGoing to the next level The Governor’s six priority areas is the basis for… • MDIT Strategic Plan with five goals • Goal 2: Transform Michigan's services through sharing and collaboration • Seven Technology Solutions • Data Integration: is optimized through data warehousing

  8. Business Intelligencegoing to the next level • Prudent use of taxpayer money requires that we minimize the number of systems and tools that we use in Business Intelligence (BI) efforts • The State will likely never have enough resources, but BI can help to use existing resources more efficiently and effectively • The goal of BI is to maximize the use of shared or common resources by reducing the number of BI platforms to one, and to provide a single tool for each class of BI applications Data Warehousing is the physical aspect of storing data, and the process of turning data into information and knowledge is Business Intelligence

  9. Gartner Study Going to the next level • Gartner was contracted by MDIT to help the State of Michigan develop an enterprise information management and data warehouse strategy to: Increase the ability to better support both the infrastructure and the delivery of Business Intelligence solutions to the enterprise. Increase the ability to leverage both infrastructure and expertise. Actionable Increase information sharing across government.

  10. Governance

  11. The Next StepsGovernance

  12. Business Intelligence Competency CenterGovernance

  13. BICC MissionGovernance Encourage and enable business intelligence in the State of Michigan • It will do so by: • Supporting data sharing, • Providing support and training for data analysis, • Promulgate and support standards

  14. BICC First StepsGovernance OES: Privacy/Security • BICC • Data sharing • Metadata support • DW architecture • Development support • Communication • Training • BI development Agency Oversight OE&FS: Budgeting Agency Services Development Agency Data Stewards DCO Warehouse DBAs

  15. The Next StepsGovernance • Data Sharing inventory and build data sharing templates • Enhance the process to share existing data on the data warehouse • Platform evaluation – next generation • Begin design of the “Master Data Warehouse”

  16. BICC Data Sharing OpportunitiesGovernance

  17. The Score Card

  18. The Score Card

  19. The Score Card 2009…Game On!

  20. Kenneth D. Theis, Chief Deputy Director Michigan Department of Information Technology

More Related