Name: Amazon Business Research Analyst Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Amazon Business Research Analyst Dataset

Amazon.com strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience - Amazon.com continues to grow and evolve as a world-class e-commerce platform. Amazon's evolution from Web site to an e-commerce partner to a development platform is driven by the spirit of innovation that is part of the company's DNA. The world's brightest technology minds come to Amazon.com to research and develop technology that improves the lives of shoppers and sellers around the world.

The Business Research analyst (RA) will be responsible for continuous improvement projects across the RBS teams leading to each of its delivery levers. The long-term goal of the RA role is to eliminate Defects that impact selling partners or customer experience, and the secondary goal is to enhance GMS (General merchandise sales)/ FCF (Free cash flow). This will require collaboration with local and global teams, which have a process and technical expertise. RA is an Independent Contributor (IC) to perform a Big Data Analysis to identify defect patterns/process gaps for complex problems, create long-term solutions to eliminate defects/issuesAmazon.com strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience - Amazon.com continues to grow and evolve as a world-class e-commerce platform. Amazon's evolution from Web site to an e-commerce partner to a development platform is driven by the spirit of innovation that is part of the company's DNA. The world's brightest technology minds come to Amazon.com to research and develop technology that improves the lives of shoppers and sellers around the world.

The Business Research analyst (RA) will be responsible for continuous improvement projects across the RBS teams leading to each of its delivery levers. The long-term goal of the RA role is to eliminate Defects that impact selling partners or customer experience, and the secondary goal is to enhance GMS (General merchandise sales)/ FCF (Free cash flow). This will require collaboration with local and global teams, which have a process and technical expertise. RA is an Independent Contributor (IC) to perform a Big Data Analysis to identify defect patterns/process gaps for complex problems, create long-term solutions to eliminate defects/issues and report impact/results. RA should work across VP teams, and regional and/or cross-regional organizations to drive improvements. Leads projects and opportunities across the Operations (FCs, CS, Supply Chain, Transportation, Engineering) that are business critical, and maybe global in nature

Evaluation Metric
** 100*(metric.r2_score(y-pred, y))**

Tables

Cleaned Test

@kaggle.vikramxd_amazon_business_research_analyst_dataset.cleaned_test

309.43 KB
11399 rows
20 columns


CREATE TABLE cleaned_test (
  "id" VARCHAR,
  "delivery_person_id" VARCHAR,
  "delivery_person_age" DOUBLE,
  "delivery_person_ratings" DOUBLE,
  "restaurant_latitude" DOUBLE,
  "restaurant_longitude" DOUBLE,
  "delivery_location_latitude" DOUBLE,
  "delivery_location_longitude" DOUBLE,
  "order_date" VARCHAR,
  "time_orderd" VARCHAR,
  "time_order_picked" VARCHAR,
  "weather" VARCHAR,
  "road_traffic_density" VARCHAR,
  "vehicle_condition" BIGINT,
  "type_of_order" VARCHAR,
  "type_of_vehicle" VARCHAR,
  "multiple_deliveries" DOUBLE,
  "festival" VARCHAR,
  "city" VARCHAR,
  "name" VARCHAR
);

Encoded Cleaned Test

@kaggle.vikramxd_amazon_business_research_analyst_dataset.encoded_cleaned_test

309.8 KB
11399 rows
20 columns


CREATE TABLE encoded_cleaned_test (
  "id" VARCHAR,
  "delivery_person_id" VARCHAR,
  "delivery_person_age" DOUBLE,
  "delivery_person_ratings" DOUBLE,
  "restaurant_latitude" DOUBLE,
  "restaurant_longitude" DOUBLE,
  "delivery_location_latitude" DOUBLE,
  "delivery_location_longitude" DOUBLE,
  "order_date" VARCHAR,
  "time_orderd" VARCHAR,
  "time_order_picked" VARCHAR,
  "weather" BIGINT,
  "road_traffic_density" BIGINT,
  "vehicle_condition" BIGINT,
  "type_of_order" BIGINT,
  "type_of_vehicle" VARCHAR,
  "multiple_deliveries" DOUBLE,
  "festival" DOUBLE,
  "city" VARCHAR,
  "name" VARCHAR
);

Updated

@kaggle.vikramxd_amazon_business_research_analyst_dataset.updated

113.89 KB
2442 rows
20 columns


CREATE TABLE updated (
  "unnamed_0" BIGINT,
  "id" VARCHAR,
  "delivery_person_id" VARCHAR,
  "delivery_person_age" BIGINT,
  "delivery_person_ratings" DOUBLE,
  "restaurant_latitude" DOUBLE,
  "restaurant_longitude" DOUBLE,
  "delivery_location_latitude" DOUBLE,
  "delivery_location_longitude" DOUBLE,
  "time_orderd" VARCHAR,
  "time_order_picked" VARCHAR,
  "weatherconditions" BIGINT,
  "road_traffic_density" BIGINT,
  "vehicle_condition" BIGINT,
  "type_of_order" BIGINT,
  "type_of_vehicle" BIGINT,
  "multiple_deliveries" DOUBLE,
  "festival" BIGINT,
  "city" BIGINT,
  "time_taken_min" DOUBLE
);