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. [...]
Archive for April, 2010
PowerPivot Technical Diagram: PowerPivot Client/Server Architecture
Posted in PowerPivot, tagged Architecture on April 28, 2010 | Leave a Comment »
PowerPivot has RTM’ed…what’s next?
Posted in Uncategorized on April 23, 2010 | 2 Comments »
Woo hoo! It actually RTM’ed a couple days ago and I did tweet about it but neglected to also blog about it. As previously blogged, we have the Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment which I also chatted about in the SQL Server posting: How do I prepare for PowerPivot? What’s next? (atleast for the next [...]
Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment
Posted in PowerPivot, tagged Deployment on April 15, 2010 | Leave a Comment »
What’s great about the newly published “Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment” is that it is a guide that has the end-to-end architecture design of PowerPivot for Excel and PowerPivot for SharePoint including hardware requirements, topologies, and deployment planning. If you want to know more about PowerPivot Planning and Deployment – this [...]
Dude, Where’s my PowerPivot workbook?
Posted in PowerPivot, tagged Connectivity, Excel Services, SharePoint on April 14, 2010 | Leave a Comment »
In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or [...]
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Posted in PowerPivot, SharePoint, tagged Active Directory, Configuration, Delegation, Excel Services, FAQ, Troubleshooting, Upgrade on April 8, 2010 | 8 Comments »
Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written [...]
Update SharePoint 2010 Farm Credentials Tips
Posted in PowerPivot, SharePoint, tagged Configuration on April 8, 2010 | 4 Comments »
Within your SharePoint environment – such as your PowerPivot for SharePoint single server install – a common task that you will need to do is to update the SharePoint Farm credentials when the password changes. You may be able to do this automatically by using the new SharePoint 2010 feature to plan automatic password change. [...]
Ramblings about missing time … and #PowerPivot sneak peek!
Posted in PowerPivot, tagged Book, Configuration, Connectivity, Design, Excel Services, FAQ, Internals, SharePoint, Troubleshooting on April 5, 2010 | 4 Comments »
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]

