Items related to Mastering Excel: Power Pivot

Mastering Excel: Power Pivot - Softcover

Book 11 of 30: Mastering Excel

Moore, Mark

 
9781546908609: Mastering Excel: Power Pivot
Softcover
ISBN 10: 1546908609 ISBN 13: 9781546908609
Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

Power Pivot is the keystone of Excel data analysis. Use this amazing tool to build relationships in your data and create reports not previously possible.Once you have data from different sources imported into Excel via Power Query/MS Query, then what? How do you relate your inventory information to your sales and then to your customers? VLOOKUPS, more copy/paste manual steps (which are more opportunities for errors).Do none of that. Load the data into Power Pivot. Thousands, even millions of rows of data are not an issue. Then you build relationships between the data, create hierarchies, even add time based intelligence. This is a whole new world of data analysis.The lesson comes with several sample workbooks that you can use to practice as you read.

"synopsis" may belong to another edition of this title.

Publisher
CreateSpace Independent Publishing Platform
Publication date
2017
Language
English
ISBN 10 
1546908609
ISBN 13 
9781546908609
Binding
Paperback
Number of pages
76