00:00 Start 01:00 Thanks 01:50 Github Webpage 03:25 ETL explaining 04:00 Query Editor Window 04:20 Query Steps 04:38 Custom Column Dialog (*) 04:50 Advanced Editor 05:15 Getting the total revenue with m (*) 07:20 More about the advanced editor (*) 07:40 "More" advanced editors and Visual Studio Tests 10:35 Why Learn M (*) 13:00 The M Programming Language (*) 14:15 Making the Hello World 15:40 Referencing other queries 18:00 Let Statement 18:25 Add Comments and about #" " 19:50 Evaluation and the in statement 20:35 Order of the lines doesn't matters 21:20 Query Folding 23:00 Query Folding Example 23:34 Native Queries 24:15 M type system (*) 25:40 M Datatypes 25:56 Initializing Dates and Times (*) 26:20 Lists (*) 28:35 Text.Select 30:20 Records [*] 32:30 Combination Operator 32:50 Table.FromRecords 33:35 Creating User-Defined Types 36:30 Using each (*) 39:00 Calculating Across Rows (*) 41:15 M function library 41:50 Accessing Data using OData.Feed 44:44 Using Web.Contents 46:45 Understanding Function Queries (**) 56:25 List.Generate 58:30 Query Parameter (*) 1:00:00 Creating a Project Template 1:06:00 Custom Data Connectors 1:12:48 Microsoft Graph API 1:14:35 Authorization Code Grant Flow 1:16:20 Registering an Azure Application
Ted, this was really well done and your examples and GITHUB resources were fantastic. Thanks again Ted. It is so true about the lack of resources for M...Hopefully, we can gain more insights about the language from Chris & Reza...there is just so much to learn ;P
@CriticalPathTraining Great demo, helped a lot. Can I ask question? is it possible using M to create multiple output/target records based on analyzing source field? For example, if I have a source field as a list of tags separated by semicolons and have each tag as a single record in the target? E.g. in the source - "RecordX", "Tag1; Tag2; Tag3; Tag4" In the target as separate records/lines: "RecordX", "Tag1" "RecordX", "Tag2" "RecordX", "Tag3" "RecordX", "Tag4" I need at least to understand terminology to look for the right functions, etc.
00:00 Start
01:00 Thanks
01:50 Github Webpage
03:25 ETL explaining
04:00 Query Editor Window
04:20 Query Steps
04:38 Custom Column Dialog (*)
04:50 Advanced Editor
05:15 Getting the total revenue with m (*)
07:20 More about the advanced editor (*)
07:40 "More" advanced editors and Visual Studio Tests
10:35 Why Learn M (*)
13:00 The M Programming Language (*)
14:15 Making the Hello World
15:40 Referencing other queries
18:00 Let Statement
18:25 Add Comments and about #" "
19:50 Evaluation and the in statement
20:35 Order of the lines doesn't matters
21:20 Query Folding
23:00 Query Folding Example
23:34 Native Queries
24:15 M type system (*)
25:40 M Datatypes
25:56 Initializing Dates and Times (*)
26:20 Lists (*)
28:35 Text.Select
30:20 Records [*]
32:30 Combination Operator
32:50 Table.FromRecords
33:35 Creating User-Defined Types
36:30 Using each (*)
39:00 Calculating Across Rows (*)
41:15 M function library
41:50 Accessing Data using OData.Feed
44:44 Using Web.Contents
46:45 Understanding Function Queries (**)
56:25 List.Generate
58:30 Query Parameter (*)
1:00:00 Creating a Project Template
1:06:00 Custom Data Connectors
1:12:48 Microsoft Graph API
1:14:35 Authorization Code Grant Flow
1:16:20 Registering an Azure Application
Query functions demo was awesome, I've started implementing that now. So cool!
This was great. Quite quick paced, but loads of content and some great tips and tricks.
Excellent webinar Ted, thanks! It helped me to clarify many concepts and also to know M more in deep.
Really appreciate this excellent step by step explanation. Very informative. Thanks :)
Ted, this was really well done and your examples and GITHUB resources were fantastic. Thanks again Ted. It is so true about the lack of resources for M...Hopefully, we can gain more insights about the language from Chris & Reza...there is just so much to learn ;P
@CriticalPathTraining Great demo, helped a lot. Can I ask question? is it possible using M to create multiple output/target records based on analyzing source field? For example, if I have a source field as a list of tags separated by semicolons and have each tag as a single record in the target?
E.g. in the source - "RecordX", "Tag1; Tag2; Tag3; Tag4"
In the target as separate records/lines:
"RecordX", "Tag1"
"RecordX", "Tag2"
"RecordX", "Tag3"
"RecordX", "Tag4"
I need at least to understand terminology to look for the right functions, etc.
Full of Great Tips!! Thx
Thanks for the explanation, but just to clarify on it, an ETL tool is just not a query editor. Cheers
Thanks Ted, so many good tips here!
You're freaking great explaining
GREAT video - many thank !!
Like it man, thanks for sharing.
Good webinar... Thanks for the video
Great video... Thanks a lot.