{"product_id":"powerpivot-for-the-data-analyst","title":"PowerPivot for the Data Analyst","description":"\u003cp\u003e\u003cstrong\u003eThe full text downloaded to your computer\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eWith eBooks you can:\u003c\/p\u003e \u003cul\u003e \u003cli\u003esearch for key concepts, words and phrases \u003c\/li\u003e\n \u003cli\u003emake highlights and notes as you study \u003c\/li\u003e\n \u003cli\u003eshare your notes with friends \u003c\/li\u003e\n \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eeBooks \u003c\/strong\u003eare downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps. \u003c\/p\u003e \u003cp\u003eUpon purchase, you'll gain instant access to this eBook.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eTime limit\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eThe \u003cstrong\u003eeBooks\u003c\/strong\u003e products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.\u003c\/p\u003e Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyse immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! \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\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\n \u003cli\u003eAnalyse multiple tables together, without complicated VLOOKUPs \u003c\/li\u003e\n \u003cli\u003eFormat, sort, and filter data in the PowerPivot window \u003c\/li\u003e\n \u003cli\u003eAdd calculated columns using new DAX functions \u003c\/li\u003e\n \u003cli\u003eCreate powerful reports from PowerPivot data–and format them so executives instantly get your point \u003c\/li\u003e\n \u003cli\u003eDiscover PivotTable tricks that work even better in PowerPivot \u003c\/li\u003e\n \u003cli\u003eControl multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers \u003c\/li\u003e\n \u003cli\u003eUse DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields \u003c\/li\u003e\n \u003cli\u003eCompare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year. \u003c\/li\u003e\n \u003cli\u003eUse Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months. \u003c\/li\u003e\n \u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46286829912302,"sku":"9780132168229","price":37.94,"currency_code":"AUD","in_stock":true}],"url":"https:\/\/bookland.com.au\/products\/powerpivot-for-the-data-analyst","provider":"Book Land AU","version":"1.0","type":"link"}