DATA ANALYSIS

Sangam Sumthankar

Starting at

600

About this service

Summary

We offer comprehensive data analysis services to verify the charges levied by delivery partners for ecommerce companies. Our unique approach involves merging internal order data with courier company invoices, calculating expected charges based on weight and distance, and identifying discrepancies to ensure accurate billing. Through meticulous data processing and analysis, we provide actionable insights to optimize shipping costs and improve transparency in the delivery process, ultimately helping our clients save resources and enhance customer satisfaction.

What's included

DATA ANALYSIS
This file will contain detailed information for each order, including Order ID, AWB Number, total weight as per X, weight slab as per X, total weight as per Courier Company, weight slab charged by Courier Company, Delivery Zone as per X, Delivery Zone charged by Courier Company, Expected Charge as per X, Charges Billed by Courier Company, and the Difference Between Expected Charges and Billed Charges. Summary Table Excel File: This file will provide a summarized overview of the analysis, including the count and total amount for orders that were correctly charged, overcharged, and undercharged.

Duration

8 weeks

Skills and tools

Data Modelling Analyst

Data Analyst

Product Data Analyst

Data Analysis