PowerPivot for the data analyst : Microsoft Excel 2010 By Bill Jelen.

By: Jelen, BillSeries: MrExcel libraryPublication details: Indianapolis: Que 2010Description: xiii, 311 p. : illISBN: 9780789743152 (pbk.); 0789743159Subject(s): BUSINESS INTELIGENCE--COMPUTER PROGRAMS | MICROSOFT EXCEL (COMPUTER FILE) | BUSINESS--COMPUTER PROGRAMSLOC classification: HF 5548.4.M523 Jen
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.
Tags from this library: No tags from this library for this title.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Home library Call number Materials specified Status Date due Barcode
MONOGRAPH MONOGRAPH CBU-MAIN LIBRARY, KITWE.
HF 5548.4.M523 Jen (Browse shelf(Opens below)) Available 748706

Includes bibliographical references and index.

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.

There are no comments on this title.

to post a comment.