Magic Tricks for Data Wizards

Magic Tricks for Data Wizards:Tips & Tricks for Power Query in Excel and Power BI

In the online Power Query workshops that we deliver as part of our Power Query Training project, we commonly talk about how data professionals can often perform “Magic” with their data in terms of transforming, cleaning or reshaping a dataset for better consumption and analysis. We often call these data professionals “Magicians” or ”Data Wizards”.

Why Data Wizards? The term wizard often describes “a person who is very skilled in a particular field or activity,”’ and in computing the term wizard means “a help feature of a software package that automates complex tasks by asking the user a series of easy-to-answer questions.” The first definition is for you, the Excel user, and the second definition is for Power Query – together you make magic.

This eBook is written from a practical point of view with easy-to-follow examples. We’ve compiled the most impactful cases that we’ve encountered over the years to show you how to work more effectively with Power Query based on the scenario that you have.

The goal of this eBook is to help you, as a Data Wizard, learn some new tricks and tips when working with this amazing tool called Power Query.

Each chapter of this eBook is independent from one another, so you can jump to a chapter of your choice and get the information that you are looking for without the need to see the rest of the eBook. However, we do encourage you to check the full contents of this eBook.

We’ve made sure that this is a short and concise eBook that you can be able to read in just one sitting while still learning everything that you need to know to work more effectively with Power Query.

Use your preferred tool! You can follow along our examples with either Power Query for Excel or in the Power BI Desktop

If you're not already a Power Query Training newsletter subscriber, get your free copy by SIGNING UP HERE.

I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!