If a tree falls in the forest and no one is around to hear it, does
it make a sound? Philosophers have debated this question since early in
the 1700s. The key to this highly philosophical question is whether an
object only exists if it perceived.
At this point, you have created a strong and streamlined business
intelligence solution that allows you to gather insight from your data,
but it exists only on your local PC. To increase the impact of this
solution, you’ll need to share it with your team or larger
With the SQL Server 2008 R2 release, Microsoft introduced
PowerPivot, and the term Business Intelligence Continuum was coined to
describe the range of solutions starting with personal BI, progressing to
team BI, and then to organizational BI. Figure 17-1 shows the range of these
solutions and their division across PowerPivot and SQL Server Analysis
Services. In the SQL Server 2012 release, the addition of tabular cubes to
the story makes it even better.
Figure 17-1. Microsoft BI solution stack
In this chapter, we walk through the deployment story from
PowerPivot for Excel to PowerPivot for SharePoint. This allows us to take
a personal BI solution that was created and managed in Microsoft Excel and
promote it to a team BI solution hosted in Microsoft SharePoint. In Chapter 18, we will continue the journey and promote ...
Get Developing Business Intelligence Apps for SharePoint now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.