What is Canvas Data?
Canvas Data is a service from Canvas that provides admins with optimized access to their data for reporting and queries. Customers can combine their Canvas Data with data from other trusted institutions, as well as other key systems across campus such as a student information system (SIS).
The Canvas Data Administrator for an institution must be a Canvas admin. The Canvas Data Administrator must understand data governance procedures and policies for the institution and also have enough technical proficiency to understand IP address ranges and database connection strings.
Canvas Data Administrators can download flat files or view files hosted in an Amazon Redshift data warehouse. The data will be an extracted and transformed version of a school's Canvas activity and can be accessed using any open database connectivity (ODBC) analytics tool to generate custom data visualization and reports.
To enable Canvas Data, please contact your Customer Success Manager.
Canvas Data Exports
Canvas Data parses and agregates the over 280 million rows of Canvas usage data generated daily and exports them as tab delimited (.txt) flat files. Files are also uploaded into Amazon Redshift for customers who want access to their own Redshift data warehouse.
Canvas Data flat files are available to all Canvas customers at no cost. Additionally, Canvas Data has a pilot program underway with customers using the hosted option for Canvas Data. Contact your Customer Success Manager for details.
Canvas Data Access
For institutions with hosted account, admins can also manage access to Redshift and the IP Address Whitelist. Files are also available in the institution's Redshift database.
Canvas Data Files
Admins can use Canvas Data schemas and APIs to get insight on topics such as accreditation, improving course design, assessing student engagements and, enabling student intervention.
As part of the Canvas Data Portal, the Canvas Data schema includes documentation that explains all the table data that is exported from Canvas. Relevant files can be compared and used to answer questions such as:
- Which departments/courses/teachers are fully adopting the LMS tool?
- What makes a successful department/course/instructor?
- Which courses are being retaken?
- How can our institution improve student retention?
- Which learning objects are actually used by students?
- How much time do successful students spend on the course?
- When should an instructor intervene with a student?
- What courses fit a student’s learning style?
- How are students doing in the course (current and historical)?
- How can students plan to be more effective?
ODBC Analytics Tools
Canvas Data files can be used to create visual analysis using queries and reports in ODBC analytics tools. Common tools include Excel (using Amazon Redshift), Tableau, R, and SQL Workbench/J. Most other ODBC and Java database connectivity (JDBC) PostgresSQL clients should support the data, but pgAdmin is not supported.