Instant Creating Data Models with PowerPivot How-to

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot.

Instant Creating Data Models with PowerPivot How-to

Leo Taehyung Lee

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot.
eBook
$9.10
RRP $12.99
Save 29%
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$9.10
RRP $12.99
eBook

Frequently bought together


Instant Creating Data Models with PowerPivot How-to Book Cover
Instant Creating Data Models with PowerPivot How-to
$ 12.99
$ 9.10
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Buy 2 for $19.10
Save $17.88
Add to Cart

Book Details

ISBN 139781849689564
Paperback58 pages

Book Description

Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer’s powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.

Instant Creating Data Models with PowerPivot How-to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.

Instant Creating Data Models with PowerPivot How-to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.

What You Will Learn

  • Install a database and import/export data freely
  • Collect and combine data across various sources and formats
  • Understand relationships between various data
  • Develop complex tables and models for future analysis
  • Design meaningful charts and tables easy for everyone to understand
  • Write custom codes to modify data to a required form
  • Extend PowerPivot with external programs for further collaboration

Authors

Book Details

ISBN 139781849689564
Paperback58 pages
Read More

Read More Reviews

These popular $10 titles might interest you

PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Raspberry Pi Home Automation with Arduino Book Cover
Raspberry Pi Home Automation with Arduino
$ 17.99
$ 3.60
Learning Android Google Maps Book Cover
Learning Android Google Maps
$ 39.99
$ 10.00