Feeds:
Posts
Comments

Archive for the ‘PowerPivot’ Category

A Primer on PowerPivot Topologies and Configurations

Posted in PowerPivot, tagged , , , on March 29, 2012 | 2 Comments »

For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!

Read Full Post »

BI and Big Data–the best of both worlds!

Posted in Analysis Services, BigData, PowerPivot, Random Thoughts, tagged , , , , on March 1, 2012 | 1 Comment »

As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop.  It started off with Dave Campbell’s question: Do we have the tools we need to navigate the New World of Data?.  And some of the tooling call outs specific to Microsoft include references to PowerPivot, [...]

Read Full Post »

Connecting Power View to Hadoop on Azure–An #awesomesauce way to view Big Data in the Cloud

Posted in BigData, PowerPivot, Reporting Services, tagged , , on February 10, 2012 | 3 Comments »

The post Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud provided the step-by-step details on how to connect PowerPivot to your Hadoop on Azure cluster.   And while this is really powerful, one of the great features as part of SQL Server 2012 is Power View (formerly known [...]

Read Full Post »

Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud

Posted in BigData, Cloud, PowerPivot, SQL, tagged , , on January 21, 2012 | 12 Comments »

. “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 [...]

Read Full Post »

Using SQL Server PowerPivot for Excel to Analyze SAP Data

Posted in Analysis Services, PowerPivot, tagged , 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 [...]

Read Full Post »

Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!

Posted in Analysis Services, PowerPivot, tagged 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 [...]

Read Full Post »

Can I access PowerPivot via a data access API?

Posted in PowerPivot, tagged , , , 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 [...]

Read Full Post »

PowerPivot for SharePoint: Existing Farm Installation

Posted in PowerPivot, tagged , 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 [...]

Read Full Post »

PowerPivot for SharePoint: Single Server Installation

Posted in PowerPivot, tagged , 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 [...]

Read Full Post »

Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

Posted in PowerPivot, tagged , 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 [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers