Ken Puls, FCPA, MS MVP

📊 Take the first step towards becoming a #BusinessIntelligence expert by enrolling in this hands-on #PowerBI training at @skillwave.training. Join now for a transformative learning journey covering #PowerQuery, #DAX, and reporting. Use code SUMMER50 at checkout to save 50%: skw-t.com/pbiba50

Advanced Data Cleaning with NEW Regex Functions in Excel | Sumit Bansal, Thu, Aug 7, 2025, 9:00 AM | Meetup **SESSION TRACK:** Excel **SESSION OUTLINE:** In this session, Microsoft MVP Sumit Bansal will show us how the new Regex functions in Excel can be a powerful tool when it

An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Microsoft MVP Sumit Bansal will show us how the new Regex functions in Excel can be a powerful tool when it comes to #DataCleaning 🧹 even if you've never used Regex before.
Sign up here:

While it's always been possible to create a table from #PowerPivot-backed data models, it has required some black magic and #DAX knowledge to make it happen. The DAX Table Monkey in our Monkey Tools #Excel add-in builds it for you with just a few clicks. 🐵 Learn more about it at mkyt.ca/daxtable.

Kickstart your career by upgrading your #BusinessIntelligence and #DataAnalytics skills! It’s our biggest sale ever on all our @Skillwave.Training courses.
☀️ 50% off on-demand courses with code: SUMMER50
☀️ 30% off premium coached courses with code: LEARN30
View course catalog: skw-t.com/summer2025

Learning is great, applying it is even better! My #SelfServiceBI (skw-t.com/ssbi) and #Excel Fundamentals (skw-t.com/excelfun) Academies @skillwave.training provide access to live AKAs. We help you apply the course material to your real-world scenarios. Save 30% in either if you use code LEARN30.

That’s exactly what happened in a recent Ask Ken Anything session, where we converted each query into a custom function chain which could be applied to each file in the list. 😄

You’ve worked hard to build a set of queries in #PowerQuery to import and clean up a single file in a specific way. Now you want to apply them to each file in a folder but they’re way too complicated to roll into a single Sample Transform. What do you do? 😱

YouTube video by Curt Frye Multiple drivers with different starts

My newest weekly YouTube video extends my Traveling Salesman Problem analysis to multiple routes where the drivers start at different locations. The techniques shown here will be useful for businesses with multiple warehouses or locations! youtu.be/lLdYntM9ZEg

Excel with Copilot: Your AI-Powered Excel Partner | Puneet Gogia, Thu, Sep 4, 2025, 9:00 AM | Meetup **SESSION TRACK:** Excel **SESSION OUTLINE:** In this session, we’ll get hands-on with using Co-Pilot in Excel with blogger and trainer, Puneet Gogia. We’ll explore how to

At our Vancouver #PowerBI and Modern #Excel meet-up on Sept 4, we’ll get hands-on with using #Copilot in Excel with Puneet Gogia. We’ll explore how to write formulas, create #PivotTables, and build charts to analyze and present your data more effectively. RSVP here:

Struggling to create complex financial statements in #Excel? 😓 In this advanced course, I'll guide you through every step and key #DAX patterns behind building everything from P&L measures to Statement of Cash Flows.

Enroll now and save 50% with code SUMMER50. Go to skw-t.com/buildfs50

If you build #FinancialStatements in #Excel, this is the course for you! I'll guide you through every step in the process of creating a full set of accounts and reports from raw data, leveraging #PowerQuery, #DAX, and #PowerPivot.
Until Aug 31, save 50% with code SUMMER50 - go to skw-t.com/buildfs50

When converting an OLAP backed Pivot Table (like Power Pivot) into CUBE formulas, any field in the "Filters" section will pop a message asking if you'd like to convert the Filters or not. Do you… Converting Filters to CUBE Formulas - Monkey Shorts Episode 034

When converting an OLAP backed PivotTable (like Power Pivot) into CUBE formulas, any field in the "Filters" section will pop a message asking if you'd like to convert the Filters or not. Do you know which option to choose? 🤷 Let's look at the difference between the 2:

Recently, I helped add aging bands to a student's data. But what if you also want to add the total invoice count to the report and show it just once, not by each band? In an AKA session, I showed why sometimes a collection of measures can add flexibility that you can’t get from a data column alone.

🚨Today's the last day for early bird pricing on my #SelfServiceBI Boot Camp in Munich! This live, hands-on training will equip you with practical, scalable techniques to turn raw data into meaningful insights and make better decisions for your organization. Register today at xlguru.ca/ssbi-munich

#PowerPivot in #Excel has incredible potential for #FinancialAnalytics, and I'll show you how to unlock it! Master the art of building financial statements, balance sheets, and more. Enroll today and level up your #FinancialAnalysis skills. 💲 📈
Use code SUMMER50 to save 50%: skw-t.com/buildfs50

The latest edition of our newsletter has just gone out to our subscribers! 📧

