Advertisement

Introducing Power Query

  • Chris Webb
Chapter

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.

Keywords

Database Engine Excel Service Menu Option External Data Source Excel Workbook 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Chris Webb 2014

Authors and Affiliations

  • Chris Webb
    • 1
  1. 1.BucksUnited Kingdom

Personalised recommendations