Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
power
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
IMDB Title Basics
The titlebasics file is a good file to start with after you have downloaded it. I re-named the […]
IMDB Repeating Genre Values
In working with the IMDB database tables, you find that each moving picture can have one or more […]
Power Pivot Kevin Cookie
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]
Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]
Excel Power Query Data Type Error
Sometimes when you bring in data into the Power Query Editor, you experience data type errors. Here below […]
Excel Power Query Fill Down
Are you using Power Query to import data into Excel and finding that one of your columns is […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]