API Creation for Business Analytics Machine Learning

Job ID: 39245426

Budget: ₹37,500 – ₹75,000 INR

Analytical API requirement’s,:
Truck Maintenance Trend
Sales Trend
- Peak Season & Low Season prediction
-Compare YoY or QoQ or MoM comparison
-Own truck sales vs Vendor Truck sales comparison
-Highlight if own truck trips were lesser than usual and vendor trucks were used more
Customer wise sales trend
-Compare YoY or QoQ or MoM comparison
-Highlight if any customer sales was good previously and now got down
-Highlight if any customer not giving orders
-Compare YoY or QoQ or MoM comparison
Show most active employees online
-show creates more orders online and vice versa
-show who uploads most POD’s and vice versa
-show which driver is using mobile app POD-uploads and updates swipe-in out time and vice versa
-show best performing drivers in KPI and their consistency and vice versa (Role – Driver)
-show if there are any drivers performing good before and now performance is low and vice versa (Role – Driver)
-show if any employee working online actively and now got low and vice versa (Role – Driver)
-show who generates most number of invoices and now got low and vice versa
-show which timeline most number of invoices are generated
Expenses Trend
Show which expenses eat up regularly. Allow user to add exceptions, by default create exceptions for known regular bills like rental. Example: EB & Phone bills must show if they are eating up more than regular bills, if office expenses got more,etc
Payment received trend
-show which customers are paying on-time ( meaning on due date including credit terms )
-show which customers are consistently paying late

Tech stack used in current project:
MySQL, Java, Hibernate, REST API
Anyone with experience in creating analytical data from data required for creating these API’s