I have a project i am working on and don´t have the right idea how to predict a "delivery Time" of a supplier. i have the following Dataset:
Explanation of the columns:
vendorNo = the Number of the supplier
Location = the warehouse
gate = the gate that has been blocked (manually assigned by staff) for the delivery
vendorName = Name of the supplier
dlockedDuration = time duration that has been blocked by the supplier
requiredDuration = real used time duration
TruckType = The type of the tuck
cargo = string of the Cargo that has been deliverd
fromDateTime = Start Point of delivery
toDateTime = Endpoint of delivery
I have the idea of using the following colums to predict a "delivery Time" for a Weekday and a Vendor: VendorNo, FromDateTime, blockedDuration, RequiredDuration, TruckType(Maybe)
I know some basic of Time Series Analysis and Machine learning and thought that i can transform my data to a multivariat regression problem or a time series analysis problem. I would like to use a Neural network for this.
But i have no clue how to transform my data and how to predict the "delivery Time".
Can someone recommend me a way?