Paul O'Sullivan
Finance Director and Data Engineer
Dublin, Ireland
Actions
Paul is a seasoned data professional with over 30 years in Ireland’s financial services industry, bringing deep expertise in data transformation, analytics, and business intelligence.
Links
Area of Expertise
Topics
Going Beyond the Power Query UI: Start Coding with M
Power Query is a fantastic tool for shaping and transforming data—but if you’ve only used the user interface (UI), you’re missing out on its full potential. In this session, we’ll take the leap into writing M code, the language behind Power Query.
You’ll learn:
Where and how to write custom M code (Formula Bar, Custom Columns, Advanced Editor).
The syntax essentials: keywords, data types (Scalar, List, Record, Table, Function) and object structures.
Practical demos, including:
Adding new dimensions to a Pivot table.
Combining multiple CSV files with inconsistent column names.
Tweaking Group By to show detailed results.
Walk away with the confidence to both go beyond the UI and amend UI generated code, unlocking new possibilities in Power BI and Excel.
Previous experience with the Power Query UI is necessary to get value from this session
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top