|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-get-transform-m-language/
课程评论：没有评论
课程名称：高级 PowerQuery：合并语言 课程概述：增强您的数据转换能力。支持获取和转换的查询编辑器强大易用，即使是新手 Excel 用户也能通过鼠标和偶尔的一些键盘输入创建强大的数据处理查询。每个查询背后都有强大的合并语言，简称“M”。学习几个使用该语言的小技巧，可以让您比仅使用编辑器更快地创建更有用和强大的查询。 在本课程中，您将深入了解查询编辑器，学习 M 代码的语法和结构，从而能够构建查询并进行手动调整，以产生仅通过图形界面无法实现的结果。 节省重用查询代码的时间：如果您发现自己很喜欢在查询编辑器中快速完成许多操作，但又觉得自己在不断重复同样的操作，那您可能是。通过几行额外的代码，您可以将重复使用的查询变成直接可重用的函数，从而节省时间和精力，并显著提高维护、更新和编辑查询的能力。在本课程中，您将学习如何从现有查询或从头开始构建可重用的函数，以便在查询编辑器中创建自定义的可重用用户函数。 将复杂逻辑融入转换中：您是否曾经需要根据多个字段的组合进行迭代计算结果，或者想根据同一数据集中的其他行进行复合计算？这些问题往往需要复杂逻辑，通常属于真正面向对象语言的范畴，而不是像 SQL 那样的数据库计算。 “M”语言允许您构建循环、编写递归函数，并将正确的错误捕获和管理纳入查询，轻松实现所需的详细逻辑。在本课程中，您将学习如何在 M 语言中完成这些操作，使用查询编辑器来引导并测试您的代码。 将概念结合起来以解决问题：本课程设置了多个挑战以及完整的实践练习，帮助您学习如何应用和组合各种组件。一个较大规模的练习将要求您运用关于获取和转换的全部知识，构建一系列可以解决单词搜索难题的查询和函数。每项挑战和练习集都配备指导视频讲解，以帮助您达成解决方案，同时提供解决方案文件供您自主学习。
Empower your ability to transform data..The Query Editor that supports Get & Transform is powerful and allows even the newest Excel users to create powerful data manipulation queries with only their mouse and, occasionally, a few keyboard inputs. Behind each query is the powerful Mashup language, "M" for short. Picking up even a few tips and tricks with the language itself can allow you to create even more useful and powerful queries far faster than with strictly the editor alone.In this course, you'll dive behind the Query Editor to learn about the syntax and structure of M Code so that you can build queries with the query editor and make manual adjustments to create results not achievable strictly through the graphical interface.Save time with reusable query code..Found yourself loving how quickly you can do so many things in the Query Editor but feel like you've been doing the same thing over and over? You probably have been and there's a solution for that!With a few extra lines of code, you can turn many of your queries that you've duplicated and re-used over and over again into directly re-usable functions that will save you time, hassle, and dramatically improve your ability to maintain, update, and edit your queries.In this course, you will learn about how to build reusable functions from existing queries or from scratch to give you the ability to build custom reusable user functions within your Query Editor. Incorporate complex logic into your transformations..Have you ever found yourself needing the results of an iterative calculation based upon a combination of fields or wanting to compute a compound calculation based upon other rows within the same data set?These types of problems require complex logic that is generally the realm of true object oriented languages and other solutions rather than database computations like those generated from SQL.The "M" language allows for constructing loops, writing recursive functions, and incorporating proper error trapping and management as part of your queries, allowing you to incorporate the detailed logic necessary for your solution. In this course, you'll learn how to do each of these things within the M language, using the Query Editor to guide and test your code as you progress.Apply the concepts together to solve problems..The course has multiple challenges plus full-scale practice exercises to help you learn how to apply and combine the various components together. One large-scale exercise will have you applying everything you know about Get & Transform to build a series of queries and functions that can solve Word Search puzzles.Each challenge and practice set has guided video explanations for how to arrive at the solution plus the solution files to peruse at your own pace.
