|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-power-query-with-microsoft-power-bi/
课程评论：没有评论
**课程名称：** 使用Microsoft Power BI学习Power Query **课程概述：** 本课程将带您深入了解Microsoft Power BI中的Power Query编辑器，学习如何使用它对数据集执行各种操作。Power Query因其便捷高效地处理复杂数据集的能力而在业界得到广泛应用，用户只需通过简单的点击即可完成多种高级数据处理任务。尽管Power Query也支持Python和R等高级编程语言，但本课程将专注于其在Power BI中的应用，同时也会提及它在Microsoft Excel中的使用。 Power Query在数据清洗和准备方面发挥着至关重要的作用，能够使数据集适用于后续的数据分析，并通过创建可视化图表和分析报告来发掘业务洞察，这与任何商业智能软件（包括Power BI）的应用目标一致。Power Query提供了丰富的功能和操作，是数据科学的关键组成部分。因此，Power BI不仅是一款商业智能软件，也能有效地支持数据科学的各个阶段，包括数据清洗、准备、建模以及通过可视化报告驱动洞察。 本课程的核心重点是数据科学的第一阶段——**使用Power Query进行数据清洗和准备**。 **课程内容：** 学员将学习以下Power Query功能和操作： * 行删除与列拆分 * 替换列值 * 合并列 * 添加后缀和前缀 * 文本大小写转换（转换为小写、大写） * 添加和转换列 * 提取函数 * 基于分隔符的提取 * 添加条件列和索引列 * Power Query中的日期函数 * 查询编辑器选项和设置 * 日期和时间函数（如年龄计算等） * 时间函数 * 排序
In this course you will be learning about performing various operations on a dataset using Power Query editor in Microsoft Power BI Business Intelligence software. Power Query is widely used in the industry as quick and easy way to perform various kinds of advanced operations on a dataset using just a matter of few clicks. Although it supports advanced programming support with languages like Python and R. Power Query can be used in Microsoft Power BI as well as Microsoft Excel. Here, you will be learning everything on Power BI Query editor.Power Query can be used for Cleaning and Preparing Dataset suitable for conducting further analysis and finding Insights by creating Visualization charts and Analytics reports in any business intelligence software including Power BI. Power query allows a wide range of functions and operations for data preparation. These process are key components for Data Science and thus Power BI can be effectively used as a BI software for conducting all phases of Data Science. Using Power BI you can clean and prepare your data, create models and drive insights by creating visualization charts and reports. This course is primarily focused on First stage of data science, that is Data cleaning and Preparation with Power Query.In this course, you will be learning following Power Query functions and operations-Row deletion and Column SplitReplace Column valuesColumn MergeAdding Suffix and PrefixConverting text to Lowercase and UppercaseAdding and Transforming columnsExtract FunctionExtract based on delimiterAdding Conditional and Index ColumnDate Functions in Power QueryQuery Editor options and settingsDate and Time function- Age calculation and moreTime FunctionsSorting
