Friday Bonus: UFO Sightings & Hallucinogen Use

  I didn’t have this ready in time for the contest Microsoft was running, and I’m not sure they would have wanted this to represent PowerPivot in an “official” sense so it likely wouldn’t have won anyway. But here it is folks – a data mashup of UFO sightings versus Hallucinogenic drug usage.  All sourced from real data, for the United States only, between 1930 and 2000. To place everything on the same scale, all measures are “indexed” against their…

Read the Rest

Couldn’t Resist… Parameterized PowerPivot Report!

In the intro to David’s guest post below I mentioned some new applications we are building.  Check out a PowerPivot report where, in the browser, you can type in a SKU number and get a full dashboard for just that product! Click for Larger Version Much respect to our resident Data Junkie Monkey, aka DJ Monkey, for pulling this together.

Read the Rest

A Lesson in A-G-I-L-I-T-Y

A case study I just have to share Over the past year, “Agility” has become quite a theme on this blog.  It’s fair to say that I just keep hammering it, over and over.  But I recently had my eyes opened as to what “extreme” PowerPivot agility can look like. Let’s put it in football terms:  it’s like I’ve been going around telling everyone how they should be less like the 400+ pound Aaron Gibson and more like the nimble,…

Read the Rest

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.” Let’s start by showing what the results can look like:  a report that has two date slicers – one where you select the Start Date of…

Read the Rest

Guest Post: Nth Occurrence DAX Formula

David Hager is At It Again A short two weeks after his truly creative Measure Catalog Macro post, David Hager is back with a heavyweight DAX post. This time he is exploring an area of the product that I have very little experience with, namely the EARLIER() function.  On the DAX spicy scale, EARLIER() is a 5 in my opinion, but the other reason I haven’t done much with it is because I’m pretty sure it’s only useful in calc…

Read the Rest

Campaign Analysis: Seasonally-Adjusted Measures

    “We sure sold a lot of toilet paper around Halloween this year.  That promotion we were running must’ve been REALLY effective!” -Retail Manager Extraordinaire            Halloween Mischief Has Nothing to Do With It! A Common Question:  What Caused the Change? Thought I’d take a break from the “Refresh on SharePoint” series and talk about an age-old problem…  and how easy it is to address with PowerPivot.  There isn’t much complexity behind it, and yet…

Read the Rest

Santa’s Elven Productivity Simulator Leaked Online!

  Now With Ornaments! :) Get Your Password Now! Folks, Wikileaks is at it again.  This time, they’ve come into possession of one of Santa’s most closely-guarded management tools:  his Elven Workshop Productivity Simulator. And naturally, Wikileaks has asked for my assistance in getting this out to the public. So I did what every responsible person would do.  I decided to host it. To log in, go to https://clients.pivotstream.com/sites/santa/pages/simulator.aspx Username:  santa@pivotstream.com P-word:  S@ntaModel1 How it was done I won’t go…

Read the Rest

PowerPivot time intelligent functions: why use ALL() and how to work around it

Posted by: Kasper de Jonge Last week I got a most excellent question from Sasha at my question page. Using my timeintelligent function screencast Sasha created a workbook using  YTD  where he used one table with facts and dates in it. The problem he had was when created his time intelligent function he wasn't able to use data from other columns than the date columns. In this blog post i´ll try to describe how the time intelligent functions work, what pitfalls are…

Read the Rest