Dataset: Coffee Chain Sales Analysis

About this Dataset

Coffee Chain Sales Analysis

The Coffee Sales Data dataset provides valuable insights into the performance of a coffee chain across various locations.

*Key Attributes: *

1.Area Code: A unique identifier for different geographical areas or regions where the coffee chain operates.

2.COGS (Cost of Goods Sold): The total cost incurred by the coffee chain in producing or purchasing the products it sells.

3.Difference between Actual and Target Profit: This attribute indicates how well the company performed in terms of profit compared to its target. It reflects the financial performance against predefined goals.

4.Date: The date of sales transactions, which allows for time-based analysis of sales trends and patterns.

5.Inventory Margin: The difference between the cost of maintaining inventory and the revenue generated from selling those inventory items.

6.Margin: The profit margin, which is the percentage of profit earned from sales. It's a critical financial metric.

7.Market Size: Information about the size of the market in each area, helping to understand the potential customer base and market dynamics.

8.Profit: financial gain achieved by the company after deducting the cost of goods sold (COGS) and other expenses from the revenue generated through sales.

9.Sales: represent the revenue generated from the coffee chain's products, reflecting its financial performance and customer demand.

Tables

Coffee Chain Sales

@kaggle.amruthayenikonda_coffee_chain_sales_dataset.coffee_chain_sales

43.02 KB
1062 rows
21 columns


CREATE TABLE coffee_chain_sales (
  "area_code" BIGINT,
  "cogs" BIGINT,
  "differencebetweenactualandtargetprofit" BIGINT,
  "date" TIMESTAMP,
  "inventory_margin" BIGINT,
  "margin" BIGINT,
  "market_size" VARCHAR,
  "market" VARCHAR,
  "marketing" BIGINT,
  "product_line" VARCHAR,
  "product_type" VARCHAR,
  "product" VARCHAR,
  "profit" BIGINT,
  "sales" BIGINT,
  "state" VARCHAR,
  "target_cogs" BIGINT,
  "target_margin" BIGINT,
  "target_profit" BIGINT,
  "target_sales" BIGINT,
  "total_expenses" BIGINT,
  "type" VARCHAR
);