Practices

Adidas Sales

In this assignment, your task is to create insightful visualizations using the provided Adidas Sales Dataset. Your goal is to uncover trends, patterns, and insights related to Adidas sales across different regions.

Dataset: You have been provided with the "Adidas Sales Dataset" containing information about sales data for Adidas products across various regions. The dataset includes the following columns:

  • Retailer: The name of the retailer.
  • Retailer ID: The unique ID assigned to each retailer.
  • Invoice Date: The date of the sales invoice.
  • Region: The region where the sale took place.
  • State: The state within the region.
  • City: The city where the sale occurred.
  • Product: The name of the Adidas product sold.
  • Price per Unit: The price per unit of the product.
  • Units Sold: The quantity of units sold.
  • Total Sales: The total sales amount for the transaction.
  • Operating Profit: The profit generated from the sale.
  • Operating Margin: The profit margin for the transaction.
  • Sales Method: The method used for the sales transaction.

Adidas sales dataset

Instructions:

  1. Load the "Adidas Sales Dataset" into a suitable data structure (e.g., DataFrame).
  2. Explore the dataset to understand its structure, summary statistics, and any missing values.
  3. Create a variety of visualizations to answer the following questions:
    • Create a bar chart or a line chart to showcase the regional distribution of total sales.
    • What are the top-selling products? Create a bar chart to visualize the quantity of each product sold.
    • Is there a relationship between the price per unit and the operating profit? Use a scatter plot to explore this relationship.
    • How does the sales method impact the operating margin? Create a box plot to compare the distribution of operating margins for different sales methods.
  4. Put all your visuals in a word document.
  5. Write a brief summary of your findings and insights from the visualizations.

Submission

You are required to submit documentation for practice exercises over the course of the term. Each one will count for 1/10 of your practice grade, or 2% of your overall grade.

  • Practice exercises will be graded for completion not perfect correctness.
  • You have to document that you did the work, but we won't be checking if you got it right.
  • You MUST upload your visuals as a single file to Practices - Visualization on Gradescope after the exercise to get the grade for this exercise.

Your log will count for credit as long as:

  • It is accessible to your instructor, and
  • It shows your own work.