. “I caught a fish thiiiiis biiig” – On stage with Ted Kummert during the PASS 2011 Keynote on Big Data (thanks to Karen Lopez @datachick for the pic) . . During the PASS 2011 Keynote (back in October 2011), I had the honor to demo Hadoop on Windows / Azure. One of the key [...]
Archive for the ‘PowerPivot’ Category
Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
Posted in BigData, Cloud, PowerPivot, SQL, tagged Excel, Hadoop, hive on January 21, 2012 | 7 Comments »
Using SQL Server PowerPivot for Excel to Analyze SAP Data
Posted in Analysis Services, PowerPivot, tagged Excel, SAP on January 28, 2011 | 1 Comment »
Sorry! I’ve been offline and haven’t blogged or responded to comments for quite some time and frankly I don’t have any good excuses: I fell asleep My dog ate my WordPress login account info (never mind that I don’t have a dog yet) I was working (yeah, right) I used the TARDIS to back in [...]
Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!
Posted in Analysis Services, PowerPivot, tagged Performance on November 3, 2010 | Leave a Comment »
If you’re online this week, and admittedly the last few weeks I have been extremely dormant, you may know that next week is the 2010 SQL Server PASS Summit! It’s one of the most important SQL Server conferences and my team, SQLCAT, will be out in force. Heck, we’ll be in our green SQLCAT shirts [...]
Can I access PowerPivot via a data access API?
Posted in PowerPivot, tagged Excel, FAQ, Internals, SharePoint on October 27, 2010 | 2 Comments »
I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store? I figured that a lot of people will eventually ask this question (heck, that’s what I had asked when I had first heard about PowerPivot). The answer as of 2010 [...]
PowerPivot for SharePoint: Existing Farm Installation
Posted in PowerPivot, tagged Configuration, SharePoint on September 14, 2010 | Leave a Comment »
So the fate… of the entire human race depends upon my wild guess — Doctor Gaius Baltar (Battlestar Galactica) Actually, the quote that I really wanted to say was “So the fate… of the entire PowerPivot deployment depends upon my wild a** guess?! WTF!!!” Yet, this is not the time for [...]
PowerPivot for SharePoint: Single Server Installation
Posted in PowerPivot, tagged Installation, SharePoint on August 30, 2010 | 3 Comments »
A long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice. Yet, even [...]
Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
Posted in PowerPivot, tagged SharePoint, Troubleshooting on August 21, 2010 | 9 Comments »
One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into a PowerPivot for Excel workbook. To get this thing to work, one of the key things that I remind people regularly is to make sure [...]
PowerPivot Technical Diagram: PowerPivot Security Architecture
Posted in PowerPivot, tagged Architecture, SharePoint on August 18, 2010 | Leave a Comment »
Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN. To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx Enjoy!
At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?
Posted in PowerPivot, tagged Book, Design on July 28, 2010 | Leave a Comment »
Are you coming to TechReady and interested in getting yourself a PowerPivot Technical Diagram: PowerPivot Client/Server Architecture? Well, make sure to come to Dave Wickert and my session for a chance to get a printed copy of this awesome diagram!: BIN403: PowerPivot for SharePoint Power Hour…so powerful its 75min 7/30 10:30-11:45am, Sheraton Metro B You’ll [...]
PowerPivot, Analysis Services, and TechReady….and coffee!
Posted in Analysis Services, PowerPivot, tagged Internals, Miscellaneous on July 26, 2010 | Leave a Comment »
If you’re going to TechReady 11 at the Washington State Convention Center this week in warm, sunny Seattle – first of all, welcome to the Emerald City! And if you’re a coffee snob like me (to give you background, not only am a long time Seattle resident so I pretty much breathe coffee – but [...]

