Microsoft BI - SQL Server Integration Service (SSIS) Course

Name: Microsoft BI - SQL Server Integration Service (SSIS) Course
Rating: 1.0 (1 reviews)

Course Covers SSIS from Basics to Advanced Levels

Created byAmit Kumar

Last updated 11/2021

English

What you'll learn

MSBI - Microsoft Business Intelligence
SSIS - SQL Server Integration Services
Building data warehouse
Building dimensional data model

Course content

1 section • 12 lectures • 8h 40m total length

Introduction to Ms-BI and Building Data Warehouse51:50
Learn to design a data warehouse and data mart using SSIS and Microsoft BI. Integrate multiple data sources, define dimensions and facts, and enable reporting and dashboards.
Understanding Data flow task, OLE DB source and Merge Join43:22
Explore data flow task, ole db source, and merge join in SSIS to pull data from customer and order tables and build a unified data warehouse.
Understanding Derived Column Transformation and OLE DB Destination36:25
Understand derived column transformation in SSIS to create new fields from source data, join address columns into a single column, and load the result to an OLE DB destination.
Transferring data from multiple source to SQL Destination1:00:46
Learn to transfer data from multiple sources into a sql destination, transform the data, and handle data mapping, type conversion, and excel-to-sql challenges.
Understanding Union All and Data Conversion Transformation42:41
Explore union all and data conversion transformation in ssis, mastering how to merge sources, map columns, and convert unicode to non-unicode strings for reliable data integration.
Aggregate Transformation12:11
Explore the aggregate transformation in ssis to analyze distinct us orders and associated customers, focusing on counting orders, identifying unique customers, and summarizing data.
Conditional Split Transformation35:46
Learn to configure conditional split in SSIS to direct data from a single source to multiple tables based on conditional logic, using variables, conditions, and lookups.
Union All Transformation39:08
Learn how the union all transformation in ssis combines multiple data sources, maps and transforms columns, and prevents duplicate loading into the destination.
OLEDB Command Transformation1:02:42
Learn to use the OLE DB Command Transformation in SSIS to update and conditionally insert data from sources like Excel and customer tables, with audit and destination mappings.
Row count and Script Component Transformation54:35
Explore row count handling and script component transformations in SSIS, building a data flow with input and output columns and applying dotnet scripted transformations.
Multi Cast Transformation32:00
Learn how the multicast transformation in SSIS duplicates data across multiple outputs and destinations, configure conditions, mapping, Excel connections, and distinguish multicast from related operators.
Slowly Changing Dimension Transformation48:45
Discover how the slowly changing dimension transformation in SSIS handles incremental loading, historical attribute tracking, and new versus updated customer records using a customer master example.

Requirements

SQL Basics would be the ideal

Description

This course covers SSIS from Basics to Advanced Levels

SSIS - SQL Server Integration Services

SSIS:

SSIS makes it easy to create robust and complex solutions for extracting, Transforming and Loading the data.

These will help you to design, create, deploy and manage packages that address everyday business requirements.

SSIS can be used for data migration as well as data integration purpose.

Sections in SSIS Designer:

Control Flow:

Work flow of task execution / order of tasks execution.

Controlling the flow of SSIS package execution.

Data Flow: ETL

It contains extracting the data from one more sources with the help of source adapters, performing transformations and loading the data into one more destinations with the help of destination adapters.

Event Handlers:

It allows you to implement error handling and debugging of control flow tasks in SSIS packages.

Package Explorer:

It allows you to browse the package contents. Package contains tasks, precedence constraints, log providers, variables, event handlers and connection managers.

Parameters:

Parameters are the replacement for configurations that are in the current version of SSIS. It allows you to assign values to properties within packages at the time of package execution.

Connection Manager:

It maintains all connections used by the different tasks and adapters in the package.

A connection manager is a logical representation of a connection

Who this course is for:

Programmers
Business Analyst
BI professional
Students