The SQLCAT team just posted the first in what I hope will be a series of PowerPivot architecture posters. This one provides an overview of all of the moving parts in a PowerPivot system. It started small and grew and grew. We knew that we wanted a complete picture and we decided to use all available poster space to have it capture as much info as we could. We had hours and hours of meetings and drafts until we got to the final cut.
Because PowerPivot for Excel and PowerPivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up PowerPivot in one view. This view includes nearly all of the logical architecture components and illustrates how these components work together.
Included in this diagram are the components for:
- PowerPivot for Excel (all of the client components used to build embedded PowerPivot datasets)
- PowerPivot for SharePoint (all of the backend server-side components)
- Browser-Based Clients and their connection to PowerPivot
- Data Import and Data Providers in relation to PowerPivot
- Analysis Services Clients and their ability to connect to PowerPivot
- Timer Jobs, Health and Usage Data Collection in relation to PowerPivot
Here is the small version – the full one is 44” x 34” – WOW!
(click on the graphic to see a larger version)
I have one posted on the wall outside my office and all who pass by just stare at it . . . very cool stuff!
The complete download is available here: http://sqlcat.com/whitepapers/archive/2010/04/23/powerpivot-technical-diagram-powerpivot-client-server-architecture.aspx
Enjoy!
Recent Comments