|Modeling Viral and Marketing Growth, Part 3 of 3|
|Written by Rob Collie|
|Friday, 25 January 2013 17:28|
This is a question I should have answered before I even started down this road.
To be honest, I did it primarily as a challenge - to stretch my brain a little bit. If I were faced with this exact same task in my daily work, undoubtedly I would just use normal Excel formulas. In some ways, this modeling exercise has been a deliberate misuse of PowerPivot. A handful of parameters with no source data whatsoever - this is NOT what the PowerPivot engine was built for, which explains why the PowerPivot solution is actually significantly more difficult than the Excel solution.Read more...
Latest Author Articles
- Speed: Another Reason to "Trim" Calendar Tables
- "CONTAINSX" Revisited: What WAS the Match?
- "CONTAINSX" - Finding if a value in table 1 has a matching value in table 2
- A Simple Trick for Combating "Stale" Slicers
- Bubbling Up Exceptions with "Sara Problem?"