Instant Creating Data Models with PowerPivot How-to

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

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.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$9.10
RRP $12.99
Save 29%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 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
$0.00
$9.10
$29.99 p/m after trial
RRP $12.99
Subscription
eBook
Start 30 Day Trial

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
Full Stack Development with JHipster Book Cover
Full Stack Development with JHipster
$ 35.99
$ 25.20
Buy 2 for $26.60
Save $22.38
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.

Table of Contents

Chapter 1: Instant Creating Data Models with PowerPivot How-to
Installation (Simple)
Importing data from the database (Advanced)
Importing data from other files (Simple)
Filtering the data to be imported (Intermediate)
Creating a pivot table (Simple)
Creating a pivot chart (Simple)
Managing data relationships (Simple)
Adding new custom columns (Intermediate)
Making the data look presentable (Simple)
Publishing as Excel (Simple)

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

Table of Contents

Chapter 1: Instant Creating Data Models with PowerPivot How-to
Installation (Simple)
Importing data from the database (Advanced)
Importing data from other files (Simple)
Filtering the data to be imported (Intermediate)
Creating a pivot table (Simple)
Creating a pivot chart (Simple)
Managing data relationships (Simple)
Adding new custom columns (Intermediate)
Making the data look presentable (Simple)
Publishing as Excel (Simple)

Book Details

ISBN 139781849689564
Paperback58 pages
Read More

Read More Reviews

Recommended for You

PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
The Microsoft Outlook Ideas Book Book Cover
The Microsoft Outlook Ideas Book
$ 14.99
$ 10.50
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
$ 28.00