|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-analysis-services-for-beginners-ssas/
课程评论：没有评论
课程名称：初学者的SQL Server分析服务 - SSAS 课程概览： 本课程介绍分析服务（Analysis Services），这是一种用于决策支持和业务分析的分析数据引擎。它提供了企业级的语义数据模型功能，适用于商业智能（BI）、数据分析和报告应用程序，如Power BI、Excel、Reporting Services以及其他数据可视化工具。分析服务有多个平台可供选择。 在分析服务中，表格模型是运行在内存中或以DirectQuery模式连接后端关系数据源的数据库。通过使用先进的压缩算法和多线程查询处理器，Analysis Services的VertiPaq分析引擎为报表客户端应用程序（如Power BI和Excel）提供快速访问表格模型对象和数据的能力。 内存模型是默认选项，而DirectQuery则是一个替代查询模式，适用于无法完全加载到内存中的大型模型，或当数据波动性使得合理的处理策略无法实现时。DirectQuery通过支持多种数据源、处理DirectQuery模型中的计算表和计算列、通过DAX表达式实现行级安全性以及优化查询以提高吞吐量等方式来达到与内存模型的功能平等。 表格模型通过Microsoft Visual Studio与分析服务项目扩展一起创建。该扩展安装了一个表格模型设计器，提供了创建语义模型对象（如表、分区、关系、层次结构、度量和关键绩效指标）所需的设计界面。 创建的表格模型可以部署至Power BI Premium、Azure Analysis Services或配置为表格服务器模式的SQL Server分析服务实例。已部署的表格模型可以在SQL Server Management Studio中管理，也可以通过各种工具进行管理。
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 platformsTabular 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.While in-memory models are the default, DirectQuery is an alternative query mode for models that are either too large to fit in memory, or when data volatility precludes a reasonable processing strategy. DirectQuery achieves parity with in-memory models through support for a wide array of data sources, ability to handle calculated tables and columns in a DirectQuery model, row level security via DAX expressions that reach the back-end database, and query optimizations that result in faster throughput.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, partitions, relationships, hierarchies, 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.
