#PowerQuery#MonkeyTools
LightNews LightNews
excelguru.ca
Just used monkeytools.ca SCD2 Monkey to set up a Type 2 Slowly Changing Dimension for a data model... and it is taking me longer to write this message than it did to make it happen. Damn... I impress myself sometimes! 🤣 #MonkeyTools #Excel #PowerQuery #PowerPivot #UnleashAMonkeyToday
What is Monkey Tools?
Monkey Tools is an Excel add-in which will help you build better Data Models, faster. Our Free version contains a ton of useful tools, but you'll be truly amazed at how much productivity you can gain ...
monkeytools.ca
August 20, 2024 at 11:23 PM
excelguru.ca
We're very proud of our Monkey Tools add-in, and love hearing from happy users! ❤️
Monkey Tools contains a set of tools to help you build better data models more quickly and follow #DataModeling best practices. Learn more about it at monkeytools.ca

#PowerQuery #DAX #DataAnalyticsTools #DataAnalysis
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) What do people think of Monkey Tools? "Monkey Tools is by far the best Excel Add-in available. Ken Puls has designed miracles for Power Query and Power BI. If you thought those 2 tools were great, just wait until you try them WITH Monkey Tools. You will never go back!" Sherry Barnes-Fox (headshot of Sherry) Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.ca
September 16, 2026 at 4:15 PM
excelguru.ca
When #DataModeling in #Excel, do you prefer to create a separate (disconnected) table for measures? Get the Measure Table Monkey to do it! Just provide a table name, click OK, and then hide a column. Learn more: mkyt.ca/measuretbl
#PowerQuery#MonkeyTools
Monkey Tools: Build better data models, faster Developed by Excelguru Measure Table Monkey: Many modelers like to store their measures on a single "Measures" table in the data model. If you're one of them, you may appreciate the ability to quickly add a disconnected measure table to your date model for this purpose. Thanks to the Measure Table Monkey, this is quite easy!!
March 12, 2025 at 4:16 PM
excelguru.ca
By default, #MonkeyTools' Query Sleuth displays every query in your solution in the navigation Treeview. 🌳 But if you have a complex solution, the Treeview can get quite busy. This is where the “End Points Only” option helps. Learn more about Query Sleuth at mkyt.ca/querysleuth.

#Excel #PowerQuery
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth's "End Points Only" Option This option suppresses any queries which have no precedents or dependents. It can be very useful for eliminating noise, as well as tracing Connection Only queries that are not used at all. (Screenshot of the QuerySleuth dialog with the End Points Only option selected and two queries highlighted. A note says: Since "End Points Only" is checked, these two Connection Only queries are not referenced by anything and can therefore be removed.) monkeytools.ca
January 21, 2026 at 5:12 PM
excelguru.ca
By default, #MonkeyTools' Query Sleuth displays every query in your solution in the navigation Treeview. 🌳 But if you have a complex solution, the Treeview can get quite busy. This is where the “End Points Only” option helps. Learn more about Query Sleuth at mkyt.ca/querysleuth.

#Excel #PowerQuery
Monkey Tools Build better data models, faster Developed by Excelguru (Image on right of a cyborg monkey with its arm up for a fist bump) QuerySleuth's "End Points Only" Option This option suppresses any queries which have no precedents or dependents. It can be very useful for eliminating noise, as well as tracing Connection Only queries that are not used at all. (Screenshot of the QuerySleuth screen highlighting Connection Only queries and text saying: Since "End Points Only" is checked, these two Connection Only queries are not referenced by anything and can therefore be removed.
April 16, 2025 at 4:09 PM
excelguru.ca
Often, the reason we are trying to trace a query’s dependency chain is because we need to make a change to a child query, and want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right in the editor, without opening #PowerQuery! 🤯 Learn more: mkyt.ca/querysleuth
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Editing Queries with Query Sleuth The Formula window supports editing and writing back to Power Query, without ever opening the Power Query editor. You can also "pin" your query, allowing you to make changes to multiple queries. (Screenshot of the QuerySleuth dialog with part of a query highlighted in the editor area) monkeytools.ca
December 31, 2025 at 5:04 PM
excelguru.ca
Often, we trace a query’s dependency chain because we need to make a change to a child query, and want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right within the editor, without ever opening #PowerQuery! Learn more: buff.ly/TZrROfZ
Monkey Tools Build better data models, faster Developed by Excelguru Editing Queries with Query Sleuth: The Formula window supports editing and writing back to Power Query, without ever opening the Power Query editor. You can also "pin" your query, allowing you to make changes to multiple queries.
March 19, 2025 at 4:55 PM