2019 – Integrating Canvas into Your Data Warehouse, Part 2

Presentation Summary

Canvas data offers a rich and fine-grained view of student engagement and performance, but it’s most useful when integrated with SIS data. We will discuss how to relate Canvas data to your SIS and wrangle it into a useful star schema. Attendance at part 1 is helpful but not required; sample files with dummy data will be provided for participants without access to their own data. Come prepared to upload data files into your own database or sandbox; SQL that illustrates some of the basic necessary ETL will be provided.