Feeds:
Posts
Comments

Posts Tagged ‘Excel’

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 »

A Primer on Hadoop (from the Microsoft SQL Community perspective)

Posted in BigData, tagged , , , , , on March 27, 2012 | 3 Comments »

For a quick primer on Hadoop (from the perspective of the Microsoft SQL Community), as well as Microsoft Hadoop on Azure and Windows, check out the SlideShare.NET presentation below. Above the cloud: Big Data and BI View more PowerPoint from Denny Lee Note, as well, there is a great end-to-end Microsoft Hadoop on Azure and [...]

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

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

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers