Data Analytics Challenge
In the Fall of 2017, I participate in Temple’s data analytics challenge. There were three different questions we could choose to analyze. My classmate and I chose the questions “Does speed matter in E-Commerce?”. We used excel pivot tables and other tools to analyze the data. In analyzing QVC’s E-Commerce dataset, we tried to focus my efforts around the pertinent questions. We wanted to figure out whether the speed of delivery mattered in E-Commerce. We also evaluated where the most popular products were purchased the most. We first analyzed when the products were delivered 7 days or less, will the customer order again. We used the ship date and delivery date to figure out how long these products took to get to their destination. We found that customers were more likely to order again if the order was delivered in less than 7 days by 63.33% and they would order more than twice 46.55% of the time. If the order took more than 7 days we found out that customers were much less likely to order again at 31.87% and only 15.82% of customers would order again more than twice. We also found the top-selling products and their most popular geographical markets. We can use this data to make sure that we get more customer retention. If the distribution centers are prepared to deliver the specific products, they will be able to ship and deliver the products under 7 days and keep customers happy. This challenge taught me how to use big data and break it down into meaningful information anyone can understand. I’m looking forward to participating in this year’s challenge as well!