|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-reporting-ms-sql-etlssis-ssrs-ssas/
课程评论：没有评论
课程名称：数据分析与报告 - (MS SQL, ETL, SSIS, SSRS, SSAS) 课程概述：数据分析是对数据进行检查、清理、转化和建模的过程，目的是发现有用信息，得出结论，并支持决策制定。而数据报告则是收集和提交数据的过程，能够准确分析现实情况；不准确的数据报告可能导致基于错误证据的决策失误。本课程将深入探讨几个关键技术和工具：SQL Server Integration Services（SSIS）是微软SQL Server数据库软件的一个组成部分，广泛用于执行数据迁移任务，是数据集成和工作流应用的平台，具备数据提取、转换和加载的仓库工具。SQL Server Reporting Services（SSRS）是微软的基于服务器的报告生成软件，可以通过Web界面管理，用于准备和传递各种交互式和打印报告。Microsoft SQL Server Analysis Services（SSAS）提供在线分析处理和数据挖掘功能，帮助组织分析和理解分散在多个数据库或不同表格、文件中的信息。 通过本课程，学员将掌握数据分析和报告的核心概念，以及使用MS SQL及其相关工具进行数据处理和报告生成的技能。
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.Data reporting is the process of collecting and submitting data which gives rise to accurate analyses of the facts on the ground; inaccurate data reporting can lead to vastly uninformed decision-making based on erroneous evidence.SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.
