Michigan Data Warehouse Users Group Conference

1
Michigan Data WarehouseUsers Group Conference

• Ken Theis, Deputy CIO/DIT
• Key Note Speaker

2
Agenda

• The Beginning
• Today
• The Future

3

• The Beginning

4
The Past 10 Yearsmuch progress, many successes
Treasury 2000
DCH 1995
CSES 1997
MDOT 2006
JIS 2002
CEPI 1999
DHS 1996
9,000 Users
Platform upgrades
10 Users
Price 60/GB
Price 330/GB
Common tools
Data Linking
5
The Beginning1995 - topology

• Business
• Specific applications only (S/UR TANF)
• No data sharing
• Two agencies only

• IT
• Independent agency development
• High support costs (330/1996)
• IT dependency for all queries and reports

• IT
• Independent agency development
• High support costs (330/1996)
• IT dependency for all queries and reports

• Platform
• Partitioned data marts
• Common platform

6
The Beginning1995 IT users only and limited
functionality

• Query and reporting
• No data sharing or integration
• Unidirectional data flow
• High latency and batch
• Passive and off-line

Source
DW
Source
1995
7

• Today

8
Todays Topology2005 - Enterprise platform,
common tools support

• Business
• User driven analysis and reporting
• Some implementation of Business Intelligence
• Some data sharing

• IT
• Independent agency development
• Some integration of data
• Reduced support costs (330/1996-gt60/2005)
• Common tools
• IT dependency for complex queries

• Platform
• Enterprise platform
• Central support
• Multiple independent data marts

9
Todays Users2005 - both IT and business users

• Query, reporting and dashboards
• Some data sharing and integration
• Some business users
• IT dependency for
• complex queries

Source
DW
Source
Source
1995 2005
10
Todaymany data sources and more than 9,000 users
11

• The Childrens Action Network
• The Power of Data Sharing

12
Childrens Action Network school view
13
Childrens Action Network family background view
14
Childrens Action Networksocial program
participation view
15
Childrens Action Network demographics view
16

• The Future

17
The Superior Value of Integrated Detailed Data
Program Analysis
Channel Analysis
Customer Analysis
Profitability
Enterprise Analysis
Business Value
Resource/ Supplier Data
Financial Data
Financial View
Value
EDW Investment
Customer Data
Customer View
Customer View
Transaction View
Transaction Data
Transaction View
Transaction View
Evolution To Enterprise View
Program Data
Program View
Program View
Program View
Program View
Data Mart Elimination
18
The Future Data Warehouse takes active role in
Business Process
Source
DW
Source
Source
DW
Source
Source

• Query and reporting
• Unidirectional data flow
• High latency and batch
• Passive and off-line

• QR transactional
• Enterprise analytics
• Closed-loop data flow
• Real-time and events
• Active and on-line

1995 2000
2005
19
The Futures Topologyenterprise data warehouse

• Business
• User driven analysis and reporting
• Business Intelligence
• Enhanced data sharing
• More self enabled complex queries

• IT
• Central support for data and usage
• Fully integrated data
• Continued reduction in support costs
• Standardized tools

• Platform
• Active, enterprise level data warehouse
• Consolidated platform

20
A Road Map to Successthe next steps

• Develop Strategic Plan
• Continue adding and integrate data to the Data
  Warehouse
• Consolidate data marts
• Create Center of Excellence for data warehousing
• Empower business users through BI tools and
  training
• Improve the Data Warehouse cost structure

Data Information Knowledge
21
Michigans Data Warehouse
The Michigan Data Warehouse has been recognized
nationally for innovation and excellence. Thank
you!