|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/msbi-and-ssis-fundamentals-to-advanced-data-integration/
课程评论：没有评论
课程名称：MSBI与SSIS：从基础到高级数据集成 课程概述： 欢迎参加本全面的课程，专注于Microsoft商务智能（MSBI）和SQL Server集成服务（SSIS）。该课程旨在帮助学习者掌握有效管理和转换数据所需的知识和技能，无论是初学者还是希望深入理解SSIS的学习者，课程涵盖了广泛的主题，以助您精通这些强大的工具。 第一部分：学习MSBI与SSIS 在本节中，学生将了解到Microsoft商务智能（MSBI）与SQL Server集成服务（SSIS）。课程将介绍SSIS的重要性，特别是在数据集成和工作流自动化中的应用。学生将学习如何打开SSIS和SQL Server管理工作室（SSMS），并理解连接管理器的重要性，这对于建立数据源连接至关重要。 接下来，课程将深入实践任务，从数据流任务开始，这是SSIS进行数据转换的核心组件。将涵盖基本的SQL任务，随后涉及更高级的主题，如执行SQL任务。学生还将探索多种SSIS转换功能，如多播、条件分割、数据转换、派生列、查找转换、排序、合并和合并连接。到本节结束时，学生将对如何使用SSIS进行数据转换有扎实的理解，并具备处理复杂数据集成场景的能力。最后，我们将深入了解行计数和脚本组件任务。 第二部分：SSIS - SQL Server集成服务 在第一部分奠定的基础上，本节将深入探讨SSIS。学生将探索SSIS的更多高级功能，首先是对SSIS及其组件的详细概述。课程将演示聚合数据转化的支持，包括计数和计数唯一值。 内容将涵盖数据库到数据库的转换，以及如何将数据从数据库输入到文本文件。学生将有效学习使用GroupBy、MaxMin和Sum函数。课程还将详细解释审计数据流、复制列、数据转换和派生列等关键任务。 我们将特别关注各种数据传输技术，包括从Excel到数据库、OLEDB到Excel以及条件分割。课程也将涉及SSIS组件的使用，如合并、合并连接、多播、排序、全部联合以及使用不同可视格式（列型、网格型、直方图和散点图）的数据查看器。 高级转换如模糊分组、模糊查找、查找转换、百分比抽样、透视、行抽样、术语提取、术语查找和逆透视等内容将被深入探讨。此外，还将涵盖执行SQL任务、文件系统任务和Foreach循环容器的实际应用。 到本节末，学生将对SSIS及其高级功能有全面的理解，使他们能够高效实施复杂的数据集成和转换任务。 课程总结： 课程通过加强两部分所获得的知识和技能进行总结。学生将能够自信地运用MSBI和SSIS进行各种数据集成和转换任务，从基本的SQL任务到高级的数据处理和转换技术。这对SSIS的全面理解将使学生有效应对实际数据集成挑战，使其在MSBI和SSIS方面更加熟练。
Welcome to the comprehensive course on Microsoft Business Intelligence (MSBI) and SQL Server Integration Services (SSIS)! This course is designed to equip you with the knowledge and skills necessary to effectively manage and transform data using MSBI and SSIS. Whether you're a beginner or looking to deepen your understanding of SSIS, this course covers a broad range of topics to help you master these powerful tools.Section 1: Learn MSBI and SSISIn this section, students will be introduced to Microsoft Business Intelligence (MSBI) and SQL Server Integration Services (SSIS). The section begins with an overview of SSIS, explaining its importance in data integration and workflow automation. Students will learn how to open SSIS and SQL Server Management Studio (SSMS), and gain an understanding of Connection Managers which are essential for establishing connections to data sources.The course then dives into practical tasks starting with the Data Flow Task, which is the core component of SSIS for data transformation. Basic SQL tasks will be covered, followed by more advanced topics such as the Execute SQL Task. Students will also explore various SSIS transformations like Multicast, Conditional Split, Data Conversion, Derived Column, Lookup Transformation, Sort, Merge, and Merge Join.By the end of this section, students will have a solid understanding of how to perform data transformations using SSIS, and will be equipped with the skills to handle complex data integration scenarios. The section concludes with an in-depth look at the Row Count and Script Component tasks.Section 2: SSIS - SQL Server Integration ServicesBuilding on the foundation laid in the first section, this section delves deeper into SSIS. Students will explore more advanced features and capabilities of SSIS, starting with a detailed overview of SSIS and its components. The use of aggregate data transformation support, including Count and CountDistinct, will be demonstrated.The course covers database-to-database transformations and how to input data from a database to a text file. Students will learn to use the GroupBy, MaxMin, and Sum functions effectively. Other critical tasks such as auditing data flows, copying columns, data conversion, and derived columns will be explained in detail.Special attention is given to various data transfer techniques, including Excel to database, OLEDB to Excel, and conditional splits. The section also covers the use of SSIS components like Merge, Merge Join, Multicast, Sort, Union All, and Data Viewers using different visual formats (Column, Grid, Histogram, and Scatter).Advanced transformations such as Fuzzy Grouping, Fuzzy Lookup, Lookup Transformation, Percentage Sampling, Pivot, Row Sampling, Term Extraction, Term Lookup, and Unpivot are thoroughly explored. The practical applications of Execute SQL Tasks, File System Tasks, and Foreach Loop containers are also covered.By the end of this section, students will have a comprehensive understanding of SSIS and its advanced features, enabling them to implement complex data integration and transformation tasks efficiently.ConclusionThe course concludes by reinforcing the knowledge and skills acquired in both sections. Students will be confident in using MSBI and SSIS for various data integration and transformation tasks, ranging from basic SQL tasks to advanced data manipulation and transformation techniques. This comprehensive understanding of SSIS will empower students to handle real-world data integration challenges effectively, making them proficient in MSBI and SSIS.
