|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-365-power-bi-desktop-intermediate/
课程评论：没有评论
**课程概述：** 本课程是“Microsoft 365 Power BI Desktop - 进阶”课程，旨在帮助学员掌握创建高度交互式报表和仪表板，以支持管理层实时分析和决策的需求。课程内容将围绕数据刷新、数据建模、计算列以及多种进阶可视化和筛选器技术展开。 **核心内容：** * **数据刷新与来源管理：** 讲解数据刷新对报表时效性的影响，以及如何针对不同数据来源优化 Power BI Desktop 的连接和刷新策略，确保数据的最新状态。 * **数据建模进阶：** 深入探讨数据建模的关键概念，包括表关系、基数、行级别安全性（Row-level Security）和参照完整性（Referential Integrity），确保数据的准确性和可用性。 * **计算列的应用：** 学习如何创建计算列，以弥补数据源信息的不足，为进一步的分析和预测提供所需数据。 * **高级可视化技巧：** 介绍甜甜圈图、树状图、组合图（折线和堆积柱形图/簇状柱形图）、地图、填充地图等可视化类型，并重点讲解各种可视化图表适用的场景和最佳实践。 * **交互式筛选与切片器：** 教授如何运用筛选器（包括包含/排除筛选器、交叉筛选器、Top N 筛选器、相对日期筛选器）和切片器（日期切片器、时间切片器、数值范围切片器等）来增强报表的交互性和用户分析体验，并演示如何将它们集成到仪表板中。 **目标学员：** 具备 Power BI beginner 课程基础，需要进一步提升报表和仪表板创建能力的学员。 **讲师：** Eric Brockway
Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision making. This course builds on the beginner course and enables dashboard creators to support these requirements.Data is only as up to date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organizations reporting data.Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics: Table Relationships, Cardinality, Row-level Security, and Referential Integrity.Sometimes a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course.Visualizations that are not covered in the beginner course are covered here. This course includes: Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps mostly importantly, use cases that determine when each of these visuals is the best one to use are explained and demonstrated.Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters are also included such as: Include / Excluded filters, Cross filters, Top N filters, and relative Date filters.Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others.Even though dashboards are covered in the beginner course, there is so much that can be done with them! In this course, dashboards are created the use the new visualizations and that also incorporate filters and slicers!Instructor: Eric Brockway
