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 modellers 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
• Diagnosing the issues behind the irritating “Relationships May Be Needed” error when building a Power Pivot-based PivotTables
• Viewing queries by load destination and changing multiple query load destinations at one time
• Injecting dynamic parameter tables and dynamic calendars into your data model with only a few clicks
• 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!
While we won’t be able to show all the functionality in one single meetup, you’ll get a good understanding of how this tool can help make your data modelling life easier!
