Magic Tricks for Data Wizards

Free eBook: Magic Tricks for Data Wizards

Tips & Tricks for Power Query in Excel & Power BI

Learn some Magic Tricks from the Data Wizard

Sign up to our newsletter and claim your FREE copy of our eBook ‘Magic Tricks for Data Wizards’.

In today’s world, Data Preparation or Data Wrangling is not something that is only available by acquiring expensive and complicated software or by learning complicated programming languages.

Meet Microsoft’s Power Querythe best Data Preparation tool that has ever existed for a Business User. With a simple and straightforward User Interface, you’ll feel like you’re doing magic with your data.

Why this free eBook? This is a short and concise eBook, aimed towards anyone who wishes to understand Power Query solutions at a conceptual level with clear example-driven chapters.
If you wish to do magic with your data and become a Data Wizard, then this is a eBook for you.

From reading this eBook, you will learn:

  • Merge Operations
  • Append Operations
  • Group By
  • Advanced Data Preparation Techniques
  • Creating and Using Custom Functions
  • Various common Power Query Tips & Tricks

The Chapters of the eBook

Merge Tables
Dynamic Calendar Table
Grouping Data
Time Intelligence
Combining Files from a Folder
Handling Multiple Data Patterns in a Table

Learn some Magic Tricks from the Data Wizard

Sign up to our newsletter and claim your FREE copy of our eBook ‘Magic Tricks for Data Wizards’.