LEADER 00000cam a2200613Mi 4500 001 ocn945217640 003 OCoLC 005 20180130104718.8 006 m o d 007 cr mn||||||||| 008 160212t20162016flua o 001 0 eng d 019 945375675 020 9781615473496|q(ePub) 020 1615473491 020 9781615472260|q(PDF) 020 1615472266 020 9781615471263|q(Mobi) 020 161547126X 020 |z9781615470396|q(print) 035 (OCoLC)945217640|z(OCoLC)945375675 040 B24X7|beng|erda|epn|cB24X7|dOCLCO|dN$T|dOCLCF|dD6H|dOCLCQ |dOCLCO|dLIV 049 RIDW 050 4 HF5548.4.M523|bC65 2016eb 072 7 COM|x051380|2bisacsh 082 04 005.54|223 090 HF5548.4.M523|bC65 2016eb 100 1 Collie, Rob,|eauthor. 245 10 Power Pivot and Power BI :|bthe Excel user's guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016 / |cRob Collie, Avi Singh. 250 2nd edition. 264 1 Merritt Island FL, USA :|bHoly Macro! Books,|c[2016] 264 4 |c©2016 300 1 online resource :|billustrations 336 text|btxt|2rdacontent 337 computer|bc|2rdamedia 338 online resource|bcr|2rdacarrier 500 Includes index. 520 Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before. This book tackles DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages" whether they use a standard, fiscal, or a complete custom calendar. --|cEdited summary from book. 588 0 Online resource; title from title screen (Books24x7.com, viewed February 12, 2016). 590 eBooks on EBSCOhost|bEBSCO eBook Subscription Academic Collection - North America 630 00 Microsoft PowerPivot (Computer file) 630 00 Microsoft Excel (Computer file) 630 07 Microsoft Excel (Computer file)|2fast|0(OCoLC)fst01366659 630 07 Microsoft PowerPivot (Computer file)|2fast |0(OCoLC)fst01915392 650 0 Business|xData processing. 650 0 Business intelligence. 655 4 Electronic books. 700 1 Singh, Avi,|eauthor. 856 40 |uhttps://rider.idm.oclc.org/login?url=http:// search.ebscohost.com/login.aspx?direct=true&scope=site& db=nlebk&AN=1164358|zOnline eBook. Access restricted to current Rider University students, faculty, and staff. 856 42 |3Instructions for reading/downloading the EBSCO version of this eBook|uhttp://guides.rider.edu/ebooks/ebsco 948 |d20180209|cEBSCO|tEBSCOebooksacademic NEW 1-29-18|lridw 994 92|bRID