Book Image

Instant Creating Data Models with PowerPivot How-to

By : Taehyung Lee
Book Image

Instant Creating Data Models with PowerPivot How-to

By: Taehyung Lee

Overview of this book

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 (7 chapters)

Chapter 1. Instant Creating Data Models with PowerPivot How-to

Welcome to Instant Creating Data Models with PowerPivot How-to book. Whether the user is a small-business owner or an Excel pro, the features of PowerPivot will provide a strong business analytics tool that can help the user review past performance, identify trends, and predict future conditions. This book will guide the user in using all functionalities of Microsoft PowerPivot for Excel—from the installation steps for Excel 2010 to creating pivot tables and charts by setting up custom data and data relationships. So, let's get started!