01517nam a2200289 a 4500 vtls000056490 KUKTEM 20251125093018.0 111201t2010 inua f b 001 0 eng d 9780789743152 (pbk.) 0789743159 201203291023 fauzi 201112011145 sri UMP HF5548.4.M523 J454 2010 Jelen, Bill PowerPivot for the data analyst : Microsoft Excel 2010 / Bill Jelen Indianapolis, Ind. : Que, c2010 xiii, 311 p. : ill. ; 24 cm. MrExcel library 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 Microsoft Excel (Computer file) Business intelligence Computer programs Business Computer programs MrExcel library 0 0 0 0 20000 20000 2019-09-04 102.38 0 HF5548.4.M523 J454 2010 0000063753 2019-09-04 00:00:00 1 102.38 2019-09-04 OPEN VIRTUA40 60520 60526 VTLSSORT0080*0200*0201*0400*0900*1000*2450*2600*3000*4900*5040*5050*6300*6500*6501*8300*9991