The data and records per month had to be maintained on a daily/weekly basis in separate excel/CSV files. Processing the information from these excels, required us to ensure data accuracy, data integrity, and denormalization of data for optimal query performance. The challenge was also to minimize the needs for manual efforts in preparation of these reports from various data sources.