Build Better Excel BI Models Faster with Ken Puls @ExcelExciting
Build Better Excel BI Models Faster with Ken Puls  @ExcelExciting
Uploaded December 2020 | Updated November 2026, 5 days ago
This is the first live meetup for Saudi Arabia, Microsoft Excel & Power Platform.
Ken Puls was 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.
Download Monkey Tools :
xlguru.ca/monkeytools
ExcelExciting.com/resources
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup

00:00 Getting Ready
01:03 Introduction
04:50 Meeting Agenda
05:50 About the speaker
07:16 Connect with the speaker
08:45 Build Better Excel BI Models
10:43 My Modelling Philosophy
12:40 About Monkey Tools
15:32 The Monkey Tools Ribbon
16:54 Demo
18:03 Query Monkey
18:10 Connecting Excel Tables With Query Monkey
22:00 Query Sleuth In Monkey Tools
24:15 Create Calendar Table with Query Monkey
28:45 Create PivotTable with Monkey Tools
30:24 Create DAX Measures with Monkey Tools
33:46 Store DAX Measures with Monkey Tools
38:11 Create Parameter Table with Monkey Tools
39:49 Smart Folder Function in Monkey Tools
40:10 Smart Folder Query in Monkey Tools
46:49 Destination Sleuth in Monkey Tools
52:55 Time Sleuth in Monkey Tools
1:02:10 Pivot Sleuth in Monkey Tools
1:08:38 View Complex Model with Pivot Sleuth in Monkey Tools
1:09:18 DAX Sleuth in Monkey Tools
1:12:50 Model Summary Report in Monkey Tools
1:16:05 Model Memory Usage Report in Monkey Tools
1:16:34 Unused Items Report in Monkey Tools
1:16:59 Real world consulting project
1:20:00 Reviewing the Model Summary Report
1:21:50 Connecting Power BI Files to create Model Summary in Excel Workbook
1:24:46 Log a bug & feature suggestion in Monkey tools
1:25:20 Question & Answer
1:30:32 Monkey Tools Resources
1:32:30 Session Wrap-up

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!
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk

📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting

👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
Connect Ken Puls
facebook.com/xlguru
YouTube.com/KenPulsXLGuru
linkedin.com/in/kenpuls
twitter.com/kpuls
meetup.com/Vancouver-Power-BI-User-Group
***********************************************************
#FarazShaikh #KenPuls #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Build Better Excel BI Models Faster with Ken PulsCreate Month-Year from Dates in Seconds! Excel Power Query (Mac/Windows)Move the Grand Total to the left or to the first column in Excel PivotTableCleaning Data in Excel: Functions Every Analyst Should Know with Hidaya MegateliUnlock The Power Of Data Tables In Microsoft Excel! 📊Windows Trick# 11 - Change Mouse Pointer Color & Size In Windows 11 - #shorts  #mousepointer #tipsGet Instant Formula Results with the New Value Tooltip Feature (English)Hindi - StockHistory In Excel (mac & windows)Easily capture your work steps | Life Saver Free App very helpful during Covid-19Trick to Create A Data Entry Table In Power Query for ExcelLookup last matching value in the column (Excel - Mac & Windows)See the power of Power BI in 90 minutes: Marketing Dashboard with Power BI with Nurana Novruzova
Faraz Shaikh |

Build Better Excel BI Models Faster with Ken Puls

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER