Grilled Cheese

ExploreLog inSign up
Terms of UsePrivacy PolicyCommunity StandardsHelpGet the app

Grilled Cheese is a product of Village Compute

Version devBuilt at: 2026-10-16 19:33:48 EDT

PhotosVideosAllPeople
LatestRanked
@excelguru.caSep 23, 2026, 6:09 PM

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

#PowerQuery #DataAnalytics #BusinessIntelligence

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 QuerySleuth dialog with a listing of available queries highlighted with the corresponding lading destination colour) monkeytools.ca
@excelguru.caSep 21, 2026, 5:37 PM

We had an awesome time at last week's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates went over some of the newest updates to Power BI, and then Melissa De Korte presented a deep dive into #PowerQuery for solving more advanced text-splitting challenges.
🎦 www.youtube.com/watch?v=yH6Z...

@skillwave.trainingSep 21, 2026, 4:05 PM

Here's a must-know #PowerQuery technique to unpivot data easily in #Excel (and #PowerBI). 🙌 @excelguru.ca shows how to convert a human-friendly report layout into a clean tabular format that works beautifully for #PivotTables and #BusinessIntelligence: www.youtube.com/watch?v=KKKZ...

@mikhail-mikushin.bsky.socialSep 20, 2026, 8:01 AM

How to use Python in Power Query transformation #data #dataanalytics #Python #PowerQuery #PythonTransform

@excelguru.caSep 18, 2026, 4:32 PM

Ever discovered errors in your data after unpivoting? 😬 Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which contained errors? 😉 Join me to find out: www.youtube.com/watch?v=sJaX...

#PowerQuery #Excel #PowerBI

@skillwave.trainingSep 18, 2026, 4:19 PM

Subscribing to the "Ask Ken Anything" sessions is like having a personal consultant on call for just a fraction of the cost! ☎️ Join @excelguru.ca for his live, interactive support calls held twice each month for personalized help with #Excel, #PowerQuery, #DAX and more.
Sign up at skw-t.com/aka

Get help with all of your business Intelligence questions & challenges from world-class expert Ken Puls (Image of a man sitting at a desk wearing headphones and waving at their laptop screen, inset headshot of Ken Puls) Ask Ken Anything Live Coaching Sessions Direct coaching and support in Excel, Power BI, Power Query, DAX, Data Modeling, and more in our live, twice-monthly calls! Join Today! (Skillwave Training logo) skillwave.training
@skillwave.trainingSep 17, 2026, 4:44 PM

Ever discovered errors in your data after unpivoting? 😬 Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which contained errors? 😉 Join @excelguru.ca to find out: www.youtube.com/watch?v=sJaX...

#PowerQuery #Excel #PowerBI

@excelguru.caSep 17, 2026, 4:11 PM

Today's Vancouver #PowerBI and Modern #Excel meet-up gets underway at 12pm. 🕛 Joseph Yeates will first show us some of the latest and greatest in Power BI. Then, Microsoft MVP Melissa de Korte will explore cool ways to split our data using #PowerQuery. 🤓
RSVP here: www.meetup.com/vancouver-po...

@excelguru.caSep 16, 2026, 4:15 PM

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
@skillwave.trainingSep 15, 2026, 4:21 PM

This is the most popular of @excelguru.ca's video blogs on our YouTube channel, so we wanted to reshare it. He tackles a real-world question from a #SelfServiceBI Academy student: how do you reliably identify price changes over time using #PowerQuery? 🤔
Ken explores 3 methods: youtu.be/vu0HbLJisO4

@excelguru.caSep 14, 2026, 4:31 PM

Learn how to unpivot data easily using #PowerQuery in #Excel (and #PowerBI). 🙌 In this video, I convert a human-friendly report layout into a clean tabular format that works beautifully for #PivotTables and #BusinessIntelligence: www.youtube.com/watch?v=KKKZ...

@goatshipmate.bsky.socialSep 14, 2026, 10:51 AM

