|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-intermediate-learn-the-finer-points-of-power-bi/
课程评论：没有评论
课程名称：Power BI中级：学习Power BI的细节 课程概述：G Com Solutions的Power BI中级课程旨在为已经熟悉Power BI的用户提供更深层次的知识，以便于他们在创建报告和仪表板时拓宽视野。课程将扩展对查询编辑器的理解，学习如何使用查询参数和模板来增强报告创建的能力和灵活性。学员将掌握如何利用查询参数控制数据源以及在数据加载到数据模型时过滤数据。此外，课程还讨论了行级安全性（RLS）、角色创建以及在Power BI服务中实现RLS的流程。同时，我们还会学习如何利用DAX的USERNAME函数创建基于用户登录的角色。 课程进一步探讨Power BI与其他Microsoft产品的集成，包括如何将Excel解决方案整合至Power BI工作区，以及如何使用“在Excel中分析”功能基于Power BI数据集构建Excel报告。我们还讨论了如何将Excel内容固定到Power BI仪表板，以及如何利用Power BI的仪表板订阅功能将Excel内容分发给更广泛的受众。 此外，课程内容还涉及连接SharePoint文件夹及子文件夹，连接SharePoint列表，以及将Power BI报告嵌入SharePoint页面时涉及的安全性问题。我们也讨论了PowerPoint集成功能，包括控制将报告导出至PowerPoint的租户设置，报告导出机制，以及如何针对PowerPoint导出优化报告以获得最佳效果。 课程随后移动到钻取页面的配置和实施，讨论跨报告钻取以及如何克服该功能的一些限制，并通过定制工具提示页面来结束相关内容。接下来，我们将讨论DAX中的“假设”参数，介绍Power BI内置功能的使用，及如何通过创建自定义参数表来扩展这一功能。 最后，我们将使用参数功能作为切入点，创建一个复杂的货币转换仪表板，借此机会练习其他实用技巧，如在报告中包含自定义可视化、使用DAX变量让公式更清晰易维、以及通过创建由复杂DAX公式驱动的动态标题来给用户提供有效的互动反馈。 如果您已掌握Power BI的基础知识并希望在此基础上进一步学习，G Com Solutions的Power BI中级课程将是您的理想选择。
The Power BI Intermediate course by G Com Solutions is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to creating reports and dashboards.The course will extend your knowledge of the Query Editor by showing your how to use query parameters and templates to add power and flexibility to your report creation. You will learn how to use query parameters to control data sources and to filter data as it's loaded into the data model.The course also discusses row-level security (RLS), the creation of roles and the implementation of RLS in the Power BI service. And we'll also see how to leverage the DAX USERNAME function to create roles which are based on the user's login.We then move on to the integration of Power BI with other Microsoft products. We look at the incorporation of Excel solutions into Power BI workspaces and how to use the Analyze in Excel feature to build Excel reports driven by Power BI datasets. We also discuss the pinning of Excel content to Power BI dashboards and how to leverage Power BI's dashboard subscription feature to distribute Excel content to a much wider audience than is normally possible.We look at connecting to SharePoint folders and sub-folders, connecting to SharePoint lists and the security implications involved when embedding Power BI reports within SharePoint pages.We also discuss PowerPoint integration: the tenant settings which control the ability to export reports to PowerPoint, the mechanism for exporting reports; and how to get the most out of this feature by optimizing your reports specifically for PowerPoint export.The course then moves on to the configuration and implementation of drill-through pages and this includes a discussion of cross-report drill-through and how to overcome some of the limitations of this feature. And, we end this section with a look at a feature often used in conjunction with drill-through; customized tooltip pages.Next, we talk about DAX what-if parameters and, after discussing the use of Power BI's built-in feature, which can only be used with numeric parameters, the course shows you how to extend this feature by creating your own custom parameter tables.And we use the parameters feature as a launchpad to the creation of a sophisticated currency conversion dashboard which gives us a chance to practice other useful techniques, such as the inclusion of custom visuals in your reports, the use of DAX variables to make your formulas clearer and easier to maintain, and how to provide useful interactive feedback to your users by creating dynamic titles driven by complex DAX formulas.So, if you've already mastered the basics of Power BI and are looking to build on that knowledge, the Power BI Intermediate course by G Com Solutions could be exactly what you need.
