Fact table and Dimension tables

Question

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.

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

Answer 1

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.