PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston

Description: PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description 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 youll encounter when using PowerPivot. Each chapter takes you through a solution technique thats 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 Notes Covers an exciting new technology that appeals strongly to Excel and SharePoint users. Author is a nominee to the Microsoft Business Intelligence Partner Advisory Council. Content is solution-oriented, showing readers how to perform specific analysis tasks. Author Biography Barry Ralston is the chief architect for business intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft s Virtual Technical Specialist (VTS) for business intelligence, responsible for assisting in Alabama, Mississippi, and northwest Florida in sales efforts including customer meetings, software demonstrations and proof-of-concept efforts. Barry s client successes include: American Cast Iron Pipe Company, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac. Table of Contents * 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 Long Description 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 youll encounter when using PowerPivot. Each chapter takes you through a solution technique thats 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 What youll learn Install and verify the PowerPivot software Integrated existing, available data to deliver business intelligence Leverage Time Intelligence to report change over time Write Data Analysis Expressions (DAX) to create custom measures Identify and implement solutions for role-playing dimensions Recognize and work-around PowerPivots missing features Who this book is for PowerPivot Solutions for Excel and SharePoint 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. Table of Contents 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 Feature Pivot for Business Intelligence Using Excel and Share. Point takes a scenario-based approach to helping you master Microsofts groundbreaking technology for data mining on the desktop. Details ISBN143023380X Year 2011 ISBN-10 143023380X ISBN-13 9781430233800 Format Paperback Imprint APress DEWEY 005.54 Short Title POWERPIVOT FOR BUSINESS INTELL Language English Media Book Author Barry Ralston Pages 304 Publisher Springer-Verlag Berlin and Heidelberg GmbH & Co. KG Edition 1st Place of Publication Berlin Country of Publication Germany Series Apresspod DOI 10.1007/978-1-4302-3381-7 UK Release Date 2011-04-06 Publication Date 2011-04-06 Illustrations XIII, 304 p. Edition Description 1st ed. Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:96226083;

Price: 93.48 AUD

Location: Melbourne

End Time: 2025-01-05T03:28:01.000Z

Shipping Cost: 11.76 AUD