Queries per user group per timeframe is the most effective usage metric for capacity planning of a
data warehouse. This metric provides detailed insights into the workload generated by different user
groups over specific periods, allowing for accurate forecasting of resource needs and planning for
future capacity. It helps in identifying patterns and peak usage times, which are crucial for efficient
capacity management.
Reference:
"Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems" by
Sam Anahory and Dennis Murray
"The Data Warehouse Lifecycle Toolkit" by Ralph Kimball et al.
