PowerPivot for the Data Analyst

PowerPivot for the Data Analyst

4.11 - 1251 ratings - Source

Presents information on using the Pivot add-in for Excel 2010 to analyze business data, covering such topics as installation, using DAX functions and measures, importing data, and reporting to SharePoint.Sorting Month Names into the Proper Sequence Just a quick moment of silence while we recall how easy it is to group daily dates up to ... If you have a date field in your original data set, you will want to add two calculated col- umns, as described in Chapter 6, a€œUsing ... but you probably never stopped to consider it: regular Excel pivot tables will automatically sort the pivot tables in custom list sequence.

Title:PowerPivot for the Data Analyst
Author:Bill Jelen
Publisher:Pearson Education - 2010


You Must CONTINUE and create a free account to access unlimited downloads & streaming