Forum Discussion
How to improve data-model from 1 large table to multiple smaller ones correctly
Hello, I made a table to demonstrate my problem, original_table: date client box_id product_id 16-11-2023 james fruit_box_01 orange 16-11-2023 james fruit_box_01 pineapple 16...
lbendlin
Super User
Super UserPlease read about Normalization. From your sample data you can create the following dimensions:
- Calendar
- Clients
- Products
- Boxes
What's missing is a fact column - do you only want to count the rows?