{"product_id":"9780132168229","title":"PowerPivot for the Data Analyst: Microsoft Excel 2010","description":"\u003cp\u003eANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eUse Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eSimple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more. \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eWhatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!\u003c\/p\u003e  \u003cul\u003e  \u003cli\u003eImport and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources\u003c\/li\u003e  \u003cli\u003eAnalyze multiple tables together, without complicated VLOOKUPs \u003c\/li\u003e  \u003cli\u003eFormat, sort, and filter data in the PowerPivot window\u003c\/li\u003e  \u003cli\u003eAdd calculated columns using new DAX functions\u003c\/li\u003e  \u003cli\u003eCreate powerful reports from PowerPivot data—and format them so executives instantly get your point\u003c\/li\u003e  \u003cli\u003eDiscover PivotTable tricks that work even better in PowerPivot\u003c\/li\u003e  \u003cli\u003eControl multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers\u003c\/li\u003e  \u003cli\u003eUse DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields\u003c\/li\u003e  \u003cli\u003eCompare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year.\u003c\/li\u003e  \u003cli\u003eUse Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.\u003c\/li\u003e \u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47119662350576,"sku":"9780132168229","price":33.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780132168229_p0.jpg?v=1763640545","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780132168229","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}