Customer development

Why does it make sense to make some analysis in a data model?

Consider the example of the customer churn analysis for a SaaS business that has around 3k customers and includes additional columns that further describe contracts and customers.

• You can slice and dice the data to see if some contract types or customers perform differently
• Visuals give you instant feedback, while excel would be very slow (the data set has 2m rows)
• You can link the data model to excel and reuse the (fast) calculations for further purposes, e.g. planning based on historical trends