Here's an example of using Power BI in your everyday life: Matt Allington calculated the water tank size that is necessary and sufficient to hold the rain water for household usage using #PowerBI and #DAX. 💧 buff.ly/TFoYZtk (You can also read the accompanying article here: buff.ly/oeXfMle)

We love hearing from happy students! 🤩 In the #Excel Fundamentals Academy, you’ll learn all the core skills needed by a #DataAnalyst, including #ExcelFormulasAndFunctions, #PivotTables, #DataVisualization, and #PowerQuery. Plus, @excelguru.ca is there for direct help. Register at skw-t.com/excelfun

Have you ever discovered errors in your data after unpivoting? Should you deal with them before you unpivot, or after? Can you remove all errors and still preserve a list of the records which contained errors? 🤔 Join @excelguru.ca to find out! www.youtube.com/watch?v=sJaX... #PowerQuery

In our last Ask Ken Anything session, a student posed this question: “I have to prepare a report quarterly, and every quarter the data I am receiving is sent to me in a different format. It takes me forever to clean it up and get it into the format for analysis… What can I do to make this easier?”

The inaugural edition of our new combined Skillwave Training and Excelguru newsletter, "News from the Data Monkey", has just been sent! 🐵📧 Learn more about our products, courses, and events, what's new in #PowerBI, recent meet-up recordings, and more. Not a subscriber? Sign up at skw-t.com/news

📣We've just launched a new product: the "Ask Ken Anything" subscription! Join @excelguru.ca for his interactive coaching calls held twice each month. Get help with your questions on #Excel, #PowerQuery, #PowerBI, #DAX, #DataModelling, and more. Sign up today at skw-t.com/aka

Ready to elevate your #DataAnalytics and #BusinessIntelligence skills? 📊 Join today and unlock the full potential of #PowerBI, #PowerQuery, #PowerPivot, and #Excel. Our courses are designed by leading experts in the field—real professionals who’ve been in your shoes. View catalog: skw-t.com/courses

Have you ever worked on something in a program, confident in your path, only to be greeted by a weird error message? A student was trying to combine a folder of JSON files using #PowerQuery in #Excel. Doing everything exactly as they should resulted in the error message shown in the image here. 🤪

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 different methods and discusses the impacts of each: www.youtube.com/watch?v=-j_q... #Excel #PowerBI

A student loved the #SelfServiceBI Academy so much, he took it a second time! 🥰 This is part of the beauty of the subscription model - you have unlimited access to all of the course materials, including our twice-monthly 'Ask Ken Anything' calls with @excelguru.ca. Learn more at skw-t.com/ssbi

Ready to take your career to the next level? Join the ranks of the in-demand workforce and unlock your career potential with #BusinessIntelligence training. 🔥 Don't miss out on this opportunity, start your #DataAnalytics journey today in #PowerBI and #Excel! 🚀 View our courses at skw-t.com/courses

While #PowerQuery has a super easy way to merge columns, there is no easy-to-use UI command which allows you to merge multiple rows into a single cell. 🤔 In this episode of Monkey Shorts, @excelguru shows you how to leverage a little bit of M code to make it happen!

See why this course has 4.95/5 stars! 🌟 #DimensionalModeling is the key to unlocking the power of #Excel and #PowerBI. 🔏 Learn to design and optimize your #DataModel with our on-demand course. Get access to video lessons, practice files, downloadable patterns, and more. Sign up at skw-t.com/modeling

Learn more about the new user-defined functions for DAX!

If you're a user of #PowerBI and #PowerPoint, Matt Allington has a quick video to show you how to share a live, interactive Power BI visual directly into your PowerPoint slide deck. Now you can interact with the visual LIVE during your presentation! Check it out: youtube.com/shorts/k5vzr...

You know the feeling – you’re staring at your solution wondering how to modify it to show the summary you need. You’ve added more tables, more formulas and more complexity, but the correct output is still not there. You’re stuck. 😢 This happened to a student, who brought it to an Ask Ken session.

