|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learnmsbi/
课程评论：没有评论
课程名称：逐步学习MSBI（SSIS、SSAS、SSRS） 概述：本课程涵盖从基础到高级水平的SSIS、SSRS和SSAS，包括： 1. **SSIS（SQL Server集成服务）**：SSIS便于创建强大且复杂的数据提取、转换和加载（ETL）解决方案。它可帮助设计、创建、部署和管理满足日常业务需求的数据包。SSIS可用于数据迁移和数据集成。SSIS设计器中的主要部分包括： - 控制流：任务执行的工作流程和顺序控制。 - 数据流：从一个或多个来源提取数据、执行转换并将数据加载到一个或多个目标的过程。 - 事件处理程序：实现控制流任务的错误处理和调试。 - 包浏览器：用于查看包的内容，包括任务、约束、日志提供程序、变量、事件处理程序和连接管理器。 - 参数：替代SSIS当前版本中的配置，允许在包执行时为属性赋值。 - 连接管理器：管理每个任务和适配器所用的所有连接。 2. **SSRS（SQL Server报告服务）**：SSRS是一个报告平台，用于从任何数据源生成报告，支持多种报告类型，包括： - 企业报告：遵循完整的业务标准和规则，供企业用户共享。 - 议题报告：不遵循业务标准，由非技术业务经理准备，不在企业中共享。 - 嵌入报告：将报告嵌入到Java、.Net等第三方应用中。 数据源包括普通数据源（特定报告中的连接字符串，不可重用）和共享数据源（可在多个报告中重用）。 3. **SSAS（SQL Server分析服务）**：SSAS是一个多维OLAP服务器和分析引擎，允许对大量数据进行分析。SSAS包括具有预聚合数据的分析数据库，并支持多维和表格两种变体，可以在分析数据库中展示多个数据立方体。 本课程旨在为学员提供全面的MSBI技能，从基础到高级，确保能够独立设计和实施数据集成与业务智能解决方案。
This course covers SSIS, SSRS and SSAS from Basics to Advanced LevelsSSIS - SQL Server Integration ServicesSSAS - SQL Server Analysis ServicesSSRS - SQL Server Reporting ServicesSSIS: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 connectionSSRS:It's a reporting platform; it's used to generate the reports from any data source (any RDBMS).Provides a full range of ready-to-use tools and services to help you create, deploy, and manage reportsReport: Report is nothing but a text based file to present the business data. Report file extension.rdl( Report definition language) It's a XML based file.We have three types of reports.• Enterprise reports• Ad-hoc reports.• Embedded reports.Enterprise reports: Complete business standards and rules followed. Formatting and other requirements collected. Report developers will prepare these reports with complexity. Shared among the business users in the enterprise. Standard data analysis and decision making purpose.Ad-hoc reports: No business standard and no rules followed. No formatted and other requirements. Non-technical business managers will prepare these reports. Not shared among business users in the enterprise. Ad-hoc data analysis purpose.Embedded Reports:Embedding the report to any third party application such as Java,.Net etc..Data Source: Data source means a connection string to a particular db system. In ssrs we have two types of data sources.1. Ordinary Data source2. Shared Data SourceOrdinary Data source: Data source connection string maintain in particular report. It's not reusable in the product.Shared Data Source: Data source connection string maintains in connection file (rds). It can be reusable for multiple reports in the application.In SSAS and SSIS2008 we have only shared Data source.Dataset: Dataset means in-memory result set structure prepared based on query or stored procedure.Dataset populated with actual rows at the time of report execution.A report requires at least one dataset.A report can use multiple datasets.SSAS:SSAS full form is SQL Server Analysis Services.Multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data.SSAS is an analysis service platform, which can be used to create and manage the analysis database.SSAS Contains Preaggregated data , internally creates analysis database, and once the analysis database is ready, it can be used for many purposesIt has 2 variants Multidimensional and Tabular.One or more cubes can be presented in the analysis database.
