Building a Supply Chain Dashboard

Job ID: 33905046

Budget: ₹1,500 – ₹12,500 INR

This Project is basically building a dashboard using the data we have from our Google Sheets.
The Dashboard building should be based on minimal logic and a great creativity showcase.
The Dashboard must be pulling the data (10 Columns max..) from 3 Google Sheets and should give us a consolidated report (Dashboard) on a separate file.
The Dashboard must be pulling the data automatically from the G-Sheet not be like downloading a template and copy the data we already have and then the Dashboard gives me the consolidated report.
The Dashboard is basically to see,
1. Shipments are been customs cleared on Time
2. Milestone to achieve the Customs Clearance of Shipment are been rightly met or was there any deviation, What caused the deviation.

I'm attaching a example offile file from the G-Sheet and with its logic