Learn Data Warehousing from Scratch- From Solution Architect

A comprehensive Data warehouse guide from the industry expert. Succeed in BI|DataWarehouse|Data Model|BIGDATA.

  Enroll in Course

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!


Your Instructor(s)


Mohammad Asif Raza
Mohammad Asif Raza

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!


Course Curriculum


  Data Warehouse Appliances
Available in days
days after you enroll
  BIG DATA
Available in days
days after you enroll
  NOSQL
Available in days
days after you enroll
  Quiz
Available in days
days after you enroll
  Reference Materials - Goto Links/Steps
Available in days
days after you enroll
  Case Study - Using Oracle DB
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.