|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tabular-editor-3/
课程评论：没有评论
课程名称：Microsoft Power BI 的 Tabular Editor 3 课程概述：在本课程中，您将学习如何使用 Power BI 的最佳外部工具——SQL Server 分析服务。掌握 TE3 是一项重要技能，它使您能够高效地开发模型，无需使用 PBIX 或 Visual Studio 项目即可对实时数据库进行更改。您可以编写 DAX 查询来调查数据，可以通过一次提交创建度量值、列和表，而无需等待 Power BI Desktop 逐一更新和处理更改，从而节省开发时间。 您还可以通过编写 C# 脚本来自动化流程，允许您遍历标量对象模型中的对象并执行某些操作。使用 TE3，您可以创建计算组，这减少了必须创建的度量值或度量值变体的数量，并提供无缝体验。您可以编写所有计算组的脚本，并使用该脚本将计算组部署到完全不同的数据模型。 此外，TE3 允许您使用 LINQ 编写自己的最佳实践，以便您可以评估自己组织中的模型，识别违反规则的对象。您可以单独对表和分区等标量对象执行处理命令，可以在 Power BI 服务中修改增量刷新策略，然后在那里处理分区。 这只是冰山一角，TE3 还有很多更多功能可供您探索，它在节省开发工作方面绝对强大！我期待您加入课程，帮助您掌握这一工具。
In this course you will learn how to use the best external tool for Power BI, SQL Server Analysis Services.Learning TE3 is an important skill as it allows you to develop models efficiently, make changes to a live database without the PBIX or Visual Studio projectYou can write DAX Queries to investigate data, you can create objects such as Measure, Columns, and Tables with a single commit, without waiting for Power BI Desktop to update and process the changes one by one which in turn reduces the development time.You can automate the processes by writing C# Scripts that allow you to iterate the objects in Tabular Object Model and perform certain actions.You can use TE3 to create Calculation Groups which reduces the number of measures or variations of measure(s) that you have to create and provide a seamless experience, using TE3 you can script all the Calculation Groups and use that script to deploy Calculation Groups to a completely different data model.TE3 allows you to write your own Best Practices using LINQ so that you can evaluate the models in your organization against those best practices and identify the objects that break the rulesYou can execute process commands on Tabular objects such as Tables & Partitions on individual basis, you can modify Incremental Refresh Policies in Power BI Service and then process partitions there.This just the tip of the iceberg and there is a lot more that you can do with TE3 it is an absolute beast in terms of saving development efforts!I am excited to see you inside the course and enable you master this tool.
