|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-microsoft-power-query/
课程评论：没有评论
课程名称：掌握 Microsoft POWER QUERY 在 POWER BI 和 Excel 中的应用（ETL 工具） 课程概述：在当今商业环境中，数据分析、报告和仪表板的创建技能被高度重视。微软 Power BI 被公认为世界领先的商业智能工具，用于开发报告、数据分析和仪表板。在本课程中，您将学习如何使用强大的 Power BI 工具来转换和准备数据以进行分析。您将学习使用查询编辑器连接数据、执行高级转换以及清理数据。 课程内容包括： - 介绍和课程内容 - 基础数据转换：学习过滤数据、改变数据类型、添加新列和删除列 - 高级数据转换：合并表格、追加数据、反透视数据、分组数据、条件规则和自定义字段 - 数据清理：清理数据所需的技能和技术 如果您是 Power BI 新手或想要填补知识空缺，那么这门课程非常适合您。我们专注于提供您有效使用 Power BI 数据所需的基础知识！不要再花费数天时间参加无聊的培训来理解 Power BI 的工作原理！本课程将帮助您快速上手，节省一半时间，为您成为 Power BI 专家的旅程打下重要基础。 本课程已于 2022 年更新，并提供全高清的视频质量，您将在最新的 Power BI 界面上进行学习。
Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.In this course you will learn the to use the AMAZING Power BI tool to transform and prepare your data for analysis. You will learn to use the Query Editor to connect to data, perform advanced transformation and also to clean data.In this course:Introduction and Course ContentBasic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columnsAdvanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fieldsData Cleansing - Techniques and skills to clean up your dataIf you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Power BI data effectively!Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.This course has been updated for 2022 in full HD video quality, so you will learn on the latest Power BI interface.
