Client business required enrolling a 45-million patient population in a medication consolidation program. Metrics on enrollment activity were a key performance indicator.  Summaries had to be calculated incrementally, each day, based on the previous day’s data. These summaries suffered from frequent gaps that required time-consuming research and correction, often delaying the delivery of critical customer analytics.