Build Better Excel BI Models Faster

Ken Puls will be demonstrating how Excelguru's Monkey Tools add-in can help you build better Excel BI models faster, and audit models that you receive from others. Monkey Tools is targeted at modelers and analysts who work primarily in Excel, but also push their models into Power BI.

The broad set of features included in Monkey Tools will help you deal with things like:
• Creating Data Model connections for all Excel tables in seconds
• Injecting dynamic parameter tables and dynamic calendars into your data model with only a few clicks
• No-code creation of basic EXPLICIT Power Pivot measures
• Diagnosing the issues behind the irritating “Relationships May Be Needed” error when building a Power Pivot-based PivotTables
• Tracing query and DAX dependency trees
• Indenting both M and DAX queries
• Timing your query refresh speeds
• Documenting your Excel or Power BI based models
• And more!

About the Speaker

Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world.

In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. Learn more about Ken at www.excelguru.ca and https://linkedin.com/in/kenpuls, and follow him on Twitter (@kpuls) and Facebook (@xlguru).

LinkedIn: https://www.linkedin.com/in/kenpuls/
Website: https://www.excelguru.ca
Blog: https://www.excelguru.ca/blog
YouTube: https://www.youtube.com/c/KenPulsXLGuru
Twitter: @kpuls
Facebook: @xlguru
Meetup: https://www.meetup.com/Vancouver-Power-BI-User-Group