|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/basic-microsoft-power-bi/
课程评论:没有评论
课程名称:基础 Power BI 课程概述:本课程旨在为学习者提供全面的 Power BI 理解,从界面到高级数据转换和可视化。课程开始时介绍 Power BI 及其用户界面,确保学习者熟悉桌面应用程序的导航。随后,您将学习如何创建和格式化表格,探索各种可视化类型,以及理解聚合方法以有效总结数据。 在课程中,将涵盖关键的可视化技术,包括矩阵可视化、用于显示单一值的卡片可视化,以及用于数据选择的切片器和过滤器。您还将深入学习多种图表类型,如聚集柱形图、堆叠图、区域图、带状图和散点图,以帮助您直观地传达数据洞察。此外,您将了解 Power BI 的分解树可视化,使得动态的多维数据探索成为可能。 随着学习的深入,您将获得创建交互式报告和仪表盘的实践经验,将其发布到 Power BI 服务,甚至为移动设备设计报告。课程还涉及主题的使用、自定义视觉效果和计算列,增强报告的整体设计和功能。 课程的重要部分集中于 DAX(数据分析表达式),您将学习到基本函数,如 SUM、AVERAGE 和 DATE 函数,以及更高级的主题,如关系和度量值。同时,深入探讨 Power BI 的查询编辑器和 Power Query 转换,提供学习者有效数据清理和处理的工具。 通过本课程的学习,您将熟练掌握将 Power BI 连接到 Excel、创建数据透视表和导出数据,确保您能够将 Power BI 无缝整合到您的工作流程中。
This Basic Power BI course is designed to provide learners with a comprehensive understanding of Power BI, from its interface to advanced data transformations and visualizations. The course begins with an introduction to Power BI and its user interface, ensuring you are comfortable navigating the desktop application. You'll then learn how to create and format tables, explore various visualization types, and understand aggregation methods to summarize data effectively.The course covers key visualization techniques, including matrix visualization, card visualizations for displaying single values, and slicers and filters for data selection. You'll also dive into a range of charts, such as clustered column charts, stacked graphs, area graphs, ribbon graphs, and scatter charts, to help you communicate your data insights visually. Additionally, you'll learn about Power BI's decomposition tree visual, enabling dynamic, multi-dimensional data exploration.As you progress, you'll gain practical experience in creating interactive reports and dashboards, publishing them to Power BI Service, and even designing reports for mobile devices. The course also covers the use of themes, custom visuals, and calculated columns, enhancing the overall design and functionality of your reports.A significant portion of the course focuses on DAX (Data Analysis Expressions), where you'll learn essential functions like SUM, AVERAGE, and DATE functions, as well as more advanced topics like relationships and measures. Power BI's Query editor and Power Query transformations are explored in depth, providing learners with the tools needed for effective data cleaning and manipulation. By the end of the course, you'll be proficient in connecting Power BI to Excel, creating pivot tables, and exporting data, ensuring you can integrate Power BI seamlessly into your workflows.