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-11 02:37:10 EDT

Explore

PostsPeople
LatestRanked
@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)

@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

@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)