Does Speed Matter in E-Commerce? QVC Temple

stefany-barnette

Published 2025-05-16 · 19 slides · 0 views

↓ Download

Does Speed Matter in E-Commerce? QVC Temple

Does Speed Matter in E-Commerce? QVC Temple - slide 1 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 2 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 3 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 4 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 5 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 6 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 7 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 8 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 9 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 10 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 11 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 12 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 13 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 14 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 15 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 16 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 17 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 18 of 19

Does Speed Matter in E-Commerce? QVC Temple - slide 19 of 19

Description

Does Speed Matter in E-Commerce? QVC Temple Analytics Challenge Ismail Hawk-Bey, Ryan Lattieri, John Do, Nsimba Zebedi Do Customers that receive their product sooner purchase more than customers with longer delivery times? YES Working with

Download this presentation From Below

"Does Speed Matter in E-Commerce? QVC Temple" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.

Presentation Transcript

Does Speed Matter in E-Commerce?
QVC Temple Analytics Challenge Ismail Hawk-Bey, Ryan Lattieri, John Do, Nsimba Zebedi

Do Customers that receive their product sooner purchase more than customers with longer delivery times?

YES

Working with Smaller Data Working with the provided smaller data set allowed us to test our solutions faster.
Larger data sets were massive

Filtering through data Spreadsheets given had many details irrelevant to analysis.
Filtering allows for quicker run time
Easier to read and recognize important factors

Determining What’s Necessary By keeping track of the party ID, we can keep track of how many orders this party placed
Having the order date and delivery confirmation date is an obvious factor between their total orders

METHOD 1

Person Class and opening the workbook Person class contains data for number of orders, order dates, delivery dates, and time between each order and delivery.
Openpyxl was used to work with the excel files.

Iterating through workbook and saving data Algorithm used to calculate time between orders and data for persons objects.

Order dates and time between each order Left hand column shows the dates that each order was placed.
The right hand column shows the time between each order.
A zero denotes that the package was ordered at the same time.

METHOD 2

Python Packages used Pandas

Seaborn

Organizing and Cleaning of Data Rows were removed that contained a blank cell for the column
Column Delivery Confirmation Date.

Organized the rows based on the Order Date column.

Organizing and Cleaning of Data

Finding the time of Delivery for each order

Finding the average delivery days for each Party ID

Analysis Pearson Correlation

Spearman Correlation

Pandas.DataFrame.corr method was used to calculate these correlation values

CONCLUSION

Results

Does Speed Matter in E-Commerce? QVC Temple

Related Topics

Share

Embed code

Download this presentation From Below

Presentation Transcript