Skillwave Training

See why students love our flagship #PowerQuery course! 🥰 We'll help you unlock the true power of your data with Power Query in #Excel and #PowerBI! Say goodbye to hours of manual #DataManipulation and hello to quick #DataInsights and informed decisions. skw-t.com/pqa

It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using PQ. In this video, @kpuls will give you some alternate methods of interacting with Excel: youtube.com/watch?v=bKBeRC…

Ever filtered an #Excel #PivotTable and noticed that dates with no sales suddenly disappear?😟 A student asked @kpuls: "Do I need to write a complicated #DAX measure to keep empty dates visible in my report?" The good news: you don’t!😀 Here's what you do: youtube.com/watch?v=jhc_L2…

Our latest newsletter is hitting inboxes right now!📧 If you'd like to stay up-to-date on what's new in #PowerBI and #Excel, content from our experts, and information on courses, events, and promotions, sign up at skw-t.com/news. We'll also send a free #PowerQuery eBook.

In our last Ask Ken Anything session, one of our students asked a fantastic question: how do you replicate a dynamic chart highlight in #Excel - one that visually flags the minimum, maximum, and neutral data points - when working inside #PowerPivot with #DAX measures?

Most people create columns one by one in Power Query. But you don’t have to. You can write all the logic inside a single record, expand it once, and get multiple columns in one go. Cleaner, faster, and much easier to manage. P.S. - Hyderabad folks, I’m in town and doing an in-person meetup tomorrow, 21st Mar 11 AM at Café Coffee Day, Sarath City Capital Mall. If you’re around, come say hi. I always enjoy these meetups because everyone brings different experiences and perspectives, and the conversations are always worth it 😀 See you there!

Unlock the power of #DimensionalModeling by learning the right way to build solid and scalable Data Models in #Excel and #PowerBI. 💪 This on-demand training brings together #PowerQuery and the #DataModel for powerful #BusinessIntelligence. ➡️Enroll today: skw-t.com/modeling

Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎 @kpuls and the Data Monkey will show you how in this latest episode of Monkey Shorts! youtube.com/watch?v=PazQmz… #Excel #PowerBI #DataAnalyticsTools

Do you know what a query language is? 🤔 It's a programming language that allows you to send a request to a database and then receive data back in the form of a table. Here, Matt Allington introduces the #DAX query language in #PowerBI and #Excel: exceleratorbi.com.au/introduction-d…

Very interesting!

Another nice update to #PowerBI this month.

Good spreadsheet design isn't about following rules perfectly - it's about understanding why the rules exist so you know when it's OK to break them. Here are the 5 core rules @kpuls has refined over years of consulting and cleaning up other people's messes. #ExcelTipsandTricks

Modern #BusinessIntelligence is all about empowering users to access, visualize, and explore data intuitively and collaboratively. Our trainers draw on their experience to help you get the most from your data, share insights, and make better decisions: skw-t.com/courses

We LOVE hearing from happy students! 😁 Our #DataVisualization course will help you present data in a clear, engaging, and meaningful way. Master the art of #DataStorytelling and gain the skills to create better graphs and charts in #Excel and #PowerBI - skw-t.com/dataviz

It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what PQ actually does when you do this? 🫣 @kpuls shares how you can get burned, as well as how you can take granular control of filters: youtube.com/watch?v=BeOpEL…

As a consultant, @kpuls advocates strongly for clients owning their #PowerBI infrastructure. For the client, it means they're never locked out of their own reporting if the consulting relationship ends. For Ken, it means he can hand things off cleanly and move on to new projects.

Great overview!

Sweet trick!

Hey newsletter subscribers, time to check your inbox as the new edition 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.

A student asked why a #PivotTable counts 3 Lines of Credit as “used” when one has a zero balance and shouldn’t be counted. 🤷🏾‍ And do you need #PowerPivot and #DAX to fix it? Nope! @kpuls shows it takes just simple data-prep adjustment in #PowerQuery: youtube.com/watch?v=-X-ELo…