By powerpivotgeek (dwickert@microsoft.com), on November 17th, 2009
For several reasons I have recently been playing around with installing PowerPivot for SharePoint on various configurations. See an earlier post about taking PowerPivot off the network – learned that one the hard way when I took my laptop to the SharePoint Conference this month. Well, I ran into another one – installing PowerPivot on [...]
By powerpivotgeek (dwickert@microsoft.com), on November 15th, 2009
Ok. This post will be a bit complicated but stick with me. Hopefully, in the end, all will be clear. And the geek in you will love it.
One of the things that users just kind of glance over, but don’t realize the implication, is the fact that PowerPivot is a copy of the data. If [...]
By powerpivotgeek (dwickert@microsoft.com), on November 12th, 2009
In this posting we will take a more detailed technical look at how the data refresh facility works and the steps that it takes to accomplish a data refresh cycle. Rather than starting with the “Manage data refresh” page, we will assume that you know how to setup a schedule – in this posting, we [...]
By powerpivotgeek (dwickert@microsoft.com), on November 11th, 2009
Well, I have a fun one today. We get asked all of the time about how the PowerPivot add-in works. Particularly how it relates to the SSAS components that BI Pros are used to, e.g. making connections to SSAS. As I am getting ready to write an architecture overview blog posting for the PowerPivot [...]
By powerpivotgeek (dwickert@microsoft.com), on November 9th, 2009
You have seen all of the cool demos – millions of rows of data in a single workbook. It is the hallmark of many PowerPivot keynote and session demos at conferences these days. It is way cool to see that much data being moved around so easily. The obvious question (which us technical geeks get [...]
By powerpivotgeek (dwickert@microsoft.com), on November 9th, 2009
SQL Server 2008 R2 released to the web today for TechNet and MSDN subscribers. According to the announcement, non-subscribers will be able to access the download Wednesday, November 11th. To install PowerPivot for SharePoint you will need SharePoint 2010 beta (being released next week or the week after). For the matching PowerPivot for Excel CTP3, [...]
By powerpivotgeek (dwickert@microsoft.com), on November 7th, 2009
I just read Rob Collie’s posting about a Forrester report. And I just have to jump in with my two cents:
http://blogs.forrester.com/business_process/2009/11/ten-strong-hints-your-enterprise-may-not-have-a-bi-strategy.html
by Boris Evelson
Your end users keep pointing to IT as the source of most BI problems – Oh, the blame game. It can be hot and furious. The very fact that end users feel that [...]
By powerpivotgeek (dwickert@microsoft.com), on November 7th, 2009
In the first of our “A Peek Inside” articles, let’s take an easy one. When using a client makes a connection to a PowerPivot workbook that is stored inside SharePoint, how do you suppose the connection is made? If this was a regular SQL Server Analysis Services database then there are two options: either [...]
By powerpivotgeek (dwickert@microsoft.com), on November 7th, 2009
From the recent Q&A that I have been having with customers at the SharePoint Conference last week in Las Vegas, and this week at SQL PASS in Seattle, it is clear that there is a lot of interest in how PowerPivot works inside. Thus from time to time I am going to post a series [...]
By powerpivotgeek (dwickert@microsoft.com), on November 6th, 2009
Now this is a cool poster. SharePoint 2010 has a new shared services architecture that PowerPivot uses extensively. We have written both a new web services service and a Windows service wrapper around the SSAS msmdsrv.exe. I thought you might find it useful, or at least fun, to see how SharePoint is approaching the distributed [...]
Recent Comments