|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-sql-server-analysis-server-ssas/
课程评论：没有评论
课程名称：使用 SQL Server 分析服务进行数据分析 - SSAS 课程概述： 数据分析是一种检查、清理、转化和建模数据的过程，目的是发现有用信息、支持结论及决策制定。SQL Server 分析服务（SSAS）是微软商业智能技术栈中的一部分，用于开发在线分析处理（OLAP）解决方案。简单来说，您可以利用 SSAS 从数据集市或数据仓库中创建数据立方体，以便进行更深入和快速的数据分析。 分析服务是用于决策支持和商业分析的分析数据引擎。它为商业智能（BI）、数据分析及报告应用程序（如 Power BI、Excel、Reporting Services 及其它数据可视化工具）提供企业级的语义数据模型能力。分析服务可在不同平台上使用。 在分析服务中，表格模型是以数据库形式存在的，运行在内存中或直接查询模式连接后端关系数据源。通过使用最先进的压缩算法和多线程查询处理器，分析服务的 VertiPaq 分析引擎为 Power BI 和 Excel 等报告客户端应用程序提供快速访问表格模型对象及数据的能力。 表格模型的创建在 Microsoft Visual Studio 中进行，利用分析服务项目扩展。该扩展安装了一个表格模型设计器，提供了用于创建语义模型对象（如表、关系、度量和关键绩效指标）的设计界面。表格模型可以部署到 Power BI Premium、Azure 分析服务或配置为表格服务器模式的 SQL Server 分析服务实例。已部署的表格模型可以在 SQL Server 管理工作室或多种其他工具中进行管理。
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.SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms.Tabular models in Analysis Services are databases that run in-memory or in DirectQuery mode, connecting to data from back-end relational data sources. By using state-of-the-art compression algorithms and multi-threaded query processor, the Analysis Services VertiPaq analytics engine delivers fast access to tabular model objects and data by reporting client applications like Power BI and Excel.Tabular models are created in Microsoft Visual Studio with the Analysis Services projects extension. The extension installs a tabular model designer, which provides a design surface for creating semantic model objects like tables, relationships, measures, and KPIs.Tabular models can be deployed to Power BI Premium, Azure Analysis Services, or an instance of SQL Server Analysis Services configured for Tabular server mode. Deployed tabular models can be managed in SQL Server Management Studio or by using many different tools.
