student_raw -> student_snapshot -> historical student analysis