Data Warehouse Concepts: Basic to Advanced concepts

Offered byUDEMY

Data Warehouse Concepts: Basic to Advanced concepts
at
UDEMY
Overview

Learn the BI/Data Warehouse/BIG DATA Concepts from scratch and become an expert.

Duration	7 hours
Total fee	₹490
Mode of learning	Online
Difficulty level	Advanced
Credential	Certificate

Data Warehouse Concepts: Basic to Advanced concepts
at
UDEMY
Highlights

3 downloadable resources
Full lifetime access

Data Warehouse Concepts: Basic to Advanced concepts
at
UDEMY
Course details

Skills you will learn

Data Modeling OLAP Data Warehousing Big Data

Who should do this course?

This Course is intended for freshers who are new to the Data Warehouse world, Application/ETL developers, Mainframe develoeprs, database administrators, system administrators, and database application developers who design, maintain, and use data warehouses.
Finance professionals wanting to learn about Data Warehouses for reporting and analysis purposes, businesses looking to update and improve on data storage, analysis, and reporting processes.

What are the course deliverables?

Learning all the concepts and terminologies related to the Datawarehouse , such as the OLTP, OLAP, Dimensions, Facts, Start Schema, Snow flake Schema etc
It also explains how the data is managed with in the Data Warehouse and explains the process of reading and writing data onto the Warehouse.
Later in the course you would also learn the basics of Data Modelling and how to start with it logically and physically.

More about this course

In this course, you will learn all the concepts and terminologies related to the Data Warehouse , such as the OLTP, OLAP, Dimensions, Facts and much more, along with other concepts related to it such as what is meant by Start Schema, Snow flake Schema, other options available and their differences. It also explains how the data is managed with in the Data Warehouse and explains the process of reading and writing data onto the Warehouse. Later in the course you would also learn the basics of Data Modelling and how to start with it logically and physically. You would also learn all the concepts related to Facts, Dimensions, Aggregations and commonly used techniques of ETL. Upon completion of this course, you would have a clear idea about, all the concepts related to the Data Warehouse, that should be sufficient to help you start off with the next step of becoming an ETL developer or Administering the Data warehouse environment with the help of various tools.

Data Warehouse Concepts: Basic to Advanced concepts
at
UDEMY
Curriculum

Introduction

Brief about the Data warehouse

Is Data warehouse still relevant in the age of Big Data?

Why do we need a Data Warehouse?

What is a Data Warehouse?

Characteristics of a Data Warehouse

Business Intelligence

What is Business Intelligence?

Business Intelligence -Extended Explanation

Uses of Business Intelligence

Tools used for (in) Business Intelligence

Data Warehouse Architectures

Federated Architecture

Multi-Tired Architecture

Components of a Data Warehouse

Purpose of a Staging Area in Data Warehouse Architecture - Part 1

Purpose of a Staging Area in Data Warehouse Architecture - Part 2

Advantages of Traditional warehouse

Limitations of Traditional Data Warehouses

ODS- Operational Data Store

What is ODS?

Define ODS

Staging Vs ODS

Differences between ODS,DWH, OLTP, OLAP, DSS

OLAP

OLAP Overview

OLTP Vs OLAP - Part 1_U

OLTP Vs OLAP - Part 2

OLAP Architecture - MOLAP

ROLAP

HOLAP

DOLAP

Data Warehouse Concepts: Basic to Advanced concepts
at
UDEMY
Faculty details

Sid Inf

Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.