Introduction
  • Welcome and Thank you!
  • Practical Exercises, Documents and Material
Different Categories of Data Warehouse Implementations
  • Different Categories of Data Warehouse Projects
Keywords/Terms used in this course
  • Data warehouse and Business Intelligence Glossary Part 1
  • Data warehouse and Business Intelligence Glossary Part 2
  • Additional Information on all the related keywords for the DW/BI projects
  • What are Functional Requirements?
  • What are Non Functional Requirements?
Methodologies used for Data Warehouse Software Development
  • The Software Development Process
  • What are the widely used methodologies for Enterprise Data Warehouse Set up?
Waterfall Model
  • What is the Waterfall Model and what are the different phases involved?
  • What are the different phases in Waterfall model?
  • What is the Requirements phase?
  • What is the importance of the Analysis phase and how IT plays a part in this?
  • What are the activities done during the Design phase?
  • What are the activities done during the Coding phase?
  • What are the activities done during the Testing phase?
  • What are the activities in Operations and Maintenance Phase?
  • Follow the POC (Proof of Concept) model for better results
  • What are the advantages of using the Waterfall Model?
  • What are the disadvantages of using the Waterfall Model?
  • Quiz on Water fall model
V Model
  • What are the different activities in the Verification phase?
  • What are the different activities in the Validation phase?
  • What are the advantages of the V Model?
  • What are the disadvantages of the V Model and When to opt for this model?
  • Quiz on 'V' model
Agile Model
  • Iterative Model
  • Incremental Model
  • Agile Model
  • What are the advantages of Agile Model?
  • What are the disadvantages of Agile Model?
  • When to go for the Agile Model?
  • Quiz on 'Agile' model
Other SDLC Models
  • What are the other SDLC Models?
  • Quiz for Other SDLC models
Which model to choose for the available models?
  • Which is the best model?
Practical Implementation Steps
  • What are the practical implementation steps for the project?
Project Planning
  • Defining the scope for the requirements
  • Determining the goals and objectives of the project
  • The Implementation Strategy
  • Resource Identification and Alignment
  • Project Deliverable and Timeline
  • Summary - Quick Recap
  • Quiz for Project Planning
Requirements
  • What are needed?
  • Who provides the inputs?
  • Who gathers the requirements?
  • How to perform the interviews to gather the requirements?
  • Common questions which are usually asked during the Interviews
  • Common questions which Business can ask IT
  • Review of existing documents and resources
  • Analyze the existing sources
  • Quiz for Requirements
Design
  • Design of the logical data model
  • Data Architecture
  • Data Architecture - How the data is organized and structured for various phases
  • Technical Architecture
  • Technical Architecture - The Hardware and Software part
  • Delivery Framework
  • Design the ETL process and functions
  • Quiz for Design
Build and Develop
  • Infrastructure SetUp
  • Data Warehouse/RDBMS Setup
  • ETL Setup
  • OLAP and Reporting Setup
  • Testing the data flow
  • Quiz for Development
Deploy
  • Versioning, Deployment and Production Release
Maintenance and Operations
  • What are the activities done during the maintenance and operations?
Review of the completed tasks
  • What went Right? and What went Wrong?
  • Scoping and De-Scoping
  • Application Usage Review
Production Support and Maintenance
  • Support and Maintenance
Final Note
  • Final note on the course and how to get in touch with me