Data processing

We need to have a good dashboard where all parameters can be reviewed against the following:
a. Set targets - we need to give columns to set up target field entry
b. Filter by Trainer, Course, Classroom, Online, Offline
c. Data should be summarized on Weekly basis - that means the summary data of previous weeks for components should be sitting in a separate sheet to create another dashboard for trends over a period of time