- Welcome and Thank You!
- Practical Exercises, Documents and Material
Online
₹ 449 2,299
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
certificate availability
certificate providing authority
The syllabus
Introduction
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
Instructors
Mr Sid Inf
Instructor
Freelancer