Enterprise Data Warehouse Tutorial - Business Intelligence
4.3 (6 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.
33 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Enterprise Data Warehouse Tutorial - Business Intelligence to your Wishlist.

Add to Wishlist

Enterprise Data Warehouse Tutorial - Business Intelligence

Learn the concepts of Enterprise Data Warehouse (EDW), Architecture, Data mart, Dimensional modeling.
4.3 (6 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.
33 students enrolled
Created by Yoda Learning
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Course lays a solid foundation on Data Warehousing introduction, BI context, Data warehouse architecture and Data mart concepts
  • Course also focuses on Dimensional modeling (Facts, Dimensions, Keys, Schema)
View Curriculum
Requirements
  • This course covers all levels. So user don't need any prior knowledge on this topic.
Description

The demand for experts of Business Intelligence (BI), Machine Learning and Big Data, have risen significantly in the last five years. In this context, there are two job roles, whose importance have grown too:

Data Warehouse Architect
Data Warehouse Consultant

Data warehouse architects (DWA) construct information systems that make a company’s data easily available for analysis. After examining a company’s possible data sources (internal and external), DWA design a plan to integrate, centralize, protect and maintain them. This allows analysts and BI specialists to access critical information in the right place, at the right time. This analysis is critical for timely decisions. In short, Data architects do notanalyze data. Instead, they make it available to others.

Several Business Intelligence tools help answer these questions by providing data driven insights. The warehouse adds its value behind the scenes. Its job is to provide data to the high-profile BI tools and applications with which users interact.

Professionals often start as a Database Administrator (DBAs) and or entry-level programmers. With experience, they gain more understanding how data is stored.

Who is the target audience?
  • You have started your career as a Database Administrator (DBAs) or an entry-level programmers
  • You wish to become an Enterprise Data Warehouse Architect / Consultant
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
02:04:43
+
Download Important Support files for Learning Enterprise Data Warehouse
1 Lecture 00:06
Here are some of the important link to download you need for practice.
00:06
+
Understanding Enterprise Data Warehouse & Its Relevance
4 Lectures 15:14


What is a Data Warehouse?
03:41

Characteristics of a Data Warehouse
04:58
+
Understanding Business Intelligence
3 Lectures 08:52
What is Business Intelligence?
02:03

Uses of Business Intelligence
03:41

Tools used for (in) Business Intelligence
03:08
+
Understanding Data Warehouse with Advantages and Limitations
3 Lectures 11:58

Advantages of a Traditional Warehouse
02:58

Limitations of Traditional Data Warehouses
05:21
+
Understanding Data Mart in Enterprise Data Warehouse
6 Lectures 13:01
What is a Data Mart?
02:15

Fundamental Difference between DWH and DM
02:41

Advantages of a Data Mart
01:52

Charecteristics of a Data Mart
02:04

Disdavantages of a Data Mart
02:05

Mistakes and MisConceptions of a Data Mart
02:04
+
Understanding Dimension Model in Enterprise Data Warehouse
20 Lectures 01:15:36
What is Dimension Modelling?
03:16

Benefits of Dimensional Modelling
01:49

What is a Dimension?
04:51

0504 What is a Fact?
03:09

Additive Facts
02:19

Semi Additive Facts
02:39

Non-Additive Facts
03:02

FactLess Facts
02:50

What is a Surrogate key?
03:44

Star Schema
03:40

SnowFlake Schema
02:41

Galaxy Schema or Fact Constellation Schema
01:52

Differences between Star Schema and SnowFlake Schema?
04:12

Conformed Dimension
03:08

Junk Dimension
01:55

Degenerate Dimension
02:39

Slowly Changing Dimensions - Intro and Example Creation
03:42

Slowly Changing Dimensions - Type 1, 2 and 3
06:07

Slowly Changing Dimensions - Summary
03:41

Project: Set up the Dimensional Model using a Financial Services Case Study
14:20
About the Instructor
Yoda Learning
4.3 Average rating
1,479 Reviews
35,496 Students
49 Courses
MS OFFICE & PMP | Join 32K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).