Excel Data Visualization Dashboard and Data Base Project - 15/11/2017 06:24 EST

What we want is to create is an excel template with three elements: 1. Dashboard - a searchable, visual and data table dashboard which can display the data and trends from 2017 for each client company showing the actual training completed and training still pending; 2. Calculation Engine – a series of calculations on the data to populate the dashboard; 3. A data base - which is populated with the 2017 data base for each client company or the summary data for all 17 client companies. In total there will be 18 templates with data – 17 will display data for an individual client company and 1 will display summary data for all 17 client companies. Please review the attached project file for more data. With their initial response freelancers are expected to provide: 1. Agreement with the completion date 2. Team size and availability 3. Examples of work already completed in this area Budget: This is a simple project and has a budget of $250. Three milestone payments will be made as follows: 1st Milestone on completion of agreed template design 2nd Milestone on Completion of the Template populated with current data for one client company 3rd Milestone of completion of all templates populated with all client data.