Dataset: Country Delight Dairy Sales & Inventory Dataset

About this Dataset

Country Delight Dairy Sales & Inventory Dataset

Dataset Overview:
The Country Delight Dairy Sales & Inventory Dataset provides a detailed collection of data related to dairy farms, products, sales, and inventory tracking. It includes information on farm locations, land size, livestock count, product details, sales records, customer distribution, stock levels, and pricing. This dataset is valuable for researchers, analysts, and businesses in the dairy sector.

Dataset Features:

Location: The geographical region of the dairy farm.
Total Land Area (acres): The size of the dairy farm.
Number of Cows: Total number of cows at the farm.
Farm Size: Categorization of farms as Small, Medium, or Large.
Date: Date of data collection.
Product Name: Type of dairy product.
Brand: The brand associated with the dairy product.
Quantity (liters/kg): The total quantity available.
Price per Unit: The unit price of the product.
Total Value: The total value based on available quantity.
Shelf Life (days): The product's expiration period.
Storage Condition: Storage requirements.
Production Date: Manufacturing date of the product.
Expiration Date: Date when the product expires.
Quantity Sold (liters/kg): The amount of product sold.
Price per Unit (sold): The selling price per unit.
Approx. Total Revenue (INR): Estimated revenue from sales.
Customer Location: The buyer's location.
Sales Channel: Mode of sale (Retail, Wholesale, or Online).
Quantity in Stock (liters/kg): Remaining stock levels.
Minimum Stock Threshold (liters/kg): The minimum required stock before restocking.
Reorder Quantity (liters/kg): Suggested reorder amount to maintain inventory.

Data Size & Format:
Rows: 122,983
Columns: 23
Format: CSV (Comma-Separated Values)
Time Range: 2019-2022
Geographic Coverage: India (multiple states and union territories)

Licensing & Attribution:
This dataset is open-source under a Creative Commons license. Users are encouraged to cite the dataset when utilizing it for research, analysis, or publication.

Acknowledgments:
The dataset incorporates publicly available information, dairy industry reports for analytical purposes.

Tables

Country Delight Diary Sales And Inventory Dataset

@kaggle.shrutithakur13_dairy_sales_and_inventory_data.country_delight_diary_sales_and_inventory_dataset

15.62 MB
122983 rows
23 columns


CREATE TABLE country_delight_diary_sales_and_inventory_dataset (
  "location" VARCHAR,
  "total_land_area_acres" DOUBLE,
  "number_of_cows" DOUBLE,
  "farm_size" VARCHAR,
  "date" VARCHAR,
  "product_id" DOUBLE,
  "product_name" VARCHAR,
  "brand" VARCHAR,
  "quantity_liters_kg" DOUBLE,
  "price_per_unit" DOUBLE,
  "total_value" DOUBLE,
  "shelf_life_days" DOUBLE,
  "storage_condition" VARCHAR,
  "production_date" VARCHAR,
  "expiration_date" VARCHAR,
  "quantity_sold_liters_kg" DOUBLE,
  "price_per_unit_sold" DOUBLE,
  "approx_total_revenue_inr" DOUBLE,
  "customer_location" VARCHAR,
  "sales_channel" VARCHAR,
  "quantity_in_stock_liters_kg" DOUBLE,
  "minimum_stock_threshold_liters_kg" DOUBLE,
  "reorder_quantity_liters_kg" DOUBLE
);