Free Sample
+ Collection

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.
RRP $12.99

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849689564
Paperback58 pages

About This Book

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results
  • Detailed, step-by-step interactive tutorial guide to learning PowerPivot
  • Carefully organized topics for users of all levels
  • Learn how to make your data accessible and attractive

Who This Book Is For

This is an introductory book on PowerPivot for basic Excel users who handle lots of data and are willing to go beyond the limitations of Excel without the need to learn a new language from scratch.

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

In Detail

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.


Read More