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
When notes are added to a table generated by #PowerQuery in #Excel, refreshing the data can cause those notes to shift and no longer align with the correct records. In this video, @excelguru.ca explains why this happens and how to fix it: www.youtube.com/watch?v=Hg1x...
#BusinessIntelligence
#BusinessIntelligence
Tracking Notes
Join Ken Puls in this episode as he addresses a common challenge raised during a Self-Service Business Intelligence Academy, Ask Ken Anything session.
When notes are added to a table generated by…
www.youtube.com
January 7, 2026 at 5:31 PM
When notes are added to a table generated by #PowerQuery in #Excel, refreshing the data can cause those notes to shift and no longer align with the correct records. In this video, @excelguru.ca explains why this happens and how to fix it: www.youtube.com/watch?v=Hg1x...
#BusinessIntelligence
#BusinessIntelligence
Recently, @excelguru.ca walked at student through a #PowerQuery solution to:
✅Extract the correct year from a header
✅Isolate it as its own value
✅Merge it back into the transaction data before converting everything into proper dates.
The result? Accurate timelines without manual #DataCleanup. 🧵
✅Extract the correct year from a header
✅Isolate it as its own value
✅Merge it back into the transaction data before converting everything into proper dates.
The result? Accurate timelines without manual #DataCleanup. 🧵
January 6, 2026 at 5:46 PM
Recently, @excelguru.ca walked at student through a #PowerQuery solution to:
✅Extract the correct year from a header
✅Isolate it as its own value
✅Merge it back into the transaction data before converting everything into proper dates.
The result? Accurate timelines without manual #DataCleanup. 🧵
✅Extract the correct year from a header
✅Isolate it as its own value
✅Merge it back into the transaction data before converting everything into proper dates.
The result? Accurate timelines without manual #DataCleanup. 🧵
If your goal this year is to become a better #DataAnalyst and up your #BusinessIntelligence game, Skillwave Training has you covered! 👊
Our courses are created by the best instructors in the business, who have real-world experience and business knowledge. View our catalog: skillwave.training/learn
Our courses are created by the best instructors in the business, who have real-world experience and business knowledge. View our catalog: skillwave.training/learn
January 5, 2026 at 5:06 PM
If your goal this year is to become a better #DataAnalyst and up your #BusinessIntelligence game, Skillwave Training has you covered! 👊
Our courses are created by the best instructors in the business, who have real-world experience and business knowledge. View our catalog: skillwave.training/learn
Our courses are created by the best instructors in the business, who have real-world experience and business knowledge. View our catalog: skillwave.training/learn
In our last Ask Ken Anything (AKA) session, a student asked the question that always follows a great #Excel or #PowerBI report: “Okay… but how do I update this every month without breaking it?” 😬
Ken Puls broke the answer into three real-world update strategies using #PowerQuery. 🧵
Ken Puls broke the answer into three real-world update strategies using #PowerQuery. 🧵
January 2, 2026 at 5:36 PM
In our last Ask Ken Anything (AKA) session, a student asked the question that always follows a great #Excel or #PowerBI report: “Okay… but how do I update this every month without breaking it?” 😬
Ken Puls broke the answer into three real-world update strategies using #PowerQuery. 🧵
Ken Puls broke the answer into three real-world update strategies using #PowerQuery. 🧵
Do you typically spend a bunch of time trying to position your slicers in an #Excel report "just right"? Ever been frustrated with those perfectly placed slicers moving around as you slice or update your #PivotTable?😡 This will definitely help you out: www.youtube.com/watch?v=xTBj...
#DataAnalysis
#DataAnalysis
Slicer Formatting Tricks - Monkey Shorts Episode 007
Do you typically spend a bunch of time trying to position your slicers "just right"? Have you ever been frustrated with those perfectly placed slicers moving around as you slice or update your Pivot…
www.youtube.com
December 31, 2025 at 5:42 PM
Do you typically spend a bunch of time trying to position your slicers in an #Excel report "just right"? Ever been frustrated with those perfectly placed slicers moving around as you slice or update your #PivotTable?😡 This will definitely help you out: www.youtube.com/watch?v=xTBj...
#DataAnalysis
#DataAnalysis
The last newsletter of the year has just gone out! 📬
Subscribe today to stay up-to-date on the latest content from our experts, what's new in #Excel and #PowerBI, and information on courses, events, and promotions. You'll also get our free #PowerQuery eBook.
👉Go to skw-t.com/news
Subscribe today to stay up-to-date on the latest content from our experts, what's new in #Excel and #PowerBI, and information on courses, events, and promotions. You'll also get our free #PowerQuery eBook.
👉Go to skw-t.com/news
December 30, 2025 at 5:29 PM
The last newsletter of the year has just gone out! 📬
Subscribe today to stay up-to-date on the latest content from our experts, what's new in #Excel and #PowerBI, and information on courses, events, and promotions. You'll also get our free #PowerQuery eBook.
👉Go to skw-t.com/news
Subscribe today to stay up-to-date on the latest content from our experts, what's new in #Excel and #PowerBI, and information on courses, events, and promotions. You'll also get our free #PowerQuery eBook.
👉Go to skw-t.com/news
In this video, @excelguru.ca shows how to build a dynamic forecast sheet in #Excel that connects directly to a #PowerPivot #DataModel. 📉
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution in #Excel:
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution in #Excel:
Forecasting - Dynamically from Data Model
Build a fully interactive forecast sheet in Excel that is tied to the Data Model.
In this video, Ken Puls demonstrates how to build a dynamic forecast sheet that connects directly to an Excel Power…
www.youtube.com
December 29, 2025 at 5:14 PM
In this video, @excelguru.ca shows how to build a dynamic forecast sheet in #Excel that connects directly to a #PowerPivot #DataModel. 📉
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution in #Excel:
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution in #Excel:
Wishing everyone the best for the New Year!
Here's a fun little project to give you a laugh over the holidays. 🙉🎶 A big thank you to the @unpivotshow.bsky.social team for gifting @excelguru.ca this song:
Here's a fun little project to give you a laugh over the holidays. 🙉🎶 A big thank you to the @unpivotshow.bsky.social team for gifting @excelguru.ca this song:
Ken Puls and the Data Monkey - A Musical Tribute
Ken Puls has contributed enormously to the data community through his work with Power Query, Power Pivot, and Power BI.
His solutions, training, coaching, and mentoring have helped countless…
www.youtube.com
December 26, 2025 at 6:54 PM
Wishing everyone the best for the New Year!
Here's a fun little project to give you a laugh over the holidays. 🙉🎶 A big thank you to the @unpivotshow.bsky.social team for gifting @excelguru.ca this song:
Here's a fun little project to give you a laugh over the holidays. 🙉🎶 A big thank you to the @unpivotshow.bsky.social team for gifting @excelguru.ca this song:
In this Monkey shorts, Ken Puls demonstrates how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
Sorting Power Pivot backed Slicer and Pivots - Monkey Shorts Episode 006
In this episode, Ken demonstrates how to sort one Power Pivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order.
www.youtube.com
December 24, 2025 at 6:03 PM
In this Monkey shorts, Ken Puls demonstrates how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
In our last Ask Ken Anything (AKA) session of the year, an attendee raised a deceptively simple question: “Why does Excel keep calling my column ‘Sum of Amount’ and can I stop it?” 😩
@excelguru.ca explained how #Excel automatically assigns aggregations when numeric fields hit a #PivotTable. 🧵
@excelguru.ca explained how #Excel automatically assigns aggregations when numeric fields hit a #PivotTable. 🧵
December 23, 2025 at 5:06 PM
In our last Ask Ken Anything (AKA) session of the year, an attendee raised a deceptively simple question: “Why does Excel keep calling my column ‘Sum of Amount’ and can I stop it?” 😩
@excelguru.ca explained how #Excel automatically assigns aggregations when numeric fields hit a #PivotTable. 🧵
@excelguru.ca explained how #Excel automatically assigns aggregations when numeric fields hit a #PivotTable. 🧵
There's nothing better than hearing from happy students! 😁
Our #DataVisualization course will help you present data in a clear, engaging, and meaningful way. Gain all the fundamental skills to create better, more effective graphs, charts, and diagrams in #Excel and #PowerBI. Go to skw-t.com/dataviz
Our #DataVisualization course will help you present data in a clear, engaging, and meaningful way. Gain all the fundamental skills to create better, more effective graphs, charts, and diagrams in #Excel and #PowerBI. Go to skw-t.com/dataviz
December 22, 2025 at 5:31 PM
There's nothing better than hearing from happy students! 😁
Our #DataVisualization course will help you present data in a clear, engaging, and meaningful way. Gain all the fundamental skills to create better, more effective graphs, charts, and diagrams in #Excel and #PowerBI. Go to skw-t.com/dataviz
Our #DataVisualization course will help you present data in a clear, engaging, and meaningful way. Gain all the fundamental skills to create better, more effective graphs, charts, and diagrams in #Excel and #PowerBI. Go to skw-t.com/dataviz
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
www.youtube.com
December 18, 2025 at 5:11 PM
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
In the last AKA session, one of our students asked a question many #Excel users quietly struggle with: “Why is my #PivotTable giving me weird blanks and not calculating month-over-month changes properly?”
@excelguru.ca immediately spotted the red flag. 🚩
🧵
@excelguru.ca immediately spotted the red flag. 🚩
🧵
December 17, 2025 at 5:04 PM
In the last AKA session, one of our students asked a question many #Excel users quietly struggle with: “Why is my #PivotTable giving me weird blanks and not calculating month-over-month changes properly?”
@excelguru.ca immediately spotted the red flag. 🚩
🧵
@excelguru.ca immediately spotted the red flag. 🚩
🧵
If you're a newsletter subscriber, the new edition should be in your inbox! 📬
Not subscribed? Sign up today at skw-t.com/news to get the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more! We'll also send you our free #PowerQuery eBook.
Not subscribed? Sign up today at skw-t.com/news to get the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more! We'll also send you our free #PowerQuery eBook.
December 16, 2025 at 5:37 PM
If you're a newsletter subscriber, the new edition should be in your inbox! 📬
Not subscribed? Sign up today at skw-t.com/news to get the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more! We'll also send you our free #PowerQuery eBook.
Not subscribed? Sign up today at skw-t.com/news to get the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more! We'll also send you our free #PowerQuery eBook.
In this step-by-step demo, @excelguru.ca highlights how Auto Refresh brings standard #PivotTables up to par with a Power Pivot #DataModel and the importance of #PowerQuery in managing data refreshes, plus gives insights on SPILL errors: youtube.com/watch?v=cCKI...
#Excel #DataAnalytics
#Excel #DataAnalytics
Pivot Consistency
In this video, Ken Puls delves into PivotTable Auto Refresh and SPILL error, explaining their impact on Standard and Data Model PivotTables.
Through a step-by-step demo, Ken clarifies common…
youtube.com
December 15, 2025 at 5:18 PM
In this step-by-step demo, @excelguru.ca highlights how Auto Refresh brings standard #PivotTables up to par with a Power Pivot #DataModel and the importance of #PowerQuery in managing data refreshes, plus gives insights on SPILL errors: youtube.com/watch?v=cCKI...
#Excel #DataAnalytics
#Excel #DataAnalytics
Woo hoo, another 5⭐️ review for @excelguru.ca's #SelfServiceBI Academy!
This premium, self-paced training is crafted for business professionals who demand excellence in #DataAnalytics using #Excel and #PowerBI. Get started today at skw-t.com/ssbi
This premium, self-paced training is crafted for business professionals who demand excellence in #DataAnalytics using #Excel and #PowerBI. Get started today at skw-t.com/ssbi
December 12, 2025 at 5:51 PM
Woo hoo, another 5⭐️ review for @excelguru.ca's #SelfServiceBI Academy!
This premium, self-paced training is crafted for business professionals who demand excellence in #DataAnalytics using #Excel and #PowerBI. Get started today at skw-t.com/ssbi
This premium, self-paced training is crafted for business professionals who demand excellence in #DataAnalytics using #Excel and #PowerBI. Get started today at skw-t.com/ssbi
When importing data in #Excel or #PowerBI via #PowerQuery, it's good to set the column. But with wide tables, this can take a lot of time as you have to wait for PQ to catch up after setting each column. 😭
@excelguru.ca has a tip to quickly set ALL data types:
@excelguru.ca has a tip to quickly set ALL data types:
Quick tip for setting Data Types in Power Query - Monkey Shorts Episode 004
When importing data via Power Query, it is a good idea to set the data types of your columns. The challenge is that - in wide tables - doing this for each column can take a lot of time as you set…
www.youtube.com
December 11, 2025 at 5:43 PM
When importing data in #Excel or #PowerBI via #PowerQuery, it's good to set the column. But with wide tables, this can take a lot of time as you have to wait for PQ to catch up after setting each column. 😭
@excelguru.ca has a tip to quickly set ALL data types:
@excelguru.ca has a tip to quickly set ALL data types:
In a recent AKA session, one attendee asked how to replicate #PowerBI-style colour grading inside a single #Excel PivotTable – without needing a second helper pivot to drive the colour rules. @excelguru.ca built a clever workaround:
1️⃣ Convert the colour logic measure into numeric values (0–3). 🧵
1️⃣ Convert the colour logic measure into numeric values (0–3). 🧵
December 10, 2025 at 5:17 PM
In a recent AKA session, one attendee asked how to replicate #PowerBI-style colour grading inside a single #Excel PivotTable – without needing a second helper pivot to drive the colour rules. @excelguru.ca built a clever workaround:
1️⃣ Convert the colour logic measure into numeric values (0–3). 🧵
1️⃣ Convert the colour logic measure into numeric values (0–3). 🧵
What is #DAX? It is an acronym for Data Analysis eXpressions, and is a programming language used to write measures in order to add business logic to your #PowerBI or Excel #DataModel.
💡 Matt Allington explains the DAX language and how to use it for #DataModeling: exceleratorbi.com.au/what-is-dax/
💡 Matt Allington explains the DAX language and how to use it for #DataModeling: exceleratorbi.com.au/what-is-dax/
What is DAX
I have written a series of articles over the last few years including: What is Power BI What is Power Query What is Power Pivot But I have never written an article about the DAX language, so I…
exceleratorbi.com.au
December 9, 2025 at 5:38 PM
What is #DAX? It is an acronym for Data Analysis eXpressions, and is a programming language used to write measures in order to add business logic to your #PowerBI or Excel #DataModel.
💡 Matt Allington explains the DAX language and how to use it for #DataModeling: exceleratorbi.com.au/what-is-dax/
💡 Matt Allington explains the DAX language and how to use it for #DataModeling: exceleratorbi.com.au/what-is-dax/
🚨This is your LAST CHANCE to take advantage of our Cyber Week deal! If you’re ready to continue your journey as a skilled data professional, you have 1 day left to save 25% on all our training and eBooks. Just use this code at checkout: 2025CYBER
Don’t miss out, go right now to skw-t.com/cw25
Don’t miss out, go right now to skw-t.com/cw25
December 5, 2025 at 5:07 PM
🚨This is your LAST CHANCE to take advantage of our Cyber Week deal! If you’re ready to continue your journey as a skilled data professional, you have 1 day left to save 25% on all our training and eBooks. Just use this code at checkout: 2025CYBER
Don’t miss out, go right now to skw-t.com/cw25
Don’t miss out, go right now to skw-t.com/cw25
Tired of boring data presentations? 🙅 Our #DataVisualization course by Jon Schwabish, @excelguru.ca and Matt Allington. will teach you how to create captivating graphs and charts in #Excel and #PowerBI to communicate more effectively!
Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-dv
Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-dv
December 4, 2025 at 8:59 PM
Tired of boring data presentations? 🙅 Our #DataVisualization course by Jon Schwabish, @excelguru.ca and Matt Allington. will teach you how to create captivating graphs and charts in #Excel and #PowerBI to communicate more effectively!
Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-dv
Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-dv
In this episode of Monkey Shorts, @excelguru.ca will show you how you can set different layouts for each column of your #PivotTable: www.youtube.com/watch?v=6ewp...
#DataAnalysisTools #BusinessIntelligence #Excel
#DataAnalysisTools #BusinessIntelligence #Excel
Granular PivotTable Layouts - Monkey Shorts Episode 003
In this episode of Monkey Shorts, Ken will show you how you can set different layouts for each column of your PivotTable.
www.youtube.com
December 4, 2025 at 5:24 PM
In this episode of Monkey Shorts, @excelguru.ca will show you how you can set different layouts for each column of your #PivotTable: www.youtube.com/watch?v=6ewp...
#DataAnalysisTools #BusinessIntelligence #Excel
#DataAnalysisTools #BusinessIntelligence #Excel
The question of how to convert Julian dates to Gregorian using #PowerQuery came up in a course @excelguru.ca taught. 📅 Although he hasn't ever used JD Edwards, apparently this is quite common in that system, so it hits a lot of people. Let's look at a method to do this:
Convert Julian Dates to Gregorian Dates with Power Query
In this article we will look at how to convert Julian Dates to Gregorian Dates using Power Query - a particular issue for JD Edwards users,
excelguru.ca
December 3, 2025 at 8:34 PM
The question of how to convert Julian dates to Gregorian using #PowerQuery came up in a course @excelguru.ca taught. 📅 Although he hasn't ever used JD Edwards, apparently this is quite common in that system, so it hits a lot of people. Let's look at a method to do this:
🔑 #DimensionalModeling is the key to unlocking the power of #DataAnalytics in #Excel and #PowerBI. Learn how to design and optimize your #BusinessIntelligence models to make them more stable and scalable through our on-demand training. 🖥️
Register with code 2025CYBER to save 25%: skw-t.com/cw25-dm
Register with code 2025CYBER to save 25%: skw-t.com/cw25-dm
December 3, 2025 at 5:15 PM
🔑 #DimensionalModeling is the key to unlocking the power of #DataAnalytics in #Excel and #PowerBI. Learn how to design and optimize your #BusinessIntelligence models to make them more stable and scalable through our on-demand training. 🖥️
Register with code 2025CYBER to save 25%: skw-t.com/cw25-dm
Register with code 2025CYBER to save 25%: skw-t.com/cw25-dm
Errors during #PivotTable refreshes in #Excel can be easy to miss, but they can break your entire workflow. @excelguru.ca has a smart, reliable method to detect refresh-time errors and surface them right on your worksheet so you never miss a critical issue again:
Catch PivotTable & Workbook Errors Smartly! 🚨
Errors during PivotTable refreshes can be easy to miss — but they can break your entire workflow.
In this video, Ken Puls shows a smart, reliable method to detect refresh-time errors automatically…
www.youtube.com
December 2, 2025 at 8:17 PM
Errors during #PivotTable refreshes in #Excel can be easy to miss, but they can break your entire workflow. @excelguru.ca has a smart, reliable method to detect refresh-time errors and surface them right on your worksheet so you never miss a critical issue again: