Pivots were definitely made for non-technical people so that admins can create datasets and pivots for those non-technical users to build their own reports and dashboards with reasonable ease and confidence of accuracy. The need for schema and a normalized naming convention was the reason for datamodels. When datamodels are accelerated they can summarize and report over huge volumes of data very quickly. The stats command, in some form or another (e.g. timechart, chart, tstats, etc.) is a key component of all of these when it comes to building and leveraging them. If you need your summaries to outlive your raw data, then you cannot use datamodels, you need to use a summary index.