Dairy Goods Sales Dataset

The Dairy Goods Sales Dataset provides a detailed and comprehensive collection of data related to dairy farms, dairy products, sales, and inventory management. This dataset encompasses a wide range of information, including farm location, land area, cow population, farm size, production dates, product details, brand information, quantities, pricing, shelf life, storage conditions, expiration dates, sales information, customer locations, sales channels, stock quantities, stock thresholds, and reorder quantities.

Features:

1. Location: The geographical location of the dairy farm.
2. Total Land Area (acres): The total land area occupied by the dairy farm.
3. Number of Cows: The number of cows present in the dairy farm.
4. Farm Size: The size of the dairy farm(in sq.km).
5. Date: The date of data recording.
6. Product ID: The unique identifier for each dairy product.
7. Product Name: The name of the dairy product.
8. Brand: The brand associated with the dairy product.
9. Quantity (liters/kg): The quantity of the dairy product available.
10. Price per Unit: The price per unit of the dairy product.
11. Total Value: The total value of the available quantity of the dairy product.
12. Shelf Life (days): The shelf life of the dairy product in days.
13. Storage Condition: The recommended storage condition for the dairy product.
14. Production Date: The date of production for the dairy product.
15. Expiration Date: The date of expiration for the dairy product.
16. Quantity Sold (liters/kg): The quantity of the dairy product sold.
17. Price per Unit (sold): The price per unit at which the dairy product was sold.
18. Approx. Total Revenue (INR): The approximate total revenue generated from the sale of the dairy product.
19. Customer Location: The location of the customer who purchased the dairy product.
20. Sales Channel: The channel through which the dairy product was sold (Retail, Wholesale, Online).
21. Quantity in Stock (liters/kg): The quantity of the dairy product remaining in stock.
22. Minimum Stock Threshold (liters/kg): The minimum stock threshold for the dairy product.
23. Reorder Quantity (liters/kg): The recommended quantity to reorder for the dairy product.

Potential Use-Case:

This dataset can be used by researchers, analysts, and businesses in the dairy industry for various purposes, such as:

1. Analyzing the performance of dairy farms based on location, land area, and cow population.
2. Understanding the sales and distribution patterns of different dairy products across various brands and regions.
3. Studying the impact of storage conditions and shelf life on the quality and availability of dairy products.
4. Analyzing customer preferences and buying behavior based on location and sales channels.
5. Optimizing inventory management by tracking stock quantities, minimum thresholds, and reorder quantities.
6. Conducting market research and trend analysis in the dairy industry.
7. Developing predictive models for demand forecasting and pricing strategies.

Note: This dataset includes data from the period between 2019 and 2022, and it specifically focuses on selected dairy brands operating in specific states and union territories of India. There is an intentional drift highlighted in the dataset's figures due to its opensource and creative license, currently !