PowerPivot for the data analyst : Microsoft Excel 2010
INITIAL_TITLE_SRCH:
PowerPivot for the data analyst : Microsoft Excel 2010
AUTHOR:
Jelen, Bill
ISBN:
9780789743152
PUBLICATION_INFO:
Indianapolis, Ind. : Que, 2010
PHYSICAL_DESC:
xiii, 311 p. : ill. ; 24 cm
SERIES:
MrExcel library
SERIES_TITLE:
MrExcel library
GENERAL_NOTE:
Includes index
CONTENTS:
Downloading and installing PowerPivot -- The promise of PowerPivot -- Why wouldn't I build every future pivot table in PowerPivot? -- Getting your data into PowerPivot -- Creating and managing relationships -- Using data sheet view -- Building pivot tables -- Cool tricks native to pivot tables -- Cool tricks new with PowerPivot -- Using DAX for aggregate functions -- Using DAX for date magic -- Named sets, GetPivotData, and cube formulas -- Final formatting : making the report not look like Excel -- Upgrading to PowerPivot server.
SUBJECT:
| Microsoft Excel (Computer file) |
| Business intelligence -- Computer programs |
| Business -- Computer programs |