Kickstart your career by upgrading your #BusinessIntelligence and #DataAnalytics skills! It’s our biggest sale ever on all our courses. ☀️ 50% off on-demand courses with code: SUMMER50.☀️ 30% off premium coached courses with code: LEARN30. View courses:

With over 2,300 students trained, people love our Power Query Academy! ⭐️⭐️⭐️⭐️⭐️. Ready to focus on the #DataAnalysis that you were actually hired for? Learn the secret of #PowerQuery in #Excel and #PowerBI! 📊🔍. Go to and use code SUMMER50 to save 50%

Ever wanted to grab a single data cell from your #PowerPivot model? Tired of setting up an entire #PivotTable and using GETPIVOTDATA? @kpuls shows how to quickly convert your Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints!👋

Revolutionize your data game!💡 Join our Power Query Academy and streamline data manipulation in #Excel and #PowerBI! Discover the benefits of mastering #PowerQuery – efficiency, accuracy, and a skill set that stands out!. Use code SUMMER50 to save 50%:

We want to make sure that all #SelfServiceBI Academy members have the necessary background skills in #Excel, so access to our Excel Fundamentals Academy is now included with all SSBI registrations! 🥳. And right now you can save 30% with code LEARN30:

This definitely one of our favourite #PowerQuery functions!.

In an 'Ask Ken' session, someone asked, “How can I add aging to my Power Pivot model?” Well, here's a Pivot Table with AR transactions summarized by days outstanding. Wish you had this kind of help? Join the #SelfServiceBI or #Excel Fundamentals Academies:

Explore the realm of #BusinessIntelligence with @kpuls' Academy. 📈 Whether you're a #DataAnalytics beginner or looking to enhance your #Excel and #PowerBI skills, this course is for you!. Register now to save 30% with code LEARN30: #DataModel

This happy student has been subscribed to @kpuls' #SelfServiceBI Academy for almost 4 years! 🥰.What sets this training apart from other online courses? It's the live 'Ask Ken Anything' hosted twice each month. Until Aug 30, save 30% with code LEARN30:

Did you know that an official #Excel table (Ctrl + T) can be set up to have a single cell? 🤓 In this video, @kpuls shows you how this is done, as well how it can be used to read data into and out of #PowerQuery: #DataAnalysis #BusinessIntelligenceTools.

📊 Dive into the world of #BusinessIntelligence in our #SelfServiceBI Academy. @kpuls provides hands-on experience using #Excel and #PowerBI to create insightful reports and dynamic dashboards. Kickstart your learning journey, use code LEARN30 to save 30%:

A while back, @kpuls got an email from someone asking how to create a running total. 🎯 Ken tackled a simplified scenario that calculates running totals using the #PowerQuery List.Accumulate() function: #Excel #PowerBI #DataAnalytics #BusinessIntelligence.

Now’s the perfect time to take your #BusinessIntelligence and #DataAnalytics skills to the next level! Until Aug 31, you can save on all our courses!.☀️ 50% off on-demand courses with code: SUMMER50.☀️ 30% off premium coached courses with code: LEARN30.See

Looking to expand your #DataAnalytics skills and build your #BusinessIntelligence toolkit? 🧰. 👀 Keep your eyes peeled starting tomorrow for our BIGGEST SALE EVER!. #DataModeling #DataAnalysis #DataVisualization #PowerBI #Excel #DAX #PowerQuery #DataInsights

If you're subscribed to our newsletter, time to check your inbox for the June edition! 📬.If you're not subscribed, sign up at You'll get our monthly round-up of expert content, plus info on courses, events, and specials, and our free #PowerQuery eBook.

In this Monkey Shorts video, @kpuls combines 3 tricks:.⭐️An alternate use for last week's Dev/Prod switch.⭐️Referring to previous step names.⭐️Building a filter to remove a dynamic number of rows from the top of the data set. #PowerQuery #Excel #PowerBI.

Following @kpuls' article we recently shared on merging tables in #PowerQuery using Outer joins, in this one Ken looks at the remaining 3 options:.👉 Inner join.👉 Left Anti join.👉 Right Anti join.Let's explore them: #PowerBI #Excel #DataAnalytics.

At the core of every good #PowerPivot or #PowerBI solution is the #DataModel. But do you really know how to work with it properly? 💻Our on-demand #DimensionalModeling course will teach you the right way to build solid and scalable models. Sign up today at

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

If you work with large data sets in #PowerQuery, you'll know the pain that comes with waiting on query previews to refresh. ⏳ @kpuls has a strategy to quickly flip between a smaller and larger data set so that you can develop with speed: #Excel #PowerBI.