Feeds:
Posts
Comments

Posts Tagged ‘Excel’

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 | 7 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 »

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, you are so insensitive! (case that is)

Posted in PowerPivot, tagged , , , on June 18, 2010 | 11 Comments »

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive. For example, if you import the table below: Within the PowerPivot window, you’ll notice that the lower case [...]

Read Full Post »

Pivots, Cube Formulas, Named Sets … Oh my!

Posted in PowerPivot, tagged , , on February 4, 2010 | 5 Comments »

Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face (Joker picture not-withstanding).  He’s called me out, challenged my geek hood, and sliced / diced my postings (pun intended).  I was going to let this [...]

Read Full Post »

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)

Posted in PowerPivot, tagged , on January 31, 2010 | 6 Comments »

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1.  What is handy about using named sets is that [...]

Read Full Post »

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)

Posted in PowerPivot, tagged , on January 28, 2010 | 6 Comments »

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1.  What is handy about using named sets is that [...]

Read Full Post »

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)

Posted in PowerPivot, tagged , on January 27, 2010 | 12 Comments »

Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set and create reports based on that.  One approach is to create a rank function within PowerPivot as noted in a Rank function thread on the [...]

Read Full Post »

Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

Posted in PowerPivot, tagged , , on January 6, 2010 | 7 Comments »

When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file.  This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the [...]

Read Full Post »

Understanding why an Excel PowerPivot workbook is so large

Posted in PowerPivot, tagged , on November 7, 2009 | Leave a Comment »

During my and Dave Wickert’s SQLPASS session (SQLCAT: A Preview to PowerPivot Best Practices), we had shown to the audience how to view and better understand the PowerPivot database file structure within the Excel workbook.  First of all, I’d like to give credit where credit is due – and the thanks really should go to [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.

Join 869 other followers