| Document Type
|
:
|
BL
|
| Record Number
|
:
|
585521
|
| Doc. No
|
:
|
GBB022028b414740
|
| Main Entry
|
:
|
Jelen, Bill
|
| Title & Author
|
:
|
PowerPivot for the data analyst : : Microsoft Excel 2010 /\ Bill Jelen
|
| Publication Statement
|
:
|
Indianapolis, Ind. :: Que,, c2010
|
| Series Statement
|
:
|
MrExcel library
|
| Page. NO
|
:
|
xiii, 311 p. :: ill. ;; 24 cm
|
| ISBN
|
:
|
9780789743152
|
|
|
:
|
: 0789743159
|
| Bibliographies/Indexes
|
:
|
Includes bibliographical references and 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
|
:
|
Business intelligence-- Computer programs
|
| Subject
|
:
|
Business-- Computer programs
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
005.54
|
| LC Classification
|
:
|
HF5548.4.M523J4544 2010
|