LOOKING FOR DATA ANALYTICS EXPERT WITH EXPERTISE IN POWER BI AND POWER QUERY, EXCEL (PLEASE APPLY ONLY IF YOU ARE TRAINED EXPERT IN POWER QUERY, POWER PIVOT AND POWER BI, KNOW POWER AUTOMATION)
BUILD MULTIPLE LOGISTICS RELATED POWER BI DASHBOARDS
To ascertain cost/weight/movement/kits across lanes/temp/location.
a. We need full insights on Sales data, IOT
b. Cost Visibility
a. Cost per CC Kg (across lanes/origin/destination/temperature)
b. Cost per Kit and Cost per Bulk
c. Cost per customer / Customer category/City
d. Ability to project cost for future
c. Lead time – Order to invoice, Invoice to dispatch, Dispatch to deliver – per Customer category/City/CFA/RDC/Service provider
a. Provider and city performance assessment
b. Order entry performance assessment
c. CFA dispatch performance assessment
d. Inventory Review – by SKU, by location, by expiry, by coverage
a. Projected expiry basis avg. sales run rate
b. SKU constraint dashboard
e. Open PO Review against Forecast for Traded Items (discuss with Sudhakar)
f. Build robust error handling in the dashboard itself.
a. CFA – POD missing/delivery date missing
