Data Warehousing
3.2 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
527 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Warehousing to your Wishlist.

Add to Wishlist

Data Warehousing

An introductory course about understanding data warehousing, its architecture, flow, applications and modeling.
3.2 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
527 students enrolled
Last updated 7/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 min on-demand audio
  • 12 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
75 Lectures
07:12:52
+
Introduction to Data Warehousing
8 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

Section 1 - Quiz
6 questions

This PDF file contains Section 1 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 1
12 pages
+
OLTP, OLAP and Other Terminologies
9 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

Section 2 - Quiz
6 questions

This PDF file contains Section 2 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 2
20 pages
+
Lifecycle and Rules of Data Warehouse
15 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

Section 3 - Quiz
6 questions

This PDF file contains Section 3 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 3
10 pages
+
Data Warehouse Architecture and Flow
8 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

Section 4 - Quiz
6 questions

This PDF file contains Section 4 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 4
18 pages
+
Data Warehouse Modeling
8 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

Section 5 - Quiz
6 questions

This PDF file contains Section 5 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 5
12 pages
+
Data Warehouse Applications
12 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

Section 6 - Quiz
6 questions

This PDF file contains Section 6 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 6
18 pages
+
Challenges and Future of Data Warehouse
9 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

Section 7 - Quiz
6 questions

This PDF file contains Section 7 of this course. You can download the complete e book at the end of this course.

Reading Assignment Section 7
14 pages
+
Course Resources
3 Lectures 00:00

This e book contains the entire Data Warehousing course in a PDF format.

Data Warehousing Complete Certification Kit Book
148 pages

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

This PDF file contains all the answers to all the quizzes in each section of this course.

Quiz Answer Sheet
7 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
About the Instructor
The Art Of Service
3.8 Average rating
554 Reviews
5,573 Students
57 Courses
Quality education for Career Driven IT Professionals

What drives us?

In one word? YOU

You are front, center and behind every decision we make in our business.

  • You are starting out in the IT industry
  • You are serious about your career
  • You need certifications on your resume to get that first interview

For you we created the Foundation level courses as well as the Core Series for IT

  • You are an IT Professional with a proven career
  • You need to stay in touch with changes in the industry
  • You need to continue to show your value to the business to ensure your job is secure
  • You want to find out what else would make your IT career more solid

For you we created the Specialist and Intermediate level courses as well as the Core Series for IT

  • You are implementing Processes and methodologies in your company
  • You are managing a team of people and need to look good
  • You started your own business and are looking for template documents to ‘hit the ground running’
  • You need to present on a subject at the next team meeting and are not quite sure where to start

For you we created the Toolkits as well as the Core Series for IT


Our motto:
Every Career driven IT Professional needs to be able to afford quality IT educational materials to stay relevant in their job, irrespective of current position, budget or geographical location.

We do most of the work behind the scenes so that you can focus on your professional education and your career within the IT industry.

We see it as our job to ensure we give you the most up to date information you need to succeed in achieving that goal at a price-point that is makes it accessible to most professionals.