MSBI and SSIS: Fundamentals to Advanced Data Integration
Deal Score0
What you’ll learn
-
Fundamentals of SSIS: Get started with the basics of SSIS, understanding its importance in data integration and workflow automation.
-
Learn how to navigate the SSIS interface and set up your workspace.
-
Connection Managers: Learn how to establish and manage connections to various data sources, a critical step in data integration processes.
-
Data Flow Tasks: Dive into the core of SSIS with data flow tasks. Understand how to perform data transformations, handle data flows, and implement complex data
-
SQL Tasks: Explore both basic and advanced SQL tasks, enhancing your ability to execute SQL commands within SSIS packages.
-
SSIS Transformations: Gain in-depth knowledge of SSIS transformations such as Multicast, Conditional Split, Data Conversion, Derived Column etc
-
Advanced SSIS Features: Delve into advanced SSIS features and capabilities, including aggregate data transformations, database-to-database transformations
-
Data Transfer Techniques: Master various data transfer techniques, including transferring data between Excel and databases, using OLEDB, and implementing
-
SSIS Components: Learn to use essential SSIS components like Merge, Merge Join, Multicast, Sort, Union All, and Data Viewers in different visual formats.
-
Advanced Transformations: Explore advanced data transformations such as Fuzzy Grouping, Fuzzy Lookup, Percentage Sampling, Pivot, Row Sampling, Term Extraction
-
Practical Applications: Understand the practical applications of Execute SQL Tasks, File System Tasks, and Foreach Loop containers to handle data integration
