DATA ANALYSIS
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
MATLAB
Microsoft Excel
pandas
Tableau
Industries
Ad Server
Work with me