Baselight

Craft Beer Bar Sales

Nelson Sauvin Bar sales history

@kaggle.podsyp_sales_in_craft_beer_bar

Loading...
Loading...

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
Loading...

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
Loading...

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
);

Share link

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