MDIT Data Warehouse Strategy Update Michigan Data Warehouse

MDIT Data Warehouse Strategy Update Michigan Data Warehouse 2007 Annual User Group Conference November 6, 2007 Kenneth D. Theis Chief Deputy Director

On tap today w w More progress Going to the next level Governance The Score Card State of Michigan • Department of Information Technology 2 2

More progress State of Michigan • Department of Information Technology 3 3

180, 000+ queries per day More 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 State of Michigan • Department of Information Technology 4 4

Data Sharing More 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 - State of Michigan • Department of Information Technology 5 5

Going to the next level State of Michigan • Department of Information Technology 6 6

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

Business Intelligence going to the next level w Prudent use of taxpayer money requires that we minimize the number of systems and tools that we use in Business Intelligence (BI) efforts w The State will likely never have enough resources, but BI can help to use existing resources more efficiently and effectively w 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 State of Michigan • Department of Information Technology 8 8

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

Governance State of Michigan • Department of Information Technology 10 10

The Next Steps Governance State of Michigan • Department of Information Technology 11 11

Business Intelligence Competency Center Governance State of Michigan • Department of Information Technology 12 12

BICC Mission Governance Encourage and enable business intelligence in the State of Michigan w It will do so by: § Supporting data sharing, § Providing support and training for data analysis, § Promulgate and support standards State of Michigan • Department of Information Technology 13 13

BICC First Steps Governance OES: Privacy/Security BICC Agency Oversight • Data sharing • Metadata support • DW architecture • Development support • Communication • Training • BI development Agency Data Stewards State of Michigan • Department of Information Technology OE&FS: Budgeting Agency Services Development DCO Warehouse DBAs 14 14

The Next Steps Governance w Data Sharing inventory and build data sharing templates w Enhance the process to share existing data on the data warehouse w Platform evaluation – next generation w Begin design of the “Master Data Warehouse” State of Michigan • Department of Information Technology 15 15

BICC Data Sharing Opportunities Governance State of Michigan • Department of Information Technology 16 16

The Score Card State of Michigan • Department of Information Technology 17 17

The Score Card 2005 -2007 2008 ü Develop Strategic Plan q Establish BICC within Shared Services ü Continue adding and integrate data to the Data Warehouse q Complete the foundation for the “Master Data” Warehouse ü Consolidate data marts q Establish the BI platform for the next 5 -10 years ü Create Center of Excellence for data warehousing q Create data sharing inventory/establish data sharing support ü Empower business users through BI tools and training q Improve management of shared data on warehouse ü Improve the Data Warehouse cost structure q Establish BICC within Shared Services State of Michigan • Department of Information Technology 18 18

The Score Card 2009…Game On! State of Michigan • Department of Information Technology 19 19

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