1 / 14

Data Warehousing

This lecture on Data Warehousing (DWH) by Ahsan Abdullah, Associate Professor at the National University of Computers & Emerging Sciences, focuses on the lifecycle and implementation of DWH using a goal-driven approach. Key topics include business requirement definition, technical architecture, dimensional modeling, project management, and the application of Kimball’s approach. The lecture highlights essential steps in project planning, requirements definition, and team establishment, offering insights into analytic application development and the maintenance of DWH systems.

liz
Télécharger la présentation

Data Warehousing

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. Virtual University of Pakistan Data Warehousing Lecture-33 DWH Implementation: Goal Driven Approach (1) Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp National University of Computers & Emerging Sciences, Islamabad Email: ahsan101@yahoo.com DWH-Ahsan Abdullah

  2. Data Warehouse (DWH) Lifecycle Business Requirement Definition Technical Architecture Design Product Selection & Installation Deployment Maintenance and Growth Dimensional Modeling Physical Design Data Staging Design & Development Analytic Application Specification Analytic Application Development Project Management Kimball’s Approach Business Dimensional Lifecycle Road map Graphics Project Planning DWH-Ahsan Abdullah

  3. DWH Lifecycle: Key steps DWH-Ahsan Abdullah

  4. DWH Lifecycle- Step 1: Project Planning DWH-Ahsan Abdullah

  5. DWH Lifecycle- Step 1: Project Planning DWH-Ahsan Abdullah

  6. DWH Lifecycle- Step 1: Project Planning DWH-Ahsan Abdullah

  7. Establishing the core team DWH-Ahsan Abdullah

  8. DWH Lifecycle- Step 1: Project Planning DWH-Ahsan Abdullah

  9. DWH Lifecycle- Step : 2Requirements Definition DWH-Ahsan Abdullah

  10. DWH Lifecycle- Step:2 Requirements Definition DWH-Ahsan Abdullah

  11. DWH Lifecycle- Step:2 Requirements Definition DWH-Ahsan Abdullah

  12. DWH Lifecycle- Step:2 Requirements Definition DWH-Ahsan Abdullah

  13. DWH Lifecycle- Step:2 Requirements Definition DWH-Ahsan Abdullah

  14. DWH Lifecycle- Step:2 Requirements Definition Business Process B Business Process A Business Impact Business Process D Business Process C Feasibility • Post Collection • Prioritization • Review & Prioritize findings • Quadrant Technique Graphics DWH-Ahsan Abdullah

More Related