Learning 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

Learning Objectives: In this module, you will understand the need for an Integration tool and its significance in the industry. You will learn the importance of SSIS as an integration tool and get a high-level view of the overall architecture.

Topics:
Understand the MSBI Architecture, Import and Export wizard
Understand SSIS Architecture
Control Flow & its Components (Tasks, Containers, Precedence Constraints)
Data Flow & its Components (Source and Destination Connections, different types of Transformations)
Scenarios by combining Control Flow and Data Flow components
System Variables and User-defined variables

Hands On/Demo:
Create tasks and Control Flow task using SSIS
Create a data flow task to aggregate the records
Create a control flow task to create an index and run the tasks

Skills:
Understand SSIS Concepts
Understand Control flow and Dataflow

Learning Objectives: In this module, you will understand the need for an Integration tool and its significance in the industry. You will learn the importance of SSIS as an integration tool and get a high-level view of the overall architecture.

Topics:
Understand the MSBI Architecture, Import and Export wizard
Understand SSIS Architecture
Control Flow & its Components (Tasks, Containers, Precedence Constraints)
Data Flow & its Components (Source and Destination Connections, different types of Transformations)
Scenarios by combining Control Flow and Data Flow components
System Variables and User-defined variables

Hands On/Demo:
Create tasks and Control Flow task using SSIS
Create a data flow task to aggregate the records
Create a control flow task to create an index and run the tasks

Skills:
Understand SSIS Concepts
Understand Control flow and Dataflow

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.

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

All the instructors are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.

We certifies you as Data Visualization expert based on your project performance, reviewed by our expert panel.