00000cmm a22000004a 4500 UP-99796217611236428 Buklod 20230215085534.0 m go j cr |n |||auu|a 110713s2011 xxu u | eng d 9781430233817 (eBook) (iLib)UPD-00215705693 DLC DML eng DMLUC HF 5548.4 M5258 R35 2011eb Ralston, Barry PowerPivot for business intelligence using excel and SharePoint [electronic resource] Barry Ralston. Berkeley, CA Apress 2011. 1 online resource (xiii, 288 p.) ill. Getting started with PowerPivot for Excel -- Hello world, PowerPivot style -- Combining data sources -- Data analysis expressions -- A method to the madness -- Installing PowerPivot for SharePoint -- Collaboration, version control, and management -- PowerPivot as a data source -- PowerPivot and SQL server reporting services -- PowerPivot and predictive analytics -- Tips, tricks, and traps. IP-based subscription, access limited to within on-campus computer network. Access via Electronic Resources of the UPD University Library Website. PowerPivot 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. PowerPivot for Business Intelligence Using Excel and SharePoint 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. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence. Electronic reproduction. New York SpringerLink 2011. Available via World Wide Web through SpringerLink. Microsoft PowerPivot (Computer file) Microsoft SharePoint (Electronic resource) Microsoft Excel (Computer file) Business intelligence--Computer programs. Electronic books. SpringerLink (Online service). Electronic Resource Available for University of the Philippines Diliman via SpringerLink. Click here to access http://dx.doi.org/10.1007/978-1-4302-3381-7 FO Monograph UPD DMLR Electronic Resource