This is the code repository for Learn Power Query , published by Packt.

A low-code approach to connect and transform data from multiple sources for Power BI and Excel

Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you’ll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI.

This book covers the following exciting features:

• Convert worksheet data into a table format ready for query output
• Create a dynamic connection between an Access database and Excel workbook
• Reshape tabular data by altering rows, columns, and tables using various Power Query tools
• Create new columns automatically from filenames and sheet tabs, along with multiple Excel data files
• Streamline and automate reports from multiple sources
• Explore different customization options to get the most out of your dashboards
• Understand the difference between the DAX language and Power Query's M language

If you feel this book is for you, get your copy today!

All of the code is organized into folders. For example, Chapter02.

The code will look like the following:

let
  Source = ""
in
  Source

Following is what you need for this book: This book would suit professional business analysts, data analysts, BI professionals, and Excel users who wish to take their skills to the next level by learning how to collect, combine, and transform data into insights using Power Query.

With the following software and hardware list you can run all code files present in the book (Chapter 1-12).

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.

• DAX Cookbook [Packt] [Amazon]

• Learn Microsoft Office 2019 [Packt] [Amazon]

Linda Foulkes is a Microsoft Office Master Trainer, Certified Educator, and Microsoft Innovative Expert Educator and Trainer with an educational and corporate background spanning over 25 years. As well as being certified as an IT trainer, Linda represented South Africa at the Microsoft Global Forum in Redmond in 2015. She has certified and coached students to compete at the Microsoft Office Specialist Championships in Texas. She has also published Learn Microsoft Office 2019 through Packt. Linda has also presented at conferences and conducted webinars for SchoolNet SA, and hosted TeachMeets and MicrosoftMeets. She has a keen interest in e-learning and has developed e-learning paths and content for the Microsoft Office suite of programs.

Warren Sparrow is a Microsoft, Adobe, and National Geographic Certified Educator. He has been a Microsoft Innovative Expert Educator for the last 6 years, and a fellow in 2015. Warren is regularly invited to be a guest speaker at different global educational events, including the annual Microsoft conference on Office 365 in 2015. His core focus is long-term strategy, training, and technology implementation. He has provided training and development in both the education and corporate sectors. He also played an advisory role to the Western Cape Education Department (South Africa), giving assistance on the roll-out of hardware and software, as well as the training of educators and the implementation of technology in school classrooms.

Click here if you have any feedback or suggestions.