Dataset: Craft Beer Bar Sales

About this Dataset

Craft Beer Bar Sales

Bar history:
In the spring of 2016, we decided to open a beer bar that would be fun to return to for many years. To do this, we have done a lot of work. There are 30 taps on the board on the board of interesting beer from European, American and Russian new wave breweries, shelves and refrigerators for three hundred bottles, as well as the best cheese from regional cheese makers. In December of the same year, Nelson Sauvin opened - a spacious and cozy two-story bar with large windows in the very center of Yekaterinburg. The bar is open not only for experimental and Untappd check-ins, but also for Friday hangouts, dates or meeting with grandma. 🎉🎉🎉 In addition, we are engaged in the import of beer, which, in our opinion, is not enough in Russia.

Some links:
https://www.instagram.com/nelsonsauvinbar/

Tables

Product Range

@kaggle.podsyp_sales_in_craft_beer_bar.product_range

164.2 KB
5314 rows
8 columns


CREATE TABLE product_range (
  "product_code" BIGINT,
  "vendor_code" VARCHAR,
  "name" VARCHAR,
  "retail_price" DOUBLE,
  "base_unit" VARCHAR,
  "country_of_origin" VARCHAR,
  "size" DOUBLE,
  "abv" DOUBLE
);

Transactions

@kaggle.podsyp_sales_in_craft_beer_bar.transactions

987.4 KB
50084 rows
8 columns


CREATE TABLE transactions (
  "date_and_time_of_unloading" TIMESTAMP,
  "product_code" BIGINT,
  "amount" DOUBLE,
  "sale_amount" DOUBLE,
  "discount_amount" DOUBLE,
  "profit" DOUBLE,
  "percentage_markup" DOUBLE,
  "discount_percentage" DOUBLE
);