An exploratory and in-depth study of the e-commerce market in Brazil.
Target is a globally renowned brand and a prominent retailer in the United States. Target makes itself a preferred shopping destination by offering outstanding value, inspiration, innovation and an exceptional guest experience that no other retailer can deliver. This particular business case focuses on the operations of Target in Brazil and provides insightful information about 100,000 orders placed between 2016 and 2018. The dataset offers a comprehensive view of various dimensions including the order status, price, payment and freight performance, customer location, product attributes, and customer reviews. By analyzing this extensive dataset, it becomes possible to gain valuable insights into Target's operations in Brazil. The information can shed light on various aspects of the business, such as order processing, pricing strategies, payment and shipping efficiency, customer demographics, product characteristics, and customer satisfaction levels.
You can access the complete project report here - Target
The dataset offers a comprehensive view of various dimensions including the order status, price, payment and freight performance, customer location, product attributes, and customer reviews. The dataset contains 8 tables as mentioned below -
- customers
- sellers
- order_items
- geolocation
- payments
- reviews
- orders
- products
- Executed data analysis on customer segmentation, sales, campaigns, and inventory, deriving actionable insights and recommendations.
- Analyzed TARGET customer data with BigQuery and Data Visualization, suggesting enhancements for regional performance; achieveda 15% increase in conversion rates.
- Identified a 705.13% increase in the cost of orders in January 2018 and a 51.61% growth in August 2018; optimized cost-saving strategies.