|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-report-builder/
课程评论：没有评论
**课程名称：Microsoft 365 Power BI 报表生成器 - 中级** **课程概述：** 本课程是初级课程的延续，将深入探讨 Power BI 报表生成器的各项高级功能，帮助您构建更具专业性和交互性的报表。 **主要学习内容：** * **参数与数据集集成：** 学习如何创建和集成参数，实现数据的自定义选择和筛选，并通过下拉列表增强报表的交互性。 * **报表增强与格式化：** 运用表达式美化您的报表，包括添加交替行颜色、条件格式化，以及使用表达式处理和纠正不良数据。 * **高级筛选与计算：** 掌握“Top N”筛选器的创建，以及运行值的计算，并学习使用 IIF, SWITCH, ROWNUMBER 等多种实用函数。 * **图表设计与应用：** 探索不同类型的图表，如树状图、旭日图、甜甜圈图、漏斗图和散点图，并理解其应用场景。通过表达式和参数定制图表外观和功能。 * **高级分组与层级：** 深入学习报表的组合技巧，通过表达式创建分组，手动构建层级结构，实现对数据分组的精细化控制。 * **报表交互性增强：** 提升报表的用户体验，通过交互式排序、筛选、可折叠/展开的层级、书签和文档映射等功能，使报表更具动态性。 * **地理地图集成：** 学习在报表中添加地理地图，包括热力图和颜色地图，以可视化分析业务数据。还将学习如何利用互联网上的空间数据创建国际地图。 **讲师：** Eric Brockway
This course continues where the beginner course leaves off. Parameters are introduced and integrated with datasets for customized selection of data. Drop-down lists are created for interactive filtering.Expressions are used to enhance reports. Visual formatting is added with alternating colors and rows, and conditional formatting is also applied. Expressions are used to correct for bad data. Top N filters are created along with running values. A number of functions are introduced like: IIF, SWITCH, ROWNUMBER and others.Charts for reports and dashboards are introduced with emphasis on the reasons for using specific chart types. Traditional charts are created as well as treemaps, sunburst charts, donut charts, funnel charts and scatter plots. Expressions and parameters are added to charts to customize appearance and add functionality.Advanced grouping is explored by creating groups with expressions. Hierarchies are created manually. Grouping layers are added manually for perfect control of all aspects of data groups.Interactivity is added to reports through interactive sorting, filtering, collapsible and expandable hierarchies, bookmarking, and document mapping.Maps are a staple on modern reports. To finish the course, geographic maps are added to reports to help analyze business data. These maps include heat maps and color maps. International maps are also created using spatial data available from the Internet.Instructor: Eric Brockway
