Data Warehousing

An introductory course about understanding data warehousing, its architecture, flow, applications and modeling.
2.6 (15 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.
436 students enrolled
$50
Take This Course
  • Lectures 75
  • Contents Video: 3 hours
    Other: 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course 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.

What are the requirements?

  • Basic understanding of the IT industry
  • Knowledge of the English language

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Data Warehousing
00:30

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

04:11

This lecture will explain the definitions of data warehousing.

04:47

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

02:23

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
03:08

This lecture will identify the different disadvantages of data warehousing.

02:11

This lecture will identify the different benefits of data warehousing.

04:10

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
Section 1 - Quiz
6 questions
12 pages

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

Section 2: OLTP, OLAP and Other Terminologies
00:37

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

08:42

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
00:53

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

03:24

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
07:58

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
03:19

This lecture will talk about metadata and its components.

.

Lecture outline:

0:00    Definition of Meta Data
2:40    Components of Meta Data
00:51

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

06:55

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
Section 2 - Quiz
6 questions
20 pages

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

Section 3: Lifecycle and Rules of Data Warehouse
00:25

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

00:36

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

01:05

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

01:00

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

01:16

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

00:30

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

00:34

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

00:30

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

00:38

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

00:59

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

01:46

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

00:28

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

03:21

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

06:51

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
Section 3 - Quiz
6 questions
10 pages

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

Section 4: Data Warehouse Architecture and Flow
00:25

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

00:41

This lecture will explain the data warehouse architecture.

06:07

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
01:18

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

06:32

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
02:45

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
00:43

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

Section 4 - Quiz
6 questions
18 pages

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

Section 5: Data Warehouse Modeling
00:24

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

03:17

This lecture will identify the importance of data modeling.

00:57

This lecture will introduce the different modeling techniques.

07:22

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
02:06

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

04:10

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
02:07

This lecture will identify the benefits of dimensional modeling.

Section 5 - Quiz
6 questions
12 pages

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

Section 6: Data Warehouse Applications
00:25

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

02:40

This lecture will introduce the different applications of data warehousing.

03:34

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

03:01

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

01:47

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

03:33

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

05:15

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

03:15

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

03:27

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

03:58

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

00:58

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

Section 6 - Quiz
6 questions
18 pages

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

Section 7: Challenges and Future of Data Warehouse
00:25

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

00:44

This lecture will discuss some challenges in data warehousing.

02:39

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

03:05

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

02:01

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

01:59

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

01:14

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

10:33

This discussion will center on the future of data warehousing.

Section 7 - Quiz
6 questions
14 pages

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

Section 8: Course Resources
148 pages

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

3 pages

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

7 pages

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

Section 9: Data Warehousing Certification
1 page

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.

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.

01:27

A final message from our CEO.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The Art Of Service, 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.

Ready to start learning?
Take This Course