#DataAnalyticsTools

2 months ago

Setting PivotTable Defaults - Monkey Shorts Episode 008 Not satisfied with Compact Form for your Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, Ken shows you how to modify…

Not satisfied with Compact Form for your #Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, I'll show you how to modify your #PivotTable defaults: www.youtube.com/watch?v=eCut...

#DataAnalyticsTools #BusinessIntelligence

1 0 0 0

2 months ago

Setting PivotTable Defaults - Monkey Shorts Episode 008 Not satisfied with Compact Form for your Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, Ken shows you how to modify…

Not satisfied with Compact Form for your #Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, @excelguru.ca shows you how to modify your #PivotTable defaults: www.youtube.com/watch?v=eCut...

#DataAnalyticsTools

1 0 0 0

2 months ago

Column Profiling in Power Query - Monkey Shorts Episode 005 In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.

In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence

2 0 0 0

2 months ago

Column Profiling in Power Query - Monkey Shorts Episode 005 In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.

In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence

2 0 0 0

3 months ago

One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002 Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.

Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this episode of Monkey Shorts, I'll show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...

#DataPreparation #DataAnalyticsTools #BusinessIntelligenceTools

0 0 0 0

3 months ago

One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002 Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.

Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this Monkey Shorts, @excelguru.ca will show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...

#DataPreparation #DataAnalyticsTools #BusinessIntelligence

0 0 0 0

4 months ago

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Query Sleuth Queries are colour coded to add a bit of extra insight. By default: - Yellow = Query is loaded as a "Connection Only" - Green = Query is loaded to the data model - Blue = Query is loaded to an Excel table - Orange = Query is loaded to both the data model and an Excel table (Screenshot of the Query Sleuth dialog with a listing of colour coded queries) monkeytools.ca

When you first open Query Sleuth in our Monkey Tools #Excel Add-in, you’ll notice that your queries are colour coded with up to four different colours: 🟠🟡🔵🟢 This adds a bit of extra insight around the query load destinations. Learn more at mkyt.ca/querysleuth

#PowerQuery #DataAnalyticsTools

1 0 0 0

4 months ago

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 Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.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

1 0 0 0

4 months ago

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth TreeView allows you to easily browse your queries. And you can quickly flip between showing precedents (the default view), dependents, or turn the tracking off entirely if needed. Plus, when looking at the M code of a query, any precedent queries are highlighted right in the code. (Screenshot of the TreeView in QuerySleuth with the various queries highlighted by colour code) monkektools.ca

🔎QuerySleuth is a must-have for every #PowerQuery user. Developed based on a real business need, we believe this form will add magic to your ability to trace query dependencies and precedents. And it does it all without locking your #Excel UI! Learn more: mkyt.ca/querysleuth

#DataAnalyticsTools

2 0 0 0

5 months ago

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with it's fist up for a fist bump) Customize the Monkey Tools Tab To add a custom group to our ribbon tab, right click any ribbon tab and choose Customize the Ribbon. This will launch an Excel Options screen, where you will need to: 1. Select the Monkey Tools tab on the right 2. Click New Group 3. Select the group 4. Click Rename... 5. Enter the name 6. Click OK Then you can add as many commands to the group as you like! (Screenshot of the Excel Options screen with the above-numbered items highlighted) monkeytools.ca

The Monkey Tools ribbon was designed with one goal in mind: to make you more efficient when building queries and/or data models. Learn how to customize or personalize the Monkey Tools tab at mkyt.ca/customtab

#Excel #PowerQuery #DataModeling #BusinessIntelligence #DataAnalyticsTools #DataAnalysis

2 0 0 0

5 months ago

Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! (Image of a cyborg monkey jumping up with eyes closed and right fist raised in celebration) Test in speech bubble: "I found the approach of taking each feature and explaining everything about it very helpful... I feel that I have walked away with a great understanding of all the features and how they can be used." Kevin Duke (5 stars) Register today at https://mkyt.ca/course

Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course at @Skillwave.Training where I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools #BusinessIntelligenceTools

0 0 0 0

6 months ago

Splitting Records with Power Query - Monkey Shorts Episode 040 In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.

