- Welcome and Thank you!
- Practical Exercises, Documents and Material
- Different Categories of Data Warehouse Projects
- 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?
- The Software Development Process
- What are the widely used methodologies for Enterprise Data Warehouse Set up?
- 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
- 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
- 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
- What are the other SDLC Models?
- Quiz for Other SDLC models
- Which is the best model?
- What are the practical implementation steps for the project?
- 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
- 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 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
- Infrastructure SetUp
- Data Warehouse/RDBMS Setup
- ETL Setup
- OLAP and Reporting Setup
- Testing the data flow
- Quiz for Development
- Versioning, Deployment and Production Release
- What are the activities done during the maintenance and operations?
- What went Right? and What went Wrong?
- Scoping and De-Scoping
- Application Usage Review
- Support and Maintenance
- Final note on the course and how to get in touch with me