Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Warehouse Development Process
Introduction
Practical Excercises Documents and Material (1:37)
Different Categories of Data Warehouse Implemetations
Diffrent Categories of Datawarehouse Projects (4:59)
Keywords/Terms used in this course
Data warehouse and Business Intelligence Glossary Part 1 (7:13)
Data warehouse and Business Intelligence Glossary Part 2 (4:24)
Additional Information on all the related keywords for the DW/BI projects (1:16)
What are Functional Requirements? (2:52)
What are Non Functional Requirements? (4:27)
Methodologies used for Data Warehouse Software Development
The Software Development Process (4:39)
What are the widely used methodologies for Enterprise Data Warehouse Set up? (3:33)
Waterfall Model
What is the Waterfall Model and what are the different phases involved? (2:21)
What are the different phases in Waterfall model? (1:43)
What is the Requirements phase? (6:13)
What is the importance of the Analysis phase and how IT plays a part in this? (2:22)
What are the activities done during the Design phase? (7:45)
What are the activities done during the Coding phase? (3:48)
What are the activities done during the Testing phase? (3:08)
What are the activities in Operations and Maintenance Phase? (4:26)
Follow the POC (Proof of Concept) model for better results (4:26)
What are the advantages of using the Waterfall Model? (2:59)
What are the disadvantages of using the Waterfall Model? (3:58)
Quiz on Water fall model
V Model
What are the different activities in the Verification phase? (12:00)
What are the different activities in the Validation phase? (6:06)
What are the advantages of the V Model? (2:04)
What are the disadvantages of the V Model and When to opt for this model? (2:06)
Quiz on 'V' model
Agile Model
Iterative Model (10:40)
017 Incremental Model (3:16)
Agile Model (2:23)
What are the advantages of Agile Model? (5:04)
What are the disadvantages of Agile Model (2:14)
When to go for the Agile Model? (2:18)
Quiz on 'Agile' model
Other SDLC Models
What are the other SDLC Models? (1:33)
Quiz for Other SDLC models
Which model to choose for the available models?
Which is the best model? (4:24)
Practical Implementation Steps
What are the practical implementation steps for the project? (2:12)
Project Planning
Defining the scope for the requirements (6:01)
Determining the goals and objectives of the project (2:26)
The Implementation Strategy (2:06)
Resource Identification and Alignment (3:37)
Project Deliverables and Timeline (1:35)
Summary - Quick Recap (1:28)
Quiz for Project Planning
Requirements
What are needed (2:10)
Who provides the inputs? (2:59)
Who gathers the requirements? (1:15)
How to perform the interviews to gather the requirements? (4:06)
Common questions which are usually asked during the Interviews (10:35)
Common questions which Business can ask IT (8:53)
Review of existing documents and resources (0:45)
026 06 Analyze the existing sources - Requirements (4:35)
Quiz for Requirements
Design
Design of the logical data model (1:32)
Data Architecture (2:15)
Data Architecture - How the data is organized and structured for various phases (5:25)
Technical Architecture (1:04)
Technical Architecture - The Hardware and Software part (4:07)
Delivery Framework (1:01)
Design the ETL process and functions (2:11)
Quiz for Design
Build and Develop
Infrastructure SetUp (1:47)
Data Warehouse/RDBMS Setup (0:46)
ETL Setup (2:49)
OLAP and Reporting Setup (0:58)
Testing the data flow (2:02)
Quiz for Development
Deploy
Versioning, Deployment and Production Release (3:00)
Maintenance and Operations
What are the activities done during the maintenance and operations? (4:26)
Review of the completed tasks
What went Right? and What went Wrong? (4:35)
Scoping and De-Scoping (2:33)
Application Usage Review (6:37)
Production Support and Maintenance
Support and Maintenance (7:46)
Data Architecture - How the data is organized and structured for various phases
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock