Overall handbook S-DWH

1. ESSnet on Data Warehousing Overall handbook S-DWH

2. ESSnet on Datawarehousing The roadmap to the statistical data warehouse Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

3. Goal • Give answer to following questions: • What is a Statistical Data Warehouse (S-DWH) ? • How does a S-DWH differ from a traditional = 'commercial' DWH ? • Why should we build a S-DWH ? • Who are the envisaged users of a S-DWH ? Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

4. Goal • Give a road map for designing, building and implementing the S-DWH: • Prerequisites for implementing a S-DWH • What phases / steps to take • How to prepare for an implementation Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

5. 5 Development Phases • Use & Maintain • Implement • Build • Design • Business Case Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

6. Main Route Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

7. Phase 1: Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

8. Phase 2: Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

9. Phase 3: Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

10. Total map Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

11. Discussion in groups • If you are going to develop a S-DWH: • Would you use this handbook ? • If not • Please explain why and perhaps suggest any improvements • If yes: • What do you find useful, are there parts missing ? • Is there something else you would use ? Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013

12. Discussion in groups • Regarding the 5 phases/steps: • Is there a phase missing ? • Based upon your experience: • Does it make sense ? • Does it match (or not) with the methods used in your NSI ? Handbook S-DWH – WS Amsterdam, 25 & 26 september 2013