SELECT
  user_dim.name AS "Student Name",
  pseudonym_dim.sis_user_id AS "SIS/Student ID",
  course_dim.name AS Course,
  module_dim.name AS "Module Name",
  module_progression_dim.workflow_state AS "Module Status",
  module_progression_dim.collapsed AS "UI Collapsed",
  module_progression_dim.completed_at AS "Completed At",
  CONCAT('https://YOURSCHOOL.instructure.com/courses/', course_dim.canvas_id, '/grades/', user_dim.canvas_id) AS "Grades URL"
FROM module_progression_dim
  INNER JOIN user_dim
    ON module_progression_dim.user_id = user_dim.id
  INNER JOIN module_dim
    ON module_progression_dim.module_id = module_dim.id
  INNER JOIN module_fact
    ON module_fact.module_id = module_dim.id
  INNER JOIN course_dim
    ON module_fact.course_id = course_dim.id
  INNER JOIN pseudonym_dim
    ON pseudonym_dim.user_id = user_dim.id
WHERE pseudonym_dim.sis_user_id IS NOT NULL