Getting Started With PowerPivot For Excel 2010 - Softcover

Inhaltsangabe

(A new version is available for Power Pivot For Excel 2016. See ISBN 978-1935208273 and 978-1935208297) PowerPivot is a free new add-on for Excel 2010 that is used to enhance pivot tables and pivot charts. PowerPivot brings self-service business intelligence to the desktop by allowing you to connect to a variety of data sources. This functionality is used to enhance data analysis in Excel. The purpose of PowerPivot for Excel is to help Excel end users access data in multi-dimensional databases without having extensive training and knowledge of this type of data modeling. Additionally, PowerPivot has a new programming language called Data Analysis Expressions (DAX). This language adds data manipulation functionality to Excel formulas, including analysis and complex grouping that is above the formula capabilities that are available in Excel. DAX takes the formulas that you are use to creating for pivot tables and pivot charts in Excel to a whole new level. In a user friendly, step-by-step way, you will learn the following: How to use the Table Import Wizard, How to import data into PowerPivot, How to create pivot tables and pivot charts using data in PowerPivot, How to create DAX formulas and much more.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.