Linda Foulkes - Learn Power Query: A low-code approach to connect and transform data from multiple sources for Power BI and Excel

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

Linda Foulkes

Warren Sparrow

BIRMINGHAMMUMBAI

Copyright 2020 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Commissioning Editor : Kunal Chaudhari

Acquisition Editor : Karan Gupta

Senior Editor : Nitee Shetty

Content Development Editor : Tiksha Lad

Technical Editor : Pradeep Sahu

Copy Editor : Safis Editing

Project Coordinator : Deeksha Thakkar

Proofreader : Safis Editing

Indexer : Manju Arasan

Production Designer : Nilesh Mohite

First published: July 2020

Production reference: 1160720

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham

B3 2PB, UK.

ISBN 978-1-83921-971-9

www.packt.com

To my special person:

It has certainly been a challenging, but extremely rewarding, phase of my life authoring this book. I would like to thank my special person, Mick, for his inspiration, understanding, and pushing me to meet deadlines. You have contributed greatly to my life, and I appreciate you immensely. I love you.

To my co-author:

It is not often you find a co-author who will check all the boxes and turn up for a Zoom meeting at 6 a.m. in his tie. Warren, thank you for working alongside me, motivating me, and pouring your knowledge and expertise into this book, and also, for giving me a breather near the end to complete Learn Microsoft Office 2019 (which I wrote alongside Power Query). I have enjoyed our long chats, your humor, as well as having your support throughout the process. Congratulations on your first publication we did it!

-Linda Foulkes

This book is dedicated to Michelle, my wife, my best friend, and my love, and to my two beautiful daughters, Danica and Jordan.

-Warren Sparrow

Packt.com

Subscribe to our online digital library for full access to over 7,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.

• Spend less time learning and more time coding with practical eBooks and videos from over 4,000 industry professionals
• Improve your learning with Skill Plans built especially for you
• Get a free eBook or video every month
• Fully searchable for easy access to vital information
• Copy and paste, print, and bookmark content

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at for more details.

At www.packt.com, you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.

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.

Both Warren and I have enjoyed the process of writing this book immensely and would like to thank the Packt team for their dedication to this process. Without the support of a strong team toward the end of chapter writing, the review process, meeting deadlines, and the submission of final proofs would have been a near-impossible task to achieve. We would like to thank all those involved, but extend a sincere, special gratitude to Karan Gupta, Acquisition Editor, who devoted 100% of his time to the initial stages of the book and was always available for support throughout, to the Content Development Editor, Tiksha Lad, for her encouragement and professional contribution, and to Prajakta Naik, for checking that we were on course to meet deadlines and for offering support where needed. Last, but by no means least, we would like to thank our reviewer, Vishwanath Muzumdar, for being our critic and advising us accordingly in order to enable us to finish this great resource.

Vishwanath Muzumdar has more than 8 years' experience in information technology consulting, business analysis, business development, and business process management in the business intelligence space.

He is an MS Power BI developer (champion) in the creation of powerful visual reporting for clients. His goal is to utilize his strong prioritization skills, analytical ability, team management skills, and expertise in the Microsoft Power BI reporting tool in order to achieve organizational objectives.

If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.