TY - BOOK AU - Jelen,Bill TI - PowerPivot for the data analyst: Microsoft Excel 2010 T2 - MrExcel library SN - 9780789743152 (pbk.) PY - 2010/// CY - Indianapolis, Ind. PB - Que KW - Microsoft Excel (Computer file) KW - Business intelligence KW - Computer programs KW - Business N1 - 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 ER -