|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-advanced-take-your-power-bi-skills-to-a-new-level/
课程评论：没有评论
Power BI 高级：将您的 Power BI 技能提升到新的水平 本课程专为有经验的 Power BI 用户设计，通过一系列富有挑战性且实用的 Power BI 技术，帮助您磨练专业技能。课程将直接深入高级主题，包括数据类型优化、列分析和 M 语言编程，并讨论在处理 JSON、XML 和 SharePoint 库及文件夹时的先进数据连接技术。 此外，您将获得更多关于数据建模的实践经验，涵盖角色扮演维度和非活动关系的使用，以适应主事实表中多个重要日期。课程还会提供 DAX 的额外练习，包括计算列、计算表、DAX 度量值和时间智能函数。 为了高效地构建和使用数据集، 您将学习如何使用 PBIDS 文件实现数据集中化، 禁用报表静态数据导出، 创建数据流和共享数据集，以及如何推广和认证您的集中式数据集。 课程还提供高级可视化实践，您将有机会从头开始创建一个复杂的销售管道仪表板，并运用动态图表标题、颜色以及动态显示图表等技术。 在 Power BI 服务中，我们将深入探讨仪表板磁贴的细节：在文本框中创建超链接، 处理图像磁贴、Web 内容磁贴、视频磁贴，以及通过集成 Power Automate 功能实现实时数据流。 接着，我们将专注于数据可视化，探讨视觉对象的格式以及在切片器中显示图片层级，从而帮助用户跟踪销售经理和销售人员的表现。我们还将介绍一项实用技巧：创建在用户进行切片器选择时才会显示的图表。 总之，本课程将为熟悉所有基础知识的 Power BI 用户提供一个富有挑战性的实操研讨会，扩展您在 Power BI 最佳实践、数据建模、可视化和报表创建方面的知识。
The G Com Solutions Power BI Advanced course is designed to give experienced Power BI users the opportunity to hone their expertise in Power BI by tackling a series of challenging and useful Power BI techniques.This course assumes that you are already familiar with Power Query and so we dive straight into advanced topics like the optimizing Data Types, column Profiling and writing M language code, as well as discussing advanced data connection techniques used when working with JSON, XML and SharePoint libraries and folders.The course also provides further practice on data modelling, discussing such topics as role-playing dimensions and use of inactive relationships to cater for multiple significant dates within a main fact table. And, naturally, you will get plenty of additional practice in all aspects of DAX: calculated columns, calculated tables, DAX measures and time-intelligence functions.As an advanced Power BI report developer, it is also important that you build and utilize datasets in the most efficient manner. In this course, you will learn how to implement data centralization by using PBIDS Files, disabling the export of static data from your reports, creating dataflows and shared Datasets and how to promote and certifying your centralized datasets.The course also provides advanced visualization practice, and you will be given the opportunity to create a sophisticated sales pipeline dashboard, starting from scratch and using such techniques as dynamic chart titles and colors and Dynamically Showing a Chart.Then, back in the Power BI service, we discuss the finer points of dashboard tiles: Creating Hyperlinks in a Text Box, working with Image Tiles, Web content tiles, Video Tiles, and Streaming Real-time data by integrating Power Automate functionality.We then turn our attention to visualizing our data, we look at using the form of visual as well as displaying a hierarchy of images in slices, which enable the user to track the performance of sales managers, as well as individual salespeople. We also look at a useful technique for creating a chart which only becomes visible when a slicer selection is made by the user.In short, this course will offer Power BI users who are familiar with all of the fundamentals a challenging hands-on workshop, which will expand their familiarity with Power BI best practices, data modelling, visualization and report creation.
