Category: Non-Football Examples

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

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 […]

Written by on January 16, 2011

Guest Post: Dany Hoter on Cube Formulas

“OK, I want the brooding frontman in the foreground, and the keyboard player and drum machine programmer in the back.” -Photographer for the EuroSynth band, MDX I’ve always loved this […]

Written by on March 1, 2010

Generating a Tag Cloud via PowerPivot

“Navajos say it is good plan to have two arrows for one bow” – Chief Thundercloud Thanks to Rob Collie for letting me do another guest post. There will be […]

Written by on February 21, 2010

Introducing PowerPivot DAX Measures

Up until this point, I’ve just used DAX (PowerPivot’s extension to the Excel formula language) to create calculated columns in the PowerPivot window. There’s a lot of utility in DAX […]

Written by on November 15, 2009

  • 1
  • 2