Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Business
Business Analytics & Intelligence
Data Warehouse
Data Warehouse Development Process

Data Warehouse Development Process

Loại khoá học: Business Analytics & Intelligence

Specific aspects of Data Warehouse Development Process

image
50.000 VND
399.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Data is the new asset for the enterprises. And, Data Warehouse store the data for better insights and knowledge using Business Intelligence. Development of an Enterprise Data Warehouse has more challenges compared to any other software projects because of the 

  • Challenges with data structures
  • The way data is evaluated for it's quality
  • Complex business rules/validations
  • Different development methods (various SDLC models like Water Fall model, V model, Agile Model, Incremental model, Iterative model)
  • Regulatory requirements for various domains like finance, telecom, insurance, Retail and IME
  • Compliance from third party governing bodies
  • Extracting data for various visualization purposes

In this course, we talk about the specific aspects of the Data Warehouse Development process taking real time practical situations and how to handle them better using best practices for sustainable, scalable and robust implementations.

Bạn sẽ học được gì

Understand various stages in Data Warehouse development process

Various processes like Waterfall model, V model and Agile methods

Specific aspects of Data Warehouse development process

Importance of the various phases and the practicality of each phase

Overview of various issues and Project Management issues to be considered in the Data warehouse and Business Intelligence projects

Yêu cầu

  • Basics of Data Warehouse Concepts
  • Terms and terminologies used in a Data Warehouse and Business Intelligence projects

Nội dung khoá học

19 sections

Introduction

2 lectures
Welcome and Thank you!
06:00
Practical Exercises, Documents and Material
01:37

Different Categories of Data Warehouse Implementations

1 lectures
Different Categories of Data Warehouse Projects
04:59

Keywords/Terms used in this course

5 lectures
Data warehouse and Business Intelligence Glossary Part 1
07:13
Data warehouse and Business Intelligence Glossary Part 2
04:24
Additional Information on all the related keywords for the DW/BI projects
01:15
What are Functional Requirements?
02:52
What are Non Functional Requirements?
04:27

Methodologies used for Data Warehouse Software Development

2 lectures
The Software Development Process
04:39
What are the widely used methodologies for Enterprise Data Warehouse Set up?
03:33

Waterfall Model

12 lectures
What is the Waterfall Model and what are the different phases involved?
02:20
What are the different phases in Waterfall model?
01:43
What is the Requirements phase?
06:12
What is the importance of the Analysis phase and how IT plays a part in this?
02:22
What are the activities done during the Design phase?
07:45
What are the activities done during the Coding phase?
03:48
What are the activities done during the Testing phase?
03:08
What are the activities in Operations and Maintenance Phase?
04:26
Follow the POC (Proof of Concept) model for better results
04:26
What are the advantages of using the Waterfall Model?
02:59
What are the disadvantages of using the Waterfall Model?
03:58
Quiz on Water fall model
3 questions

V Model

5 lectures
What are the different activities in the Verification phase?
12:00
What are the different activities in the Validation phase?
06:06
What are the advantages of the V Model?
02:04
What are the disadvantages of the V Model and When to opt for this model?
02:06
Quiz on 'V' model
3 questions

Agile Model

7 lectures
Iterative Model
10:40
Incremental Model
03:16
Agile Model
02:23
What are the advantages of Agile Model?
05:04
What are the disadvantages of Agile Model?
02:14
When to go for the Agile Model?
02:18
Quiz on 'Agile' model
2 questions

Other SDLC Models

2 lectures
What are the other SDLC Models?
01:33
Quiz for Other SDLC models
1 question

Which model to choose for the available models?

1 lectures
Which is the best model?
04:24

Practical Implementation Steps

1 lectures
What are the practical implementation steps for the project?
02:12

Project Planning

7 lectures
Defining the scope for the requirements
06:01
Determining the goals and objectives of the project
02:26
The Implementation Strategy
02:06
Resource Identification and Alignment
03:37
Project Deliverable and Timeline
01:35
Summary - Quick Recap
01:28
Quiz for Project Planning
2 questions

Requirements

9 lectures
What are needed?
02:10
Who provides the inputs?
02:59
Who gathers the requirements?
01:15
How to perform the interviews to gather the requirements?
04:06
Common questions which are usually asked during the Interviews
10:35
Common questions which Business can ask IT
08:53
Review of existing documents and resources
00:45
Analyze the existing sources
04:35
Quiz for Requirements
2 questions

Design

8 lectures
Design of the logical data model
01:32
Data Architecture
02:15
Data Architecture - How the data is organized and structured for various phases
05:25
Technical Architecture
01:04
Technical Architecture - The Hardware and Software part
04:07
Delivery Framework
01:01
Design the ETL process and functions
02:11
Quiz for Design
1 question

Build and Develop

6 lectures
Infrastructure SetUp
01:47
Data Warehouse/RDBMS Setup
00:46
ETL Setup
02:49
OLAP and Reporting Setup
00:58
Testing the data flow
02:02
Quiz for Development
1 question

Deploy

1 lectures
Versioning, Deployment and Production Release
03:00

Maintenance and Operations

1 lectures
What are the activities done during the maintenance and operations?
04:26

Review of the completed tasks

3 lectures
What went Right? and What went Wrong?
04:35
Scoping and De-Scoping
02:33
Application Usage Review
06:37

Production Support and Maintenance

1 lectures
Support and Maintenance
07:46

Final Note

1 lectures
Final note on the course and how to get in touch with me
01:34

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Ethical Hacking Course by Black Hat Pakistan

Ethical Hacking Course by Black Hat Pakistan

26 VND
50.000 VND
AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

90 VND
50.000 VND
OpenStack Essentials

OpenStack Essentials

1.499.000 VND
50.000 VND
Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

1.399.000 VND
50.000 VND
Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

1.049.000 VND
50.000 VND
Reverse Engineering and Malware Analysis Fundamentals

Reverse Engineering and Malware Analysis Fundamentals

1.399.000 VND
50.000 VND
Microsoft Windows Server 2016 Training for Beginners

Microsoft Windows Server 2016 Training for Beginners

1.799.000 VND
50.000 VND
Learn Autocad API with C# - MVVM - WPF

Learn Autocad API with C# - MVVM - WPF

25 VND
50.000 VND
Ultimate AWS Certified Solutions Architect Associate SAA-C03

Ultimate AWS Certified Solutions Architect Associate SAA-C03

185 VND
50.000 VND
Website Hacking / Penetration Testing

Website Hacking / Penetration Testing

95 VND
50.000 VND
10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

26 VND
50.000 VND
MongoDB : A Complete Database Administration Course

MongoDB : A Complete Database Administration Course

999.000 VND
50.000 VND
Become Zabbix Administrator For Expert

Become Zabbix Administrator For Expert

799.000 VND
50.000 VND
Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

90 VND
50.000 VND
C++ Data Structures & Algorithms + LEETCODE Exercises

C++ Data Structures & Algorithms + LEETCODE Exercises

120 VND
50.000 VND
From Wire to PLC , A Bootcamp In Industrial Automation

From Wire to PLC , A Bootcamp In Industrial Automation

2.499.000 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi