Baselight
Sign In
kaggle

Sales Analyzing Historical

@kaggle.willianoliveiragibin_sales_analyzing_historical

Loading...
Loading...

Sales Dataset: Analyzing Historical Trends and Performance Records

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.


Related Datasets

Share link

Anyone who has the link will be able to view this.