Tag: PowerPivot Power Pivot Microsoft SharePoint BI Excel Business Intelligence Denali Beta

Comparing Access to PowerPivot

Here’s a question that comes up with increasing frequency:  “PowerPivot seems kinda similar to Access in many ways, what’s the difference?” Why Does the Question Come Up? Some of you […]

Written by on November 17, 2011

PowerPivot V2 CTP3!

CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”

Written by on July 12, 2011

DAX – A/B Campaign Analysis with Start & End Date Slicers

“Because every good story has a beginning, a middle, and an end.”

Awhile back I posted about promotional campaign analysis factoring in seasonal trends. Now let’s look at another flavor of campaign analysis: comparing results when a campaign is active versus when it was not. Sometimes this is referred to as “A/B Testing.

Written by on April 13, 2011

Five Observations From SQL PASS

 Wow, what a trip.  I barely slept.  Let’s get right down to it:  summary of my thoughts on the whole thing. 1) The Future of MS BI is (Basically) PowerPivot […]

Written by on November 12, 2010

The “Ferrari” of PowerPivot Books

UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.

Written by on October 26, 2010

Slicers and pivot update performance

-Posted by Rob Collie OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodies we can […]

Written by on July 2, 2010

Welcome Query designers!

 -Guest Post by the one and only Dany Hoter! We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years? Suffice to […]

Written by on June 14, 2010

  • 1
  • 2