DYK that when merging columns in #PowerQuery, the behaviour is different depending on whether you trigger the command from the Transform or Add column tabs? 🤯 @excelguru.ca explores why adding a new column may be a better option than transforming existing ones:

#PowerBI is better when you learn to write #DAX! 😍 And students LOVE this course by world-renown expert, Matt Allington. Supercharge Power BI will help you transform your data into actionable insights, with hands-on practice, video tutorials, and expert guidance. Enroll today: skw-t.com/supercharge

If you’ve worked with #Excel for any length of time, we’re sure you’ve ended up with a file you need to update monthly… 📆🔄 In one of our Ask Ken Anything sessions, @excelguru.ca showed how to use #PowerQuery to automate rolling a reconciliation report forward for the next month’s entry.

Tired of wasting 80% of reporting time on #DataCleaning? 😢 @excelguru.ca explains why you need to learn #PowerQuery to automate you #DataPreapration processes and get HOURS of your life back! 🥳 Learn to accelerate your #Excel and #PowerBI workflows with Power Query Academy! Go to skw-t.com/pqa

We know that there are other learning resources out there. 💻At Skillwave, our courses are created BY professionals, FOR professionals. Our trainers are #BusinessIntelligence and #DataAnaltyics experts who have lived in the trenches, just like you. View our courses: skillwave.training #Excel #PowerBI

In this episode of Monkey Shorts, @excelguru.ca looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒 www.youtube.com/watch?v=3hPM... #Excel #PowerBI #DataPreparation #DataAnalyticsTools

Another happy student! ⭐️⭐️⭐️⭐️⭐️ Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by @excelguru.ca! Learn to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll today at skw-t.com/buildfs

In our last AKA session, someone asked @excelguru.ca to review their #PowerQuery based solution to see if it could be made more efficient. Ken modified the user’s custom function to add a Sample Transform, allowing for easy user interface debugging. 🐜 Then he tried a version generated by the UI.

Today’s the last day to save on all courses – sale ends at midnight tonight! ☀️ 50% off on-demand courses with code: SUMMER50 ☀️ 30% off premium coached courses with code: LEARN30 Now’s a great time to invest in yourself, see our catalog at skw-t.com/summer2025 #BusinessIntelligence #PowerBI #Excel

Ready to supercharge your #Excel skills? 🦸 This course will help you master essential formulas and functions, dive deep into #PivotTables, and transform data with #PowerQuery. Enroll now and level up your Excel game. Plus, save 30% by using code LEARN30 at checkout: skw-t.com/xlfun30 #ExcelMastery

This should be a good one - always love hearing from Matthew Roche!

Our courses are changing lives! 👏 @excelguru.ca will teach you to use Excel like a pro, including how to write #ExcelFormulasAndFunctions, use VLOOKUP, create #PivotTables, transform data with #PowerQuery, and visualize data. Register by Aug 31 and save 30% with code LEARN30: skw-t.com/xlfun30

If you've ever tried to join 2 tables in your #Excel #PowerPivot (or #PowerBI) Data Model, and been blocked by 🙅 or warned about duplicate values, a Bridge Table may be just what you need. Here @excelguru.ca shows his preferred recipe for creating them: www.youtube.com/watch?v=-0JA... #DataModeling

📧Our August newsletter has just gone out, so time to check your inbox if you're a subscriber! As mentioned in the screenshot, we're working on consolidating the Skillwave and Excelguru newsletters, so stay tuned for more info in the coming weeks.

Elevate your #Excel game with @excelguru.ca's Excel Fundamentals Academy! 🌟 From basic formulas to advanced #DataAnalytics, we've got you covered. Plus, you’ll receive ongoing coaching and support directly from a world-class expert! Join us today and save 30% with code LEARN30: skw-t.com/xlfun30

How can you automate the process of creating your Inventory Count Sheet in #Excel so you can distribute it to your warehouse stock takers? In last week’s Ask Ken Anything session, @excelguru.ca helped a client build a re-usable solution to this issue.

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 Check out our course catalog: skw-t.com/summer2025

Led by seasoned professionals, our training provides insights from industry experts who understand the art and science #DataVisualization. 📉 Get grounded in the dynamic field of #DataStorytelling and visual communication using #Excel and #PowerBI. 👉 Save 50% with code SUMMER50: skw-t.com/dataviz50

See what students love about our #DataVisualization course! 💙 We'll help you help you communicate insights, tell stories, and persuade audiences by creating more effective graphs, charts, and diagrams in #Excel and #PowerBI. Register today and save 50% with code SUMMER50 Go to skw-t.com/dataviz50

If there are 2 things @excelguru.ca dislikes, it's out-of-date software and having to update software. 😠 You'd think that this would mean that he's never happy. 😜 See how he installs #PowerBI to ensure 🅰️ It's always up-to-date, and 🅱️ He never has to update it, ever.

Master the art of #DataStorytelling! 🎨 We’ll guide you through the principles of effective #DataVisualization and show how to build different charts and graphs in #Excel and #PowerBI. Want to communicate your insights with impact? Sign up today and save 50% with code SUMMER50: skw-t.com/dataviz50

While it is awesome to have options #DataCleansing, sometimes the sheer amount of options can be overwhelming. 😧 This can prevent you from getting started in the first place or just make you question which is the best option to pursue for your scenario. Fortunately, our Ask Ken sessions can help. 😅

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

🚛🚨Beep Beep Beep 🚛🚨 Let's talk about backing up! If you spend a lot of time developing #PowerBI reports, sooner or later you're going to need to roll back to or retrieve a previous version. In this video, Matt Allington shows you how he handles incremental back-ups: youtu.be/IcpnCvWsabg #DataBackup

It’s one thing to know how to write a #DAX formula. It’s a different level of competency to understand how/why it works. 💡 This advanced course will help you become self-sufficient with your #DataModeling capabilities using DAX in #PowerBI and #Excel. Save 50% with code SUMMER50: skw-t.com/advdax50

This student said Demystifying DAX is the best online training she's ever taken! 😁 If you have experience writing DAX but don't really get why it works (or doesn't), this course will help you understand what is actually happening under the hood. Plus, save 50% with code SUMMER50: skw-t.com/advdax50

Do you really need to reference the fully qualified table and measure names for each element you want to query in your CUBE formula? The answer is... maybe? 🤷 @excelguru.ca looks at how much you can trim out, and where it could lead to issues: www.youtube.com/watch?v=eLbO... #Excel #PowerPivot

Dive deep into the world of #DataInsights with Matt Allington. 🤓 Learn advanced #DAX concepts and enhance your #DataModeling skills in #PowerBI or #Excel. Elevate your #DataAnalytics career and enroll now! Use code SUMMER50 to save 50% on your first year of access, go to: skw-t.com/advdax50

In our last AKA session, @excelguru.ca was asked how to add a slicer in #PowerBI which allows you to filter by specific terms and synonyms. With an extra table, some bitwise logic and a BITAND-based #DAX measure, filtering for Blind or Shade dynamically returns any instance containing either/both.

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

With all the AI options available now, do I actually need to learn how to write #Excel formulas and #DAX measures? Hear @excelguru.ca's take on it. #ArtificialIntelligence #ExcelFormulas #AITools

Elevate your career with this comprehensive training by DAX and #PowerBI expert, Matt Allington. 🌟 Learn #DataPreparation, #DataModeling, #DAX formulas, and reporting techniques in a structured way with hands-on experience. Join now and save 50% with code SUMMER50: skw-t.com/pbiba50 #DataAnalysis

We love hearing from happy students! 👏 Geared towards users new to #PowerBI, or are self-taught, this course guides you through creating and sharing reports, getting and transforming data with #PowerQuery, and writing #DAX formulas for #DataInsights. Save 50% with code SUMMER50: skw-t.com/pbiba50

Getting a slicer hooked up to your CUBE formulas is easy - providing the slicer is connected to the #PivotTable before you convert it. But what if you've already converted the Pivot Table to formulas, and then you want to add a slicer? @excelguru.ca has a solution: