Skillwave Training
banner
skillwave.training
Skillwave Training
@skillwave.training
Your #1 resource for online training on Power BI, Power Query, Power Pivot, and Excel. View our course catalog at skillwave.training/learn
These kinds of advanced patterns that surface organically in AKA sessions, because they come straight from real project pain .
Enroll in our #SelfServiceBI (skw-t.com/ssbi) or #Excel Fundamentals (skw-t.com/excelfun) Academy and gain to live AKA sessions where we help you solve your own scenarios.
Self Service BI Academy
Prepare to change your company's reporting game forever! In the Self Service BI Academy, Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI…
skw-t.com
January 28, 2026 at 5:18 PM
Pricing tiers, effective dates, contract terms, and rules often depend on several inputs at once. The modifications Ken made embraced that reality – and kept the model performant and readable. Strong models match on logic, not just keys.🔑

#DataModeling #DataAnalytics #Excel #PowerBI
January 28, 2026 at 5:18 PM
Instead of forcing fragile formulas or stacking lookups, ranges, thresholds, and multiple attributes can collectively drive the match in a clean, scalable way.
The big “aha” for many attendees was realizing that – like recipes in the kitchen – you may need to add or substitute an ingredient or 2. 👨‍🍳
January 28, 2026 at 5:18 PM
🧭Takeaway: In Power Query, being clever isn’t always efficient.
Courses are good. Personalized help is better. Our Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academy students get access to sessions where we troubleshoot, clarify, and apply learning to real projects.
Excel Fundamentals Academy
In the Excel Fundamentals Academy, you’ll learn all the core skills for the Excel analyst, beginning with a refresher on Excel formulas and functions (including the daunting VLOOKUP), and then moving…
skw-t.com
January 20, 2026 at 6:06 PM
Ken walked through why this happens and demo'd faster, cleaner alternatives – like merging a table to itself using offset index columns, or using a simple Group By when prices only increase.
The lesson wasn’t just about speed, it was about knowing what NOT to do before it bites you in production. 🚀
January 20, 2026 at 6:06 PM
Don’t just watch a video and hope you “get it.” Our #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies come with access to AKA sessions - live support where we guide you through applying what you’ve learned. Or sign up for the AKAs on their own at skw-t.com/aka
Excel Fundamentals Academy
In the Excel Fundamentals Academy, you’ll learn all the core skills for the Excel analyst, beginning with a refresher on Excel formulas and functions (including the daunting VLOOKUP), and then moving…
skw-t.com
January 14, 2026 at 5:22 PM
Ken walked through the cost of maintaining fragile #PowerQuery solutions and why, in some cases, a controlled manual step is actually the smarter, safer choice. #DataAutomation should reduce risk, not create it.
🧭Takeaway: Expertise isn’t just about knowing HOW to automate, but knowing when NOT to.
January 14, 2026 at 5:22 PM
They aren’t structured data. They’re visual layouts that shift month to month as the engine attempts to interpret them, page to page, even transaction to transaction. What works one month can quietly fail the next.
That led to an important teaching moment: not every problem deserves automation. 🚫️
January 14, 2026 at 5:22 PM