Abstract
This book is for people who spend a lot of time working with Excel building reports and dashboards. More specifically, this book is for people who work with Excel building reports and dashboards and who are bored with copying and pasting data into worksheets, bored with clicking the same sequence of buttons every month to clean and shape that data, and bored with fixing the problems associated with complex formulas, dirty data, and the errors that are inevitable when you have to follow the same procedures over and over and over again. The good news is that Power Query is here to free you from these dull, repetitive tasks and give you time to concentrate on what’s important: analyzing your data and gaining insights from it. Even better, Power Query is easy to use and lots of fun to learn (so long as you’re the kind of person who thinks that playing with data can be fun—no need to feel ashamed if you do) and, as a result, it will make you more efficient, more productive, and, hopefully, less bored.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Chris Webb
About this chapter
Cite this chapter
Webb, C. (2014). Introducing Power Query. In: Power Query for Power BI and Excel. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6692-1_1
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6692-1_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6691-4
Online ISBN: 978-1-4302-6692-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)