Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mjamesking
Creator
Creator

Data Model Question - Fat or Thin Fact table?

Hello,

Am designing a data model and am torn between two approaches for the fact table. Am wondering if anyone has any advice or preferences (or even an alternate suggestion).

Essentially I want to measure the balance of a client account on a daily basis, and also look at the number and value of orders by type (deposits, withdrawls) made each day.

Is my best approach to have:

1. a single row per account per day in the fact table, with a number of different measures on each row

e.g.

DateAccountBalanceDeposit #Deposit ValueWithdrawal #Withdrawal Value
03/07/20161$1002$51$10
03/07/20162$3003$232$5

or

2. Multiple fact rows per account each day, containing the result for each particular measure

e.g.

DateAccountFact TypeFact Value
03/07/20161Balance100
03/07/20161Deposit #2
03/07/20161Deposit Value5
03/07/20161Withdrawal #1
03/07/20161Withdrawal Value10

Bearing in mind the number of facts per account per day could grow and grow?

Any thoughts?

10 Replies
mjamesking
Creator
Creator
Author

OK - here goes

Thanks again