Enterprise Data Warehouse Tutorial - Business Intelligence
4.1 (10 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.
57 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.1 (10 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.
57 students enrolled
Created by Yoda Learning
Last updated 8/2017
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 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
  • This course covers all levels. So user don't need any prior knowledge on this topic.

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
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.
Understanding Enterprise Data Warehouse & Its Relevance
4 Lectures 15:14

What is a Data Warehouse?

Characteristics of a Data Warehouse
Understanding Business Intelligence
3 Lectures 08:52
What is Business Intelligence?

Uses of Business Intelligence

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

Advantages of a Traditional Warehouse

Limitations of Traditional Data Warehouses
Understanding Data Mart in Enterprise Data Warehouse
6 Lectures 13:01
What is a Data Mart?

Fundamental Difference between DWH and DM

Advantages of a Data Mart

Charecteristics of a Data Mart

Disdavantages of a Data Mart

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

Benefits of Dimensional Modelling

What is a Dimension?

0504 What is a Fact?

Additive Facts

Semi Additive Facts

Non-Additive Facts

FactLess Facts

What is a Surrogate key?

Star Schema

SnowFlake Schema

Galaxy Schema or Fact Constellation Schema

Differences between Star Schema and SnowFlake Schema?

Conformed Dimension

Junk Dimension

Degenerate Dimension

Slowly Changing Dimensions - Intro and Example Creation

Slowly Changing Dimensions - Type 1, 2 and 3

Slowly Changing Dimensions - Summary

Project: Set up the Dimensional Model using a Financial Services Case Study
About the Instructor
Yoda Learning
4.4 Average rating
1,589 Reviews
36,983 Students
50 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).