In this episode of Monkey Shorts, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒
www.youtube.com/watch?v=3hPM...

#Excel #PowerBI #DataPreparation #DataAnalyticsTools

1 0 0 0

6 months ago

Splitting Records with Power Query - Monkey Shorts Episode 040 In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.

In this episode of Monkey Shorts, @excelguru.ca looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒
www.youtube.com/watch?v=3hPM...

#Excel #PowerBI #DataPreparation #DataAnalyticsTools

1 0 0 0

8 months ago

Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course available through our @skillwave.training site. I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools

0 0 0 0

8 months ago

(Image of 2 monkeys facing each other and reaching towards the centre, both sitting on a leaf) June 14 is halfway to International Monkey Day! Use this code to save 20% on an Annual or Lifetime Monkey Tools License: MONKEYAROUND Got to monkeytools.ca An Excel add-in by Excelguru (Excelguru logo) Valid June 13-20, 2025

Today is the last day of the "Halfway to Monkey Day" special on @excelguru.ca's Monkey Tools #Excel add-in. 🙉 You have until midnight tonight to save 20% on an Annual or Lifetime Pro license. Go to monkeytools.ca and apply code MONKEYAROUND

#BusinessIntelligence #DataAnalyticsTools #PowerQuery #DAX

1 0 0 0

8 months ago

(Image of 2 monkeys facing each other and reaching towards the centre, both sitting on a leaf) June 14 is halfway to International Monkey Day! Use this code to save 20% on an Annual or Lifetime Monkey Tools License: MONKEYAROUND Got to monkeytools.ca An Excel add-in by Excelguru (Excelguru logo) Valid June 13-20, 2025

Don't miss out - it's the last day of the "Halfway to Monkey Day" special on our Monkey Tools #Excel add-in. 🙉 You have until midnight tonight to save 20% on an Annual or Lifetime Pro license. Go to monkeytools.ca and add code MONKEYAROUND

#BusinessIntelligence #DataAnalyticsTools #PowerQuery #DAX

1 0 0 0

10 months ago

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? "I've been using Ken's Monkey Tools to manage my library of LAMBDA expressions, and it's made that part of my Excel so much easier to do. Totally recommend you do the same if you're an Excel power user." Patrick Matthews Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.ca

I 💙 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

#Excel #PowerQuery #DAX #DataAnalyticsTools #DataAnalysis #BusinessIntelligence

1 0 1 1

10 months ago

What is Power Query?

#PowerQuery is a data connection technology that enables you to discover, connect, combine, and refine data sources for #DataAnalysis. It add ETL capability to #Excel and #PowerBI. 💪 Start learning today with our FREE introductory course: skw-t.com/pqfun

#DataAnalyticsTools #DataPreparation

1 0 0 0

1 year ago

Using Monkey Tools course review by John Garnier: "Honestly - it's just so impressive. So many moments of 'Wow', or 'That's Awesome". Favorite sections were the Biblio Monkey and the slowly changing dimension." 5 stars

Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course at @skillwave.training. I explain all of the different tools and features that will help with your #DataModeling: buff.ly/S5AqNSK

#ExcelTools #DataAnalyticsTools

0 0 0 0

Column Profiling in Power Query - Monkey Shorts Episode 005 In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.

1 year ago

In this Monkey Shorts episode, I show how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use. Watch on YouTube: https://buff.ly/4fHhaMD

#Excel #PowerBI #DataAnalysis #DataAnalyticsTools

0 0 0 0

1 year ago

Column Profiling in Power Query - Monkey Shorts Episode 005 YouTube video by Skillwave Training

In this Monkey Shorts episode, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use. Watch on YouTube: www.youtube.com/watch?v=QtOw...

#Excel #PowerBI #DataAnalysis #DataAnalyticsTools

2 0 0 0

1 year ago

The Monkey Tools ribbon was designed with one goal in mind: to make you more efficient when building queries and/or data models. But what if you want to customize or personalize the Monkey Tools tab? Learn how at mkyt.ca/customtab

#Excel #PowerQuery #DataModeling #DataAnalyticsTools #DataAnalysis

2 0 0 0