Dynamic Dashboard Development for Data Integration

Details of the job are:
Background:
1. There are 2 spreadsheets showing trouble tickets, restoration time, etc. The first spreadsheet has data retrieved from a decomissioned tool. This tool provide a name for each field/column that is related to the trouble tickets. The second spreadsheet shows data extracted using a new tool and the fields/columns have different named but still is the same type of data.
2. It is required to build a dashboard for the data that was collected from the decomissioned tool.
3. Using the same dashboard structure, use the data from the new tool with the new names of field/columns.
4. Using the same style of dashboard, it is required to build a new dashboard that integrates the old tool's data with the new one tool's data. It will be one single dashboard showing all the information.
5. The dashboard has to include graphs about the Amount of cases, Number (cases) == stats of Cases opened; time lasted to fix; incident related;
Product type ,
Category and subcategory,
case type,
Resolution Code,
Actioned By,
Resolved and Closed.
6. The dashboard has to be dynamic with filters and pop-down option to filter the data.