Power Query Cookbook

Data rules our lives.  Whether we are working with databases or simple spreadsheets, it consumes our lives.  Frequently, we must transform and cleanse this data for our use.  The only problem is that we often perform the same transformations over and over again with each time we use that data.  Enter Power Query to simplify your life.  Regardless of your preference, Power Query is integrated with both Power BI and Excel.  With a little time and effort, you can simplify the transformation process and reclaim hours of once repetitive work that provided no additional value to your day.

This book will walk you through the basics of getting connected to data with Power Query.  You will understand how to ingest data from files, folders, databases, websites, APIs, and other 3rd party sources.  Once connected, you will learn how to transform the data so it is ready for your use.  We will clean up columns, filter, replace, extract, and classify data in Power Query to meet your needs.  Lastly, we will go over advanced techniques to help optimize and simplify your transformations allowing fast refreshes all while helping you manage them in the future.

When you have completed this book you will know how to apply these techniques to your data all while understanding the implications of making certain decisions.  This will enable you to have better conversations with other data professionals who are providing data for your use.

Key Features:

• Covers basics of connecting to, transforming, and cleansing data
• Emphasizes practical approaches to transforming data in Power Query
• Provides real-life examples that readers can apply to their own work

What You Will Learn:

• Learn to connect to files, databases, and third-party services
• Manage data types and formats to optimize storage
• Transform, create, and manipulate queries
• Combine, merge, filter, and cleanse queries
• Integrate Artificial Intelligence to accelerate insights
• Perform complex and scalable transformations