Power BI Tools Volume 4: Learning Power Query And Power Pivot For Excel Made Easy



By Dr. Indera E. Murphy

Published: June 24, 2016
ISBN-13: 978-1-935208-29-7
ISBN-10: 1-935208-29-2
LCCN: 2016910217

328 Pages
Paperback
Price $32.95 US

Table Of Contents




You can buy this book from: Amazon or Barnes & Noble



Overview
Power Query and Power Pivot are popular tools for Excel. They are easy to learn. This book will get you up and running quickly, by teaching you the basics and then progressing to advanced features. Each chapter covers new concepts and has exercises to help reinforce the concepts. This book is based on Power Query and Power Pivot for Excel 2016.

Power Query is used to automate the process of connecting to and cleaning data that needs to be imported. The data can come from a variety of sources, including spreadsheets, databases and web pages. Power Pivot is used to create a data model once the data has been imported. These free, business intelligence tools provide functionality that Excel does not have.


Table Of Contents

Chapter 1 - Getting Started With Power Query And Power Pivot
Chapter 2 - Getting Started With Power Query
Chapter 3 - Getting Started With The Query Editor
Chapter 4 - Filters, Custom Columns And Formulas
Chapter 5 - Using The Query Editor To Mash Up Data
Chapter 6 - Combining And Grouping Data
Chapter 7 - Quick Tour Of Power Pivot
Chapter 8 - Exploring the Power Pivot Workspace
Chapter 9 - Using The Table Import Wizard
Chapter 10 - Importing Data
Chapter 11 - Linking Tables, Pasting And Appending Data
Chapter 12 - Using Filters, Sorting Data And Creating Relationships
Chapter 13 - Creating Pivot Tables
Chapter 14 - Creating Pivot Charts
Chapter 15 - Enhancing Pivot Tables And Charts







Power Query/Power Pivot Home Page | Errata |



 
Copyright © 2005-2022 Tolana Publishing
All trademarks are the property of their respective owners.