If you'd like to stay up-to-date on what's new in #Excel and #PowerBI, plus info on available courses, events, and specials, sign up today at xlguru.ca/newsletter. You'll also receive our free 'DIY BI' eBook series.

Converting a classic #Excel PivotTable to a Power Pivot-based #PivotTable actually takes a lot of work to load the #DataModel, recreate the calculations in #DAX, and then rebuild the pivots. 😔

The Modern Pivot Monkey takes care of all of this for you! 😎 Learn more about it at mkyt.ca/modernpivot

Want to get more from your data and expand your career options? Save on all our #BusinessIntelligence and #DataAnalytics courses at @skillwave.training until Aug 31, 2025.
☀️ 50% off on-demand courses with code: SUMMER50
☀️ 30% off premium coached courses with code: LEARN30
Go to skw-t.com/summer2025

What's New in Excel (July 2025) | Microsoft Community Hub PivotTable auto refresh is now available for Windows and Mac Insiders, new Power Query capabilities for Web users, and more in this month's What's New.

I'm super stoked to see that auto-refresh for PivotTables is now available for Insider users. Save yourself the "click tax" - no more having to hit Refresh twice! 🥳

Read more about it, and see what else new in #Excel this month: techcommunity.microsoft.com/blog/excelbl...

I know not everyone is going to want to do this, but something I find really helps me understand complex calculations or visuals is to manually replicate the values and then validate the output. For fun, let’s build a quick Box and Whisker chart and prove it out: excelguru.ca/proving-exce...

YouTube video by Skillwave Training Manage Change in Power BI Reports & Semantic Models with Git | Scott Stauffer

If you weren't able to join us in-person or online for last week's Vancouver #PowerBI and Modern #Excel meet-up, here's the recording: www.youtube.com/watch?v=BbCS....
TY again to Joseph Yeates for showing what's new in PBI, and @sqlsocialite.bsky.social for sharing his PBI version control solution.

Global Excel Summit is bringing back my 3-day in-person #SelfServiceBI Boot Camp! ✈️ This October, I'll be flying to Munich to equip you with practical, scalable techniques to turn raw data into meaningful insights. 💡 Now’s the time to secure your seat and save 20% at xlguru.ca/ssbi-munich

DAX is the key to unlocking the #DataModeling and #DataAnalytics power of #PowerBI and #PowerPivot for #Excel. In this hands-on @skillwave.training course, you'll learn the concepts and techniques to write powerful #DAX measures. 💪

Until Aug 30, save 50% with code SUMMER50 at skw-t.com/superpbi50

Power BI Mixtape: Vol. 2 | Joseph Yeates, Thu, Aug 21, 2025, 9:00 AM | Meetup **SESSION TRACK:** Power BI **SESSION OUTLINE:** Power BI is turning 10 — and what better way to celebrate than by looking at how far it’s come? In this session, our resid

🥳🎂 #PowerBI is 10 — and what better way to celebrate than by looking at how far it’s come? On Aug 21, Joseph Yeates will spotlight features that once required complex workarounds but are now built right into the tool. Sign up here to join us starting at 9am PDT: www.meetup.com/vancouver-po...

Here's a potential "gotcha" that can happen when converting an #Excel #PivotTable into CUBE functions: the array formula. These show up when you have multiple fields in your dimensions, and are confusing to users who are not used to them. See how to identify and break an array: buff.ly/Ey5Qhg7

I'm a big fan of building Box and Whisker Charts (also known as Box Plots to those in the statistics world) to interpret certain data sets, particularly for charting #PowerQuery refresh times. 👉 In this article, I show how to create one: excelguru.ca/building-a-b...

#DataVisz #DataAnalytics #Excel

Manage Change in Power BI Reports & Semantic Models with Git | Scott Stauffer, Thu, Jul 24, 2025, 10:00 AM | Meetup ***\*\*NOTE:*** *This meeting we are partnering with the new Vancouver Microsoft Data Platform Professionals Meetup. VMDPP will provide an in-person experience, and VanPUG

There's still time to RSVP for the online portion of today's Vancouver #PowerBI and Modern #Excel meet-up! 💻 Joseph Yeates go over what's new in Power BI. Then, Scott Stauffer will show us how to manage version control in Power BI using Git and the .pbip file format. Sign up here:

Transform your data into actionable insights! Learn #DAX from the ground up with hands-on practice and expert guidance from Matt Allington. Enroll today through @skillwave.training and level up your #DataAnalytics and #PowerBI game. 🦸‍♀️

Use code SUMMER50 at checkout to save 50%: skw-t.com/superpbi50

We're very proud of our Monkey Tools add-in, and love hearing from our 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 #DataAnalytics #DataAnalysis #Excel

Kickstart your career by upgrading your #BusinessIntelligence and #DataAnalytics skills! It’s our biggest sale ever on all @skillwave.training courses!
☀️ 50% off on-demand courses with code: SUMMER50
☀️ 30% off premium coached courses with code: LEARN30
See course catalog at skw-t.com/summer2025