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 componets work together.
Included in this diagram are the components for:
-
PowerPivot for Excel
-
PowerPivot for SharePoint
-
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
Because this poster is very large (44” x 34”) reading it in an online format such as a graphic becomes impractical, so we offer it as a downloadable Microsoft Visio, PDF, or XPS document.
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQL Customer Advisory Team (SQLCAT) - DW/BI Group. He has more than 13 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of "Professional Microsoft PowerPivot for Excel and SharePoint", “Professional Microsoft SQL Server Analysis Services 2008 with MDX”, “Professional Microsoft SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2009)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Blog (http://dennyglee.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
