The Power Query Professor
Microsoft MVP since 2006, Data Platform and Excel Expert, master of VBA programming, Power Pivot and financial modeling, Data cleansing and reshaping.
Тhe president of Excelguru Consulting Inc., blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.
His website hosts a large knowledgebase of Excel help articles, a blog, and an active forum dedicated to helping users with their Excel issues.
Ken will have joint session with Gasper Kamensek titled: All You Need is Excel (and little Power BI)
In this presentation we’ll see how the analyst can build a dimensional model and securely share it with someone for further analysis. So far so good, but what happens when the analyst realizes that he doesn’t have enough information to complete the job? Join Ken and Gašper to see how Excel, Power BI (and comedy) come together!
In this session we’ll look at how the M coding language can be used to: Save steps in your queries Gracefully handle Load Errors Create Calendar Tables and Slowly Changing Dimensions Speed up Query Performance with Table.Buffer
What is Dimensional Modeling and why should you care? The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years. There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it […]