A Presentation on A Strategy for Data Management Barry Williams Principal Consultant Database Answers Ltd.
A Strategy for Data Management • Where are we now (‘As-Is’) ? • How does the Future look (‘To-Be’) ? • How do we get there ?
Objectives of the Strategy • Provide Good Quality Data • Establish a Single View of the Truth • Adopt a Structured Framework
Getting Started • Step 1. Asses the Present – ‘As-Is’ • Step 2. Determine the Future – ‘To-Be’ • Step 3. Establish a Migration Path
Silo Databases Ad-Hoc Data Integration (CSV Files, FTP, and so on) Order Processing CRM Billing
Early Steps to Integration Integrated Data Platform (Business Data Model and Enterprise Service Bus) Order Processing CRM Billing
The Short-Term Future Integrated Data Platform (Business Data Model and Enterprise Service Bus) Order Processing CRM Billing
The Future Generic Data Mart ‘A Single Version of the Truth’ Integrated Data Platform Order Processing Billing CRM
The Long-Term FutureFramework – Part 1 Stage 1. Data Governance Stage 2. BI + Performance Reports Stage 3. Data Marts
The Long-Term FutureFramework – Part 2 Stage 4. Data Integration Stage 5. Data Sources Stage 6. Information Catalogue
Top-Level Business Data Model Customers Invoices Orders Brands Payments Products Order Items
Thank you for your time.You can contact me at email@example.com