search

analyst-collective / analytics

Open source data models and analysis.
Apache License 2.0
46 stars 11 forks source link

Zuora model updates #34

Open dwallacerjm opened 8 years ago

dwallacerjm commented 8 years ago

Updates to make the zuora_subscription model more robust. Put in a lot of aggregation functionality for things like a subscription's total MRR, TCV, list of distinct products, list of distinct billing frequencies, etc.

Also added an analysis file new_business_metrics.sql that calculates various new business metrics.

jthandy commented 8 years ago

@dwallacerjm should get to this on friday.

jthandy commented 8 years ago

@dwallacerjm FYI spoke to @3mei about this and agreed that since he did the initial version he's in a better position to review. I believe the goal is to look at it tomorrow.

jthandy commented 8 years ago

And this is code review. Love that we're doing this. Thanks to both of you for working through this.

@dwallacerjm model and analysis design--specifically, designing for modularity and usability--is something that we've thought a ton about. Would absolutely love to get your head on that problem too, but those design priorities are baked into the AC viewpoint. @3mei 's comments here are spot on in terms of pushing this PR towards conforming with that viewpoint.