this graph was created in google sheets:
Row ID: A unique identifier for each row in the table, ensuring that every entry is distinct.
Order ID: The identifier for each sales order, used to track individual transactions.
Order Date: The date on which the order was placed, providing a timeline for sales activities.
Ship Date: The date on which the order was shipped to the customer, crucial for calculating delivery times.
Delivery Duration: The amount of time it took to deliver the order, measured from the order date to the ship date.
Ship Mode: The shipping method used for the order, such as standard, express, or overnight shipping.
Customer ID: The identifier for the customer who placed the order, useful for tracking customer purchasing behavior.
Customer Name: The name of the customer who placed the order, aiding in personalized customer service.
Country: The customer's country, providing geographical insights into sales distribution.
City: The customer's city, helping to pinpoint regional sales trends.
State: The customer's state, further refining geographical sales analysis.
Postal Code: The customer's postal code, offering a detailed location for demographic studies.
Region: The customer's region, summarizing broader geographical areas for sales reporting.
Product ID: The identifier for the product that was ordered, essential for inventory management and sales tracking.
Category: The category of the product that was ordered, such as furniture, office supplies, or technology, useful for understanding sales by product type.
Sub-Category: This attribute likely refers to a subcategory within a larger product category, such as Tables within Furniture. Examples include:
Bookcases
Chairs
Labels
Tables
Storage
Furnishings
Art
Phones
Binders
Appliances
Paper
Others
Product Name: This attribute specifies the name of the product sold, such as:
Bush Somerset Collection Bookcase
Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
Self-Adhesive Address Labels for Typewriters by Universal
Bretford CP4500 Series Slim Rectangular Table
Others
Sales: This attribute shows the total sales amount for each product, with values listed in currency format.
Quantity: This attribute specifies the number of units sold for each product, represented by integer values.
Discount: This attribute indicates the discount percentage offered on the product.
Discount Value: This attribute shows the total discount amount applied to the product, expressed in currency format.
Profit: This attribute shows the profit earned on the sale of each product, highlighting the financial performance.
COGS (Cost of Goods Sold): This attribute likely refers to each product's cost of goods sold, calculated as Sales minus Profit, providing insight into the direct costs associated with the products sold.