medium10 pts · first answer countsdata-modellingdimensional-modelling
Storing a conversion rate in a fact
A daily fact table stores conversion_rate per campaign. Analysts need the rate for a whole month across campaigns. What should the table store instead?
Discussion 0
Join free to post in the discussion.
Related questions
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer
- Why denormalise a reporting tableData Engineer