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.
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.99p/m after trial
RRP $12.99
Subscription
eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

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

Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 10.00
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Data Visualization: a successful design process Book Cover
Data Visualization: a successful design process
$ 17.99
$ 10.00
Practical Data Science Cookbook Book Cover
Practical Data Science Cookbook
$ 29.99
$ 10.00
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Microsoft Tabular Modeling Cookbook Book Cover
Microsoft Tabular Modeling Cookbook
$ 32.99
$ 10.00