Campaign Analysis: Seasonally-Adjusted Measures
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 it’s still much more useful and re-useable than anything you can do with Excel alone.
Let’s say you work for the fictional AdventureWorks bicycle company. And for the past few weeks, you’ve been running a special promotion: “Buy a Bike, Get a Free Water Bottle.” And so far, it’s looking pretty good, as evidenced by the highlighted region on this chart: