Recognizing when a stated analytical requirement actually implies a need for a calculated KPI or target rather than a simple aggregation, and how that should shape the data source design.