Data Warehousing
3.6 (156 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,071 students enrolled

Data Warehousing

An introductory course about understanding data warehousing, its architecture, flow, applications and modeling.
3.6 (156 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,071 students enrolled
Last updated 3/2015
English
English [Auto-generated]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 min on-demand audio
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Be introduced to the data warehouse, its advantages and disadvantages.
  • Know the concepts, lifecycle and rules of the data warehouse.
  • Be informed of the importance and the techniques of data warehouse modeling.
  • Recognize the different applications of data warehousing.
  • Look forward to the future of the data warehouse.
Course content
Expand all 66 lectures 02:53:52
+ Introduction to Data Warehousing
7 lectures 21:20

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 2: Definition of Data Warehousing

Lecture 3: History of Data Warehousing

Lecture 4: Advantages of Data Warehousing

Lecture 5: Disadvantages of Data Warehousing

Lecture 6: Benefits of Data Warehousing

Lecture 7: Concepts of Data Warehousing

Preview 00:30

This lecture will explain the definitions of data warehousing.

Preview 04:11

This lecture will talk about the history and relevance of data warehousing.

Preview 04:47

This lecture will identify the different advantages of data warehousing.

.

Lecture outline:

0:00    Introduction to the Advantages of Data Warehousing
0:21    Main Advantages of Data Warehousing
1:15    Powerful Feature of Data Warehousing
Preview 02:23

This lecture will identify the different disadvantages of data warehousing.

Disadvantages of Data Warehousing
03:08

This lecture will identify the different benefits of data warehousing.

Benefits of Data Warehousing
02:11

This lecture will identify and explain the concepts of data warehousing.

.

Lecture outline:

0:00    Introduction to the Concepts of Data Warehousing
0:06    Subject Oriented
1:00    Integrated
1:52   Time Variant
3:13   Non Volatile
Concepts of Data Warehousing
04:10
+ OLTP, OLAP and Other Terminologies
8 lectures 32:39

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 10: Online Transaction Processing

Lecture 11: Data Store

Lecture 12: Data Mart

Lecture 13: Design Schemas

Lecture 14: Meta Data

Lecture 15: Data Webhouse and Data Warehouse Queries

Lecture 16: Extract, Transform, Load

Introduction and Objectives
00:37

This lecture will identify the difference between online transaction processing or OLTP and online analytical processing or OLAP.

.

Lecture outline:

0:00    Online Transaction Processing
1:12    Advantages of OLTP
1:49    Disadvantages of OLTP
2:40    Online Analytical Processing
3:48    OLAP Tools
5:11    Types of OLAP Systems
Online Transaction Processing
08:42

This lecture will explain the definition of data store and some reasons for creating it.

Data Store
00:53

This lecture will explain data mart and identify its characteristics.

.

Lecture outline:

0:00    Definition of Data Mart
1:23    Primary Use of Data Mart
2:24    Characteristics of Data Mart
2:42    Reasons for Creating Data Mart
Data Mart
03:24

This discussion will focus on design schemas namely Star schema and Snowflake schema.

.

Lecture outline:

0:00    Star Schema
0:38    Model of Star Schema
1:30    Components of Star Schema
2:54    Advantages of Star Schema
4:21    Disadvantages of Star Schema
4:54    Snowflake Schema
5:52    Common Uses of Snowflake Schema
6:54    Advantages of Snowflake Schema
7:24    Disadvantages of Snowflake Schema
Design Schemas
07:58

This lecture will talk about metadata and its components.

.

Lecture outline:

0:00    Definition of Meta Data
2:40    Components of Meta Data
Meta Data
03:19

This lecture will identify the difference between data webhouse and data warehouse queries.

Data Webhouse and Data Warehousing Queries
00:51

This lecture will discuss a process in database usage namely Extract, Transform, and Load or ETL.

.

Lecture outline:

0:00    ETL Defined
0:29    Extract
0:57    ETL Architecture Pattern
2:30    Transform
2:53    Transformation Types
4:15    Load
Extract, Transform, Load
06:55
+ Lifecycle and Rules of Data Warehouse
14 lectures 19:59

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 19: Data Warehouse Lifecycle

Lecture 20: Design

Lecture 21: Prototype

Lecture 22: Deploy

Lecture 23: Operate

Lecture 24: Enhance

Lecture 25: Data Warehouse Cycle of Cycles

Lecture 26: First Loop

Lecture 27: Second Loop

Lecture 28: Third Loop

Lecture 29: Fourth Loop

Lecture 30: Related Factors

Lecture 31: Rules of Data Warehouse

Introduction and Objectives
00:25

This lecture will talk about the data warehouse lifecycle and its major phases.

Data Warehouse Lifecycle
00:36

This discussion will focus on a major phase in the data warehouse lifecycle, namely the design phase.

Design
01:05

This discussion will focus on a major phase in the data warehouse lifecycle, namely the prototype phase.

Prototype
01:00

This discussion will focus on a major phase in the data warehouse lifecycle, namely the deploy phase.

Deploy
01:16

This discussion will focus on a major phase in the data warehouse lifecycle, namely the operate phase.

Operate
00:30

This discussion will focus on a major phase in the data warehouse lifecycle, namely the enhance phase.

Enhance
00:34

This discussion will center on another cycle that happens in the lifecycle, hence the data warehouse cycle of cycles.

Data Warehouse Cycle of Cycles
00:30

This lecture will identify the first loop involved in the cycle of cycles.

First Loop
00:38

This lecture will identify the second loop involved in the cycle of cycles.

Second Loop
00:59

This lecture will identify the third loop involved in the cycle of cycles.

Third Loop
01:46

This lecture will identify the fourth loop involved in the cycle of cycles.

Fourth Loop
00:28

This lecture will explain some related factors in the data warehouse lifecycle process.

Related Factors
03:21

This lecture will identify and explain the rules in the data warehouse.

.

Lecture outline:

0:00    Introduction to the Rules of Data Warehouse
0:47    Multi-Dimensional Conceptual View
1:15    Transparency
2:00    Accessibility
2:32    Consistent Reporting Performance
3:15    Client-Server Architecture
3:51    Generic Dimensionality
4:33    Dynamic Sparse Matrix Handling
4:55    Multi-User Support
5:16    Unrestricted Cross-Dimensional Operation
5:37    Intuitive Data Manipulation
5:58    Flexible Reporting
6:11    Unlimited Dimensions and Aggregation Levels
Rules of Data Warehouse
06:51
+ Data Warehouse Architecture and Flow
7 lectures 18:31

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 34: Introduction to Data Warehouse Architecture

Lecture 35: Key Components

Lecture 36: Benefits of Data Warehouse Architecture

Lecture 37: Typical Architecture of Data Warehousing

Lecture 38: Common Architecture

Lecture 39: Data Warehouse Information Flow

Introduction and Objectives
00:25

This lecture will explain the data warehouse architecture.

Introduction to Data Warehouse Architecture
00:41

This lecture will discuss the key components involved in the data warehouse architecture.

.

Lecture outline:

0:00    Introduction to the Key Components
        of Data Warehouse Architecture
0:10    Data Architecture
1:59    Infrastructure Architecture
3:15    Technical Architecture
Key Components
06:07

This lecture will identify the different benefits of the data warehouse architecture.

Benefits of Data Warehouse Architecture
01:18

This discussion will focus and explain the typical architecture of a data warehouse.

.

Lecture outline:

0:00    Typical Architecture of a Data Warehouse
0:07    Operational Data Sources
0:36    Operational Data Store
1:08    Load Manager
1:28    Warehouse Manager
2:33    Query Manager
2:59    Detailed Data
3:19    Lightly and Highly Summarized Data
3:56    Archive / Backup Data
4:18    MetaData
5:39    End-User Access Tools
Typical Architecture of Data Warehousing
06:32

This lecture will introduce and explain common architecture of data warehouses.

.

Lecture outline:

0:00    Common Architectures
0:25    Data Warehouse Architecture: Basic
1:19    Data Warehouse Architecture:
        With a Staging Area
1:59    Data Warehouse Architecture:
        With a Staging Area and Data Marts
Common Architecture
02:45

This discussion will center on the information flow in a data warehouse architecture.

Data Warehouse Information Flow
00:43
+ Data Warehouse Modeling
7 lectures 20:23

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 42: Importance of Data Modeling

Lecture 43: Introduction to Data Modeling Techniques

Lecture 44: Entity-Relationship Modeling

Lecture 45: Limitations of ER

Lecture 46: Dimensional Modeling

Lecture 47: Benefits of Dimensional Modeling

Introduction and Objectives
00:24

This lecture will identify the importance of data modeling.

Importance of Data Modeling
03:17

This lecture will introduce the different modeling techniques.

Introduction to Data Modeling Techniques
00:57

This lecture will explain one of the modeling techniques, namely entity-relationship modeling.

.

Lecture outline:

0:00    Definition of Entity-Relationship Modeling
0:32    Entity
2:15    Relationship
3:43    Attributes
5:37    Other Concepts
Entity-Relationship Modeling
07:22

This lecture will identify the limitations of entity-relationship modeling.

Limitations of ER
02:06

This lecture will explain one of the modeling techniques, namely dimensional modeling.

.

Lecture outline:

0:00    Definition of Dimensional Modeling
0:38    Basic Concepts of Dimensional Modeling
0:46    Fact
1:14    Measure
1:40    Dimension
2:48    Visualization
Dimensional Modeling
04:10

This lecture will identify the benefits of dimensional modeling.

Benefits of Dimensional Modeling
02:07
+ Data Warehouse Applications
11 lectures 31:53

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 50: Introduction to Data Warehouse Application

Lecture 51: Retail Industry

Lecture 52: Manufacturing and Distribution

Lecture 53: Bank

Lecture 54: Insurance Company

Lecture 55: Health Care Providers

Lecture 56: Government Agencies

Lecture 57: Internet Companies

Lecture 58: Telecommunications

Lecture 59: Sports

Introduction and Objectives
00:25

This lecture will introduce the different applications of data warehousing.

Introduction to Data Warehouse Application
02:40

This lecture will identify the different applications of data warehousing, specifically the retail industry.

Retail Industry
03:34

This lecture will identify the different applications of data warehousing, specifically manufacturing and distribution.

Manufacturing and Distribution
03:01

This lecture will identify the different applications of data warehousing, specifically the banking industry.

Bank
01:47

This lecture will identify the different applications of data warehousing, specifically the insurance companies.

Insurance Company
03:33

This lecture will identify the different applications of data warehousing, specifically health care providers.

Health Care Providers
05:15

This lecture will identify the different applications of data warehousing, specifically government agencies.

Government Agencies
03:15

This lecture will identify the different applications of data warehousing, specifically internet companies.

Internet Companies
03:27

This lecture will identify the different applications of data warehousing, specifically telecommunications.

Telecommunications
03:58

This lecture will identify the different applications of data warehousing, specifically the sports industry.

Sports
00:58
+ Challenges and Future of Data Warehouse
8 lectures 22:40

In this lecture, we'll discuss some objectives aimed at showing what you can expect to learn from this course.

Section Outline

Lecture 62: Challenges to Data Warehousing

Lecture 63: Ensuring Data Quality

Lecture 64: Ensuring Performance

Lecture 65: Testing the Data Warehouse

Lecture 66: Reconciliation of Data

Lecture 67: User Acceptance

Lecture 68: Future of Data Warehouse

Introduction and Objectives
00:25

This lecture will discuss some challenges in data warehousing.

Challenges to Data Warehousing
00:44

This lecture will identify a reason why data warehousing can become complex, namely ensuring data quality.

Ensuring Data Quality
02:39

This lecture will identify a reason why data warehousing can become complex, namely ensuring performance.

Ensuring Performance
03:05

This lecture will identify a reason why data warehousing can become complex, namely testing the data warehouse.

Testing the Data Warehouse
02:01

This lecture will identify a reason why data warehousing can become complex, namely reconciliation of data.

Reconciliation of Data
01:59

This lecture will identify a reason why data warehousing can become complex, namely user acceptance.

User Acceptance
01:14

This discussion will center on the future of data warehousing.

Future of Data Warehouse
10:33
+ Course Resources
1 lecture 00:00

This e book is a list of terms and definitions often used in the field of data warehousing.

Data Warehousing Glossary of Terms
3 pages
+ Data Warehousing Certification
3 lectures 01:27

Now that you've finished your Udemy course, - you are eligible to sit your official Certification exam.

Certification is not mandatory.

Once you've completed the course, email our exam department at exams@artofservice.com.au to purchase your exam voucher and sit your final exam.

. Access includes a step-by-step procedure on how to take the final exam and how to obtain your exam certification.

You will receive a PDF certificate through your email upon passing the examination.

Final Exam
1 page

We are always in the process of improving our courses and procedures for a better learning experience for our students. Your input is very important to us.

Follow the step-by-step procedure on taking the evaluation and receiving your certificate of completion.

Evaluation Form
1 page

A final message from our CEO.

Conclusion - Final Lecture
01:27
Requirements
  • Basic understanding of the IT industry
  • Knowledge of the English language
Description

Discover the latest data storage trend implemented by leading IT Professionals around the globe, known as Data Warehousing.

A data warehouse (DW) is a database used for reporting. The data is uploaded from the operational systems and may pass through an operational data store for additional processes before it is used in the data warehouse for reporting. This introductory course will discuss its benefits and concepts, the twelve rules which should be followed, the lifecycle of data that is warehoused, the flow and the architecture of data warehouse. It will also teach learners the applications of data warehousing, its challenges and its future.

Who this course is for:
  • Recent graduates looking to get a foothold in the IT Industry.
  • Finance professionals wanting to learn about Data Warehouses for reporting and analysis purposes, businesses looking to update and improve on data storage, analysis, and reporting processes.
  • IT professionals wanting to learn more about data storage, Data Warehousing modeling, or Data Warehousing applications.