Is anyone else, especially non-US folk, finding that #PowerQuery is not giving the right answers for Date.DayOfWeek()?
The documentation seems to say that Sunday is 0.

I'm realising it's worth making sure you are getting what you think you are by writing
Date.DayOfWeek(CurrentDate, Day.Sunday)

Photo, no description
@skillwave.trainingSep 11, 2026, 4:32 PM

Save yourself hours of time and effort when preparing your data in #Excel or #PowerBI with #PowerQuery. 😎 You'll master #DataCleaning and transformation so you can automate your #BusinessIntelligence, and spend more time exploring #DataInsights. 👍Sign up for our FREE intro course: skw-t.com/pqfun

Discover the many uses for Power Query with our free video course (Skillwave Training logo) Power Query Fundamentals for Excel and Power BI (Image of a woman in side profile, sitting at a table and working on a laptop)
@excelguru.caSep 11, 2026, 4:20 PM

By default, when you unpivot a set of data in #PowerQuery, all null records are suppressed. But what if you need them in your unpivoted data set? 🙉 In this Monkey Shorts, I show 2 methods of doing so and discuss the impacts of each: www.youtube.com/watch?v=-j_q...

#Excel #PowerBI #DataAnalysis

@skillwave.trainingSep 10, 2026, 4:06 PM

By default, when you unpivot a set of data in #PowerQuery, all null records are suppressed. But what if you need them in your unpivoted data set? 🙉 In this Monkey Shorts, @excelguru.ca shows 2 methods of doing so and discusses the impacts of each: www.youtube.com/watch?v=-j_q...

#Excel #PowerBI

@skillwave.trainingSep 8, 2026, 5:03 PM

Hey subscribers, time to check your inbox as the newsletter has been sent! 📫
If you'd like to keep on top of what's new in #Excel and #PowerBI, the latest expert content, and info on our courses, events and specials, join our mailing list at skw-t.com/news. Plus, get a free #PowerQuery eBook.📗

News from the Data Monkey Brought to you by Excelguru and Skillwave (Image of a cyborg monkey in a superhero style crouch) September 8, 2026 In This Issue: - From the AKA Sessions - New video blog on using dynamic parameters - Monkey Tools Updates - What's New in Excel - Latest Meet-up Recording and Next Event Information - Upcoming Courses and Conferences - Available Training Options It's "back to school" time here on the West Coast of Canada, and we're all settling into the regular routines again. Ken is looking ahead to leading both in-person and online training for various groups this fall. However, he still has some availability through to the end of year, if you're looking for some private training for your group. Information on how to book a session can be found at the bottom of the newsletter.
@ilgarz.bsky.socialSep 7, 2026, 8:28 PM

We are pleased to welcome Chris Webb, Principal PM at Microsoft, as one of the speakers at Data & AI Day Baku 2026.
📅 8 October 2026
🕘 9:00 AM
📍 Baku, Azerbaijan
👉 Explore the event and register here:
www.meetup.com/azdata-aicom...
#DataAIDayBaku #ChrisWebb #PowerQuery #PowerBI #MicrosoftFabric

Photo, no description
@skillwave.trainingSep 7, 2026, 4:30 PM

Here, @excelguru.ca shows how Monkey Tools' Parameter Table and Function feature automatically adds the fnGetParameter() function and required parameter table setup into your #Excel workbook, making your #PowerQuery solutions easier to move, update, and maintain: www.youtube.com/watch?v=Y0lV...

@excelguru.caSep 7, 2026, 4:06 PM

A question came up in a recent AKA session about a tool built to automatically pull files from a folder for a client project using #PowerQuery. It worked perfectly on the developer's own machine, but broke the moment it landed on the client's system. 😧
I walked through the likely culprit. 🧵

The One-Letter Typo That Brok a Whole Workflow (Image of a man sitting at a desk with his head down on his arm in front of his laptop) (Skillwave Training logo)