earning Objectives: In this module, you will understand the various concepts of Data Warehousing.
You will learn why we perform ETL operations before loading data to the Data warehouse.
You will get a brief introduction to Business Intelligence.
Topics:
Fundamental concepts of Data Warehousing
Concepts of Dimensions, Measures, Metadata, Schemas
Data Marts and Design approaches
Normalization and Denormalization and Schema types
Online Analytical Processing and Transactional Processing concepts
OLAP Cube
Types of Slowly Changing Dimensions
Explain ETL process and various tasks involved in it
Discuss Business Intelligence concepts .
How BI works with data-warehouse ?
MSBI as One stop Solution
Hands On/Demo:
Install SQL Server
Install SQL Server Data Tools
Create small ETL
Tasks
Skills:
Understand Data Warehousing Concepts
Understand ETL
You will never miss a lecture with us ! You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.
You will never miss a lecture with us ! You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.
