Learn Data Warehousing From Scratch- From Solution Architect
3.8 (239 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.
1,984 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Data Warehousing From Scratch- From Solution Architect to your Wishlist.

Add to Wishlist

Learn Data Warehousing From Scratch- From Solution Architect

A comprehensive Data warehouse guide from the industry expert. Succeed in BI|DataWarehouse|Data Model|BIGDATA.
3.8 (239 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.
1,984 students enrolled
Created by Asif Raza
Last updated 10/2016
English
Current price: $10 Original price: $35 Discount: 71% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Design and Build Data Warehouse
  • In depth understanding of DW Architecture
  • What is DWA
  • How can you transition yourself to BIGDATA
View Curriculum
Requirements
  • Familiar with the basic concept of Database/RDBMS.
Description

***25-OCT-2016***

Added Hadoop Distributions Comparison sheet to let you choose the right Hadoop distribution based on several Parameters.

*****

Do you want to master in Data warehousing, keen to become an expert ? Me being worked on several Data Warehousing implementation projects in last 12 years here in UK. I will give you the grain of what's needed to implement a successful Data Warehouse project.

We've heard it all, big data and the intelligence to understand these chunks of data. Most persons have to start from scratch or meet mid-way to become an expert in business Intelligence domain.

Course is meant for someone who wants to understand fundamentals of DW and various architectural pieces around it and eventually become a part of big data revolution.

This course is built to get you the grain of the subject and give you what is essential for newbie to eventually become an expert at the end of the course. Come and Join the journey!!

Course Highlights Introduction

  • Business Challenge?
  • Need for Business Intelligence
  • Define Data warehouse
  • Industry UsingData warehousing
  • Typical BI environment

Data Warehousing Concepts

  • OLTP ,OLAP
  • ODS, Data Marts
  • ETL
  • Facts, Dimensions, SCD
  • Surrogate Keys, Factless-Fact

Two Major school of thoughts

  • Are they at war ?
  • Understand myth
  • Case Studies
  • Ralph Kimball
    • How to design
    • Start Schema, Snow Flake
    • Bus Architecture
    • Sample Data Models
  • Bill Inmon
    • How to design
    • 3rd Normal Form
    • CIF Architecture
    • Sample Data Models

Data Warehouse Appliances

  • Teradata
  • Netezza
  • Exadata

Big Data

  • What's the Buzz word
  • What are 4 V's
  • Understand Big Data in BI terms
  • Major Player
  • What is Hadoop
  • Hadoop in DW world
  • Example - Architecture

NoSQl

  • What it is
  • SQL VS NoSQL
  • Types of NoSQL DB's
  • Major BI Vendors

Wish you all the very best!

Who is the target audience?
  • Anyone who wants to get into data world can be benefited from this course.
  • Marketers
  • Startup folks
  • Aspiring Data Analysts
  • DataBase Developers
  • Recent College Grads
  • Job-seekers
  • BI folks
Students Who Viewed This Course Also Viewed
Curriculum For This Course
33 Lectures
02:02:04
+
Introduction
5 Lectures 07:11

Business Challenge
01:26

History Of DW
00:49

What Is Business Intelligence
02:12

BI Bit More
01:23
+
Data WareHouse Basics
7 Lectures 29:40
DW Definition
03:11


Staging Area & ODS
03:26


ETL
06:18

DW Key Concepts - Quick Recap
02:27

Typical BI Environment
04:54
+
Data Warehouse Architecture
8 Lectures 31:31
Data Warehouse Methods
02:56

Ralph Kimball Method
02:54

Bill Inmon Method
04:33

Dimensional Modeling - Design Process
02:03

Dimensional Modeling - Fact Tables
02:40

Dimensional Modeling - Dimension Table
01:36

Similarities between Kimball And Bill Inmon
06:39

Slowly Changing Dimension
08:10
+
Case Study
7 Lectures 23:30
Case Study
01:37

Case Study - Solution
06:27

Star Schema
02:37

SnowflaKe Schema
02:12

BUS Architecture
01:31

Schema Extension - Future Maintenance
02:31

Bill Inmon Method
06:35
+
Data Warehouse Appliances
1 Lecture 05:33
Data Warehouse Appliances - Netezza/Teradata/Exadata
05:33
+
BIG DATA
2 Lectures 14:33
BIG DATA
04:41

Since many of you've been asking me about which vendor to choose etc.. have prepared a Vendor parameter comparison sheet for your better understanding. Hope this gives bit more clarity.

Data Warehousing And Hadoop
09:52
+
NOSQL
2 Lectures 09:58
NOSQL in Nutshell
06:42

BI Vendors
03:16
+
Quiz
0 Lectures 00:00
Test your data warehousing skills
10 questions
+
Reference Materials - Goto Links/Steps
1 Lecture 00:08
Data Warehouse Reference Materials
00:08
About the Instructor
Asif Raza
3.8 Average rating
238 Reviews
1,984 Students
1 Course
DW/BI Solution Architect

I am Solution Architect with over 12 years of experience in IT industry specializing in BI and DWH domain including several greenfield projects implementation. I'm a passionate and experienced Solution architect and here to help you get going.

Determination and focus has landed me to heights with pretty neat people. I strongly believe knowledge increases by sharing. Hence, I have invested my knowledge and expertise to build up this training course for the wider community. People undergoing my training always have a delightful learning experience. I hope you make the most of this course.

Good Luck!