This set of ready-to-use Power Query Recipes will lead you step-by-step through a variety of data transformations and techniques. These recipe cards were created based on many years of experience using Excel, Power Query and Power BI to transform and enrich data for analysis. Loaded with "before" and "after" examples, they give a handy playbook recipe for you to choose the appropriate steps to apply to your data.
The STAND-ALONE DIGITAL DOWNLOAD includes the full set of current recipe cards; new or updated cards are not available.
NOTE: These recipes are intended to be applied to your own data scenarios, and there are no data sample files provided with this package. Having said that, "before" and "after" pictures are included on all relevant cards, meaning that you can re-create the sample data manually if you wish to do so. Simple record the data in an Excel spreadsheet and use Get Data -> From Table to pull it into Power Query.
Curious about the types of recipes included? Download our current Table of Contents and free Sample Package:
Upon purchase, a Skillwave Training account will be set up and you will be emailed with the information to access your account. You will be able to download the recipe cards as many times as you like by logging into this account, but you will only have access to the set of cards at was available the initial time of purchase.
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.
Power Query Recipes Stand-alone
Only verified customers who have purchased this product may leave a review.
Check out the other helpful reference materials we have available.