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
What you’ll 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 PowerPivot’s 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.
Fixed Mobile Convergence Handbook
Requirements for next generation networks (NGNs) are fueling an architectural evolution. Service providers are obliged to give users access to content anytime, anyhow, anywhere, on any device. This requires a converged infrastructure in which users across multiple domains can be served through a single unified domain and all network services...
Microsoft(R) SQL Server(R) 2008 Administrator's Pocket Consultant
From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition is the...
Taking Charge of Your VoIP Project
Voice over IP (VoIP) is the telephone system of the future. Problem is, VoIP is not yet widely deployed, so there are few skilled practitioners today. As you make your move to VoIP, how will you know how to make VoIP work and keep it working well? What changes will you need to make without disrupting your business? How can...
jQuery: Novice to Ninja
No matter what kind of ninja you are—a cooking ninja, a corporate lawyer ninja, or
an actual ninja ninja—virtuosity lies in first mastering the basic tools of the trade.
Once conquered, it’s then up to the full-fledged ninja to apply that knowledge in
creative and inventive ways.
Code Division Multiple Access (CDMA) The objective of this book is to provide the reader with a concise introduction to the use of spread spectrum waveforms in multiple user systems, often termed code division multiple access or CDMA. The book has been an outgrowth of course notes presented in a graduatelevel course on spread spectrum communications. This book should provide...