-1

I was learning online how what is fact table and dimension table , so it advised to practiced with real data set. as a sample I downloaded this excel file. enter image description here

I want to try star schema, As far as I under stood it can be divided into multiple fact tables , but all tables are different , does it mean it's already a fact table and cannot be divided into dimensions ? for credits I got dataset from here https://www.kaggle.com/zynicide/wine-reviews

Escaper
  • 69
  • 1
  • 9

1 Answers1

0

A typical machine learning data consist of measurements or events, which can be interpreted as a single fact table.

The numerical attributes (such as priceor points) are the measurment attributes of the fact table.

The factor (or time) attributes (such as country, province or tester_name) are foreign keys to the dimension tables.

The dimensions are not contained in your data but they can be implicitely reconstructed using distinct keys.

Marmite Bomber
  • 19,886
  • 4
  • 26
  • 53
  • Hi , thank you for your answer, Could you please tell me a little bit more information about reconstructed dimensions using distinct keys , at least one sample, or a link where I can find good explained information about it – Escaper Nov 04 '18 at 20:08