You should retain all underlying raw data even after creating summary tables. It’s essential for root cause analysis, fraud detection, and granular investigations. While aggregate tables provide efficient high-level metrics, they lack the specific details required to pinpoint the exact source of an anomaly or performance issue. Keeping the raw data ensures you can generate new, accurate aggregations in the future if your business requirements or dashboard strategies change.