|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-query-m-language-with-specialize-in-web-scraping/
课程评论：没有评论
课程名称：Power Query M 语言与网页数据抓取专精 课程概述： M 公式语言是数据分析项目中至关重要且具有挑战性的任务之一，主要涉及数据转换与清理。我们需要准备数据，使其适合分析，从而提取有用的见解。在 Power BI 的世界里，Power Query 类似于数据仓库的 ETL 工具。每当我们对数据进行操作时，Power Query 会生成 M 代码，这是一种公式语言。M 语言包含丰富的数据转换和清理函数。 学习 M 语言的意义： 在 Power BI 中，我们使用图形用户界面来执行不同的数据操作，但这种接口功能有限，并不能支持所有的数据相关操作。尽管微软每月发布新版本的 Power BI，带来新的图形工具，但我们仍需依赖 Power Query 的独特功能。通过学习 Power Query M 语言，我们可以克服这种依赖。M 语言比 Power Query 更强大，因为我们可以掌握整个底层自动生成的代码。 课程内容： 本课程将教授 Power Query M 语言的所有构建模块，让您独立掌握这门语言。课程将为您提供关于 M 语言的清晰路径，教您如何实施可用的任何数据转换函数。未来将不定期添加新功能和特性。 关于我： 我叫穆罕默德·阿西夫（Muhammad Asif），将担任本课程的讲师。我在数据与分析领域拥有超过十年的经验，曾在全球领先的组织工作。我是一名微软认证的数据分析与管理解决方案专家，开发了多个数据模型、仪表板与报告。希望通过我的经历与简单化的方式，传播知识，祝愿您在 Power BI 和 M 公式语言的学习旅程中一切顺利！
What is M formula languageOne of the most critical and challenging tasks in any data analytics project is data transformation & data cleaning. We need to prepare the data to make it suitable for analysis to retrieve useful insights.In the world of power bi, we have a Power query like an ETL for the data warehouse. Whenever we perform any operation on the data, the power query generates M code, a formula language. M formula language contains a rich set of different functions for data transformation & cleaning.Why learn M formula languageIn power bi, we have a graphical user interface that we use to perform different operations on the data. Still, unfortunately, this interface is minimal. We cannot perform all the data related operations on it by using a graphical user interface. Almost every month, Microsoft releases new versions of Power BI, which have new graphical tools in the power bi ribbon. However, we still have to depend on the unique features of the power query graphical user interface.We can overcome this dependency by learning the Power Query M language. M language is much more powerful than the Power query because the entire underlying auto-generated code will be in our hands.In this course, You will learn all the building blocks of Power query M language to master it on your own. This course will give you a clear path about the M language on how to implement any available function for data transformation.New upcoming features & functions will be added in this course from time to time.About meMy name is Muhammad Asif, and I will be your instructor in this course. I have more than ten years of experience in data & analytics with one of the world's leading organizations. I am a Microsoft certified solution expert in data analytics & management.I have developed several data models, dashboards & reports for a different line of services. You can learn from my experience, and I will share each and everything. I aim to spread the knowledge by simplifying hard concepts.I wish you all the best for your journey in Power BI & M formula language.
