Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

Introduction

There used to be a time when a company's IT team would manage all of the data and create the necessary charts and reports from that data, based on the user's needs. But now, for most companies, those days are long gone!

In today's world, we are all overwhelmed by huge amounts of data from many different sources. On top of that, our co-workers, bosses, vendors, and customers are asking us for all kinds of reports and charts from that data. They also want it to be flexible so they can change the parameters and have it produce instant results. Oh, and by the way, they needed it all yesterday! Sort it this way, filter it that way, show it month by month, etc. It is a daunting and time-consuming task, to say the least! Plus, you have all the other responsibilities for your job as well.

Microsoft Excel has great tools to help you manage your data and to report on that data the way you want to see it. Using pivot tables, Power Query, and PowerPivot, you can pull in data from many sources. You can also clean up and prepare your data, summarize your data in many ways, analyze your data by adding formulas, create visually appealing and interactive dashboards, and get real results from your data. You can do all of this without having to be a programmer. This book will show how to use these tools in an easy-to-follow step-by-step format, backed up with screenshots and real-life examples.

What Does This Book Cover?

An Excel pivot table is an amazing tool that helps you summarize ...