Presentation Type: Presentation
There is no reason to be afraid of the advanced editor in Power Query - you can do a lot more in here than the user interface exposes. This session will guide you through different examples of hidden functions and variables you can use in your data extraction and transformations using Power Query, and you will learn how to make your queries dynamic and flexible, and even include error handling, if something you didn't expect to happen actually does. You will leave the session with a good understanding of how powerful the language of Power Query actually is and how you can use it in your tool belt. The learnings can be used both in Power BI Desktop and Excel.
CatMan Solution A/S
Microsoft Business Intelligence specialist in a wide variety of business applications. Particularly interested MS Excel, MS-SQL Server, Analysis services and Reporting services.
Leader of Denmark - Power BI User Group.
Now focusing on getting POS data to work as key data in BI solutions enabling my customers to make more effective strategic, tactical and operational insights and decision-making.
Specialties: Excel, OLAP, MDX, Reporting services, PowerPivot, SharePoint, Visualization, Power BI, Power Query, Power Apps, Flow, Azure
Tuesday, April 24
4:00 PM – 5:00 PM
Wednesday, April 25
9:00 AM – 10:00 AM