In this video, Ken Puls tackles a real-world question from an Ask Ken Anything session of Self Service Business Intelligence Academy training course. How do you track a weekly forecast, preserve…

YouTube video by Curt Frye

In this week's episode of Monkey Shorts, Ken explores a recipe to fix non-aligned data issues. It all started with a PDF import where data shifted into different columns on different rows. It all…

Learn how to unpivot data easily using Power Query in Excel (and Power BI). In this video, Ken shows how to convert a human-friendly report layout into a clean tabular format that works beautifully…

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…

In this video, Ken Puls tackles a real-world question from a Self Service BI Academy student in one of the Ask Ken Anything sessions. The question is: how do you reliably identify price changes over…

By default, when you unpivot a set of data in Power Query, all null records are suppressed. But what if you need them in your unpivoted data set? In this week's episode of Monkey Shorts, Ken shows…

I offer my YouTube videos for free, but they are far from the only resource available at no cost. In this video, I’ll start my review of free resources with OpenStax, from Rice University. The web…

In this video, Ken shows how the Parameter Table and Function feature in Monkey Tools can automatically add the fnGetParameter() function and the required parameter table setup into your Excel…

While Power Query has a super easy way to merge columns, there is no easy-to-use user-interface command which allows you to merge multiple rows into a single cell. In this week's episode of Monkey…

Did you know that when merging columns in Power Query, the behaviour is different depending on whether you trigger the command from the Transform or Add column tabs? (And no, we're not talking about…

Learn how to control sorting and filtering when working with PivotTables connected to the Excel Power Pivot Data Model. In this video, Ken shows how to sort fields properly inside the Power Pivot…

In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.

Power Query is a data loading tool bundled with Excel & Power BI. It is one of the most important new Microsoft products since Excel itself. Read more here.

For the first time since Excel 2016, we've got new DAX functions in Excel Power Pivot! Fresh to Office Insiders, the Excel team is moving DAX closer to parity with Power BI. Yes, it will take some…

Got data stacked in a single column with a repeating pattern like Date, Vendor, Amount, blank — over and over again? In this video, Ken shows how to reshape stacked data in Power Query using a…

If you've ever tried to join two tables in your Excel Power Pivot Data Model (or your Power BI Data Model), and been blocked by or warned about duplicate values, a Bridge Table may be just what you…

If there are two things Ken dislikes the most, it is out-of-date software, and having to update software. You'd think that this would mean that Ken is never happy, but that is not at all true. …