1 / 13

dWiSACWIS

dWiSACWIS. The WiSACWIS Data Warehouse Nov 2007. dWiSACWIS. What is a data warehouse? Why do we need a data warehouse? Warehouse proof of concept & technology eWiSACWIS  eWReports  dWiSACWIS dWiSACWIS - Phases 1 & 2 Future phases Demo. What is a data warehouse?.

niesha
Download Presentation

dWiSACWIS

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. dWiSACWIS The WiSACWIS Data Warehouse Nov 2007

  2. dWiSACWIS • What is a data warehouse? • Why do we need a data warehouse? • Warehouse proof of concept & technology • eWiSACWISeWReportsdWiSACWIS • dWiSACWIS - Phases 1 & 2 • Future phases • Demo

  3. What is a data warehouse? • Database different and distinct from operational databases • Data is organized and summarized for analysis and decision making not daily workflows • One version of the truth  Trust • Data is scrubbed and cleaned • Extract/Transform & Load (ETL)

  4. What is a data warehouse? • Easy to use tools for query and analysis • Drag’n’Drop • Point’n’Click • Charts’n’Graphs • Slice’n’Dice • No programming or SQL • Metadata - Data about data • What is this • Where did it come from • How did it get here • Business focus rather than technical

  5. What is a data warehouse? Query? Data Warehouse DB A Data Mart X ETL Data Mart X DB B Data Mart X Data Mart Z DB C Data Mart Y Reports

  6. Why do we need a data warehouse? • eWReports Today… • Resource Hungry • Programming – Ad Hoc – Change • Inflexible • Yet another column of numbers • Show me the detail • What-if? • Difficult to compare over time • Worker is passive recipient

  7. Why do we need a data warehouse? • dWiSACWIS Tomorrow … • Support program area decision making • State Central Office • County • Flexible • View from 30,000 ft  Child/Case detail • Graph-to-Table-to-Chart • Worker is engaged participant

  8. Proof of Concept & Technology • Proof of concept • Oct-Nov 06 • Technology • Business Objects ™ • Among market leaders in Business Intelligence software • Bumper-to-Bumper warehouse solution • ETL - Data Integrator ™ • Data repository and services • Query & report tools • InfoView ™ & WebIntelligence ™ • Crystal Reports ™

  9. CPS Placement Fiscal Adoption eW eWR  dW dWiSACWIS eWiSACWIS eWReports eWReports Migrate

  10. dWiSACWIS – Phase 1 • Placement – Out of Home Care • Short Duration • Production Deployment Jun 29 2007 • State Central Office staff • Technical Infrastructure • Training • Lessons learned for phases 2+

  11. dWiSACWIS – Phase 2 • Adoptions • Production Deployment - Jan 2008 • Central Office • Adoption Regions • BMCW Adoption Staff

  12. dWiSACWIS – Future Phases • Identify key business data marts • Fiscal • CPS • Migrate eWReports • County pilot • Statewide rollout

  13. Questions

More Related