A computer extracts traffic data from one or more traffic servers and stores the traffic data in a database. The computer also extracts and stores customer wait time, resource management, and point of sale (POS) data from one or more retail store servers in the database, and each of the retail store servers can correspond to a retail store. Extract and store subroutines may be executed in parallel using multithreading. Upon achieving synchronization of the parallel subroutines, the computer transforms the traffic, customer wait time, resource management, and POS data from the database by determining one or more metrics for each of the retail stores. Next, the computer loads the one or more determined metrics into the database. Finally, the computer aggregates the one or more determined metrics on at least one of a district level, region level, area level, and nation level to determine one or more aggregated metrics.