{"product_id":"9781430233817","title":"PowerPivot for Business Intelligence Using Excel and SharePoint","description":"\u003cp\u003ePowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.\u003c\/p\u003e\u003cp\u003e\u003cem\u003ePowerPivot for Business Intelligence Using Excel and SharePoint\u003c\/em\u003e is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCovers the leading technology for bringing data analytics to the desktop \u003c\/li\u003e\n\u003cli\u003ePresents real-world solutions to real-world scenarios \u003c\/li\u003e\n\u003cli\u003eWritten by a Microsoft Virtual Technical Specialist (VTS) for business intelligence \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eInstall and verify the PowerPivot software \u003c\/li\u003e   \u003cli\u003eIntegrated existing, available data to deliver business intelligence \u003c\/li\u003e   \u003cli\u003eLeverage Time Intelligence to report change over time \u003c\/li\u003e   \u003cli\u003eWrite Data Analysis Expressions (DAX) to create custom measures \u003c\/li\u003e   \u003cli\u003eIdentify and implement solutions for role-playing dimensions \u003c\/li\u003e   \u003cli\u003eRecognize and work-around PowerPivot’s missing features \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003ePowerPivot Solutions for Excel and SharePoint\u003c\/em\u003e is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eGetting Started with PowerPivot for Excel \u003c\/li\u003e   \u003cli\u003eHello World, PowerPivot Style \u003c\/li\u003e   \u003cli\u003eCombining Data Sources \u003c\/li\u003e   \u003cli\u003eData Analysis Expressions \u003c\/li\u003e   \u003cli\u003eA Method to the Madness \u003c\/li\u003e   \u003cli\u003eInstalling PowerPivot for SharePoint \u003c\/li\u003e   \u003cli\u003eCollaboration, Version Control, and Management \u003c\/li\u003e   \u003cli\u003ePowerPivot As a Data Source \u003c\/li\u003e   \u003cli\u003ePowerPivot and SQL Server Reporting Services \u003c\/li\u003e   \u003cli\u003ePowerPivot and Predictive Analytics \u003c\/li\u003e   \u003cli\u003eTips, Tricks, and Traps \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47180960760048,"sku":"9781430233817","price":31.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430233817_p0.jpg?v=1763753323","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430233817","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}