Arthur Graus
Power BI Trainer / Consultant • Self Employed
Netherlands Antilles •
Request Pricing
About
Trained 1000+ students, can explain difficult topics clearly in fluent English with a touch of humor
Speaking Topics
Signature Programs (2)
How do you prevent unexpected data or incorrect files from blocking your dataset refresh? In this session you will learn what options you have to make your Power Query ETL more robust, such as: ○ catch errors with try otherwise and error details ○ filtering out and logging invalid files ○ filtering and logging incorrect rows ○ Creating error reports
M is the formula language behind Power Query. Every transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed when you only use the graphical interface. In this session you will learn what else is possible by using the Advanced Editor, such as: - Working with variables and data types - Custom Columns and Time Intelligence Filtering - Data grouping and sorting - Creating table and scalar functions - Crossjoin between 2 tables (make all possible combinations) Recently, the Advanced Editor also has Intellisense, so now is the time to delve into M!
Your Experience with Arthur
Your perspective matters!
What was it like engaging with Arthur?
