Learn Data Warehousing From Scratch- From Solution Architect

About Learn Data Warehousing From Scratch- From Solution Architect

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!