|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/design-and-implement-a-data-warehouse-ssis-ssas-ssrs/
课程评论：没有评论
课程名称：设计与实施数据仓库：SSIS SSAS SSRS 课程概述： 本课程旨在教授数据仓库（DW）的设计与实施，该过程涉及从多种来源收集和管理数据，以提供有意义的商业洞察。数据仓库主要用于连接和分析异构源的商业数据，是商务智能（BI）系统的核心，旨在支持数据分析和报表生成。数据仓库结合了多种技术和组件，帮助战略性地利用数据，以电子方式存储大量信息，主要用于查询和分析，而不是事务处理。课程将介绍如何将数据转化为信息，并及时向用户提供，以便做出有效决策。 在本课程中，您将学习到使用Microsoft SQL Server集成服务（SSIS）构建高性能数据集成解决方案的技术，内容包括数据提取、转换和加载（ETL）包的制作。SSIS提供图形化工具和向导来构建和调试这些包，支持如FTP操作、执行SQL语句和发送电子邮件的工作流功能，以及用于提取和加载数据的数据源和目的地。此外，课程还将涵盖SSISDB管理数据库的使用，以管理包的执行和存储。 SQL Server报表服务（SSRS）也是课程的重点之一，它是一种报表软件，能够生成包含表格、图形、图像和图表的格式化报表。这些报表托管在服务器上，可根据用户定义的参数随时执行。 分析服务（SSAS）是一个用于决策支持和商业分析的分析数据引擎。它为商务报表和客户端应用（如Power BI、Excel、Reporting Services报表等）提供企业级的语义数据模型以及其他数据可视化工具。 本课程适合希望深入理解数据仓库构建及其在商业智能应用中的重要性的人士。通过学习，您将获得在实际工作中灵活运用这些技术的能力。
A Data Warehousing (DW) is process for collecting and managing data from varied sources to provide meaningful business insights. A Data warehouse is typically used to connect and analyze business data from heterogeneous sources. The data warehouse is the core of the BI system which is built for data analysis and reporting.It is a blend of technologies and components which aids the strategic use of data. It is electronic storage of a large amount of information by a business which is designed for query and analysis instead of transaction processing. It is a process of transforming data into information and making it available to users in a timely manner to make a difference.MicrosoftSQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. SSIS includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management database, SSISDB, for administering package execution and storage; and application programming interfaces (APIs) for programming the Integration Services object model.SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services suite.Analysis Services is an analytical data engine (VertiPaq) used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools
