Step Dimensions

Sequential processes, such as web page events, normally have a separate row in a transaction fact table for each step in a process.

To tell where the individual step fits into the overall session, a step dimension is used that shows what step number is represented by the current step and how many more steps were required to complete the session.

event_id	session_id	step_key	page_name	duration_seconds
E-01	S-100	ST-1	Home	10
E-02	S-100	ST-2	Pricing	45

Step Dimension

step_key	step_number	total_steps_in_session	is_final_step
ST-1	1	3	False
ST-2	2	3	False