im tracking attendance of courses. There is a user dimension, course dimension and a fact table.
I need to track if a user attended a course and if they did not attend a course.
I was thinking of storing a record for each user and course in the fact table, one if they attended and one if they did not.
Should i store non attendance records or should absence of a record indicate non attendance?
Note: source data is limited so i dont have the date of course completion.
I am building this in ssas tabular.