|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ssas-tabular-model-with-power-bi-a-comprehensive-training/
课程评论：没有评论
课程名称：SSAS Tabular Model with Power BI - 全面培训 课程概述：微软分析服务（SSAS）包括两种模式：1- SSAS 表模式和 2- SSAS 多维模式。本课程专注于 SSAS 表模式，该模式在内存中运行或采用直接查询模式。课程将介绍不同的数据源，这些数据源可以用于为表模型提供数据。当在 Power BI Desktop 中使用直接查询时，性能问题是一个挑战，因为 Power BI 在刷新仪表板或进行交互时会发送 SQL 查询，SQL 服务器需要处理这些查询并返回结果，这可能影响性能。通过 SSAS 表模型，我们可以根据业务流程要求设计和开发数据模型，添加 KPI、DAX 计算测量、计算列，最终将该模型部署到 SSAS 分析服务器上。Power BI Desktop 或 SSRS 可以连接到 SSAS 表模型，从中获取数据以展示在报告和仪表板上。SSAS 表模型在性能和安全性方面提供了极大的灵活性。 在本课程中，您将学习以下主题： - 如何安装 SSAS 表实例 - 如何导入 AdventureWorks 数据库 - 星型模式与雪花模式 - SSAS 表模型中的不同功能 - 角色扮演维度 - 如何部署 SSAS 表模型 - 如何创建层次结构 - SSAS 表模型中的透视 - DAX 和计算列在 SSAS 表模型中的应用 - 如何创建 KPI - SSAS 表模型中的分区 - 表模型处理选项 - SSAS 表模型中的行级安全性 - 通过脚本部署表模型 本课程将随着表模型的新功能推出而保持更新。祝您学习如何创建和部署 SSAS 表模型一切顺利！
Microsoft Analysis Services abbreviated as SSAS consist of two modes. 1- SSAS Tabular Mode2- SSAS Multidimensional modeThis course is purely based on SSAS Tabular model. Tabular model in analysis services runs in memory or in the direct query mode. There are different data sources available that can be used to feed data to a tabular model.When we use the direct query in the Power BI desktop, all the time we fight with the performance issue. Power BI desktop fires SQL queries during refreshing dashboards or doing some interactions. SQL Server needs to run these queries and send the result back to the Power BI which causes performance issue. But with the help SSAS Tabular model, we can design and develop the data model according to the business process requirement, add KPIs, DAX measures, calculated columns, and finally, this model is deployed on the SSAS analysis server.We can connect the Power BI desktop or SSRS to the SSAS tabular model and fetch the data to show on reports & dashboards. SSAS tabular model provides great flexibility in terms of performance and security.In this course, you will learn the following topics- How to install SSAS Tabular instance- How to import AdventureWorks database- Start schema vs snowflake schema- Different features in SSAS Tabular models- Role-playing dimensions- How to deploy SSAS Tabular model- How to create hierarchies- Perspectives in SSAS tabular model- DAX and calculated columns in SSAS tabular model- How to create KPIs- Partitions in SSAS tabular model- Tabular model processing options- Row-level security in SSAS tabular model- Tabular model deployment via scriptWhenever new features in the Tabular model will come, I will keep this course up to date.I wish you all the best to learn how to create and deploy SSAS tabular models.
