• Putting Data from the Requests Table into locally hosted databases

    Hi All   We are currently trying to process the data requests table (From Canvas Data) into a database that we can use and as you can imagine are having a fair amount of trouble with the sheer amount of dat...
    Luke Dellar
    last modified by Luke Dellar
  • What are people using to access the data from Canvas Data Portal?

    Hi all,   I have just gain access to the Canvas Data portal last week and have been exploring it. From what I can tell so far, it is a tab delimited file stored inside a gz file.    Excel can to a cer...
    Stefanie Sanders
    created by Stefanie Sanders
  • Tableau Workbook Examples

    One-Liner Examples of visualizations created with Tableau Desktop against Canvas Data data accessed from an Amazon Redshift data source.   One-Liner Overview Requirements for Use Examples Ov...
    John Sheringer
    last modified by John Sheringer
  • Canvas Data Page Views

    We're looking at some metrics of user activity, one of which is page views. The wiki_page_fact table has a measure called 'view_count'. I assume this is the number of times a page has been viewed but the numbers I'm p...
    Audra Agnelly
    last modified by Audra Agnelly
  • Tables to Recreate Catalog Analytics Dash?

    Hi - I'm just getting started trying to build out some dashboards with Canvas data for the first time. I've started digging into the schema documentation and I've got us set up with the Canvas Data CLI and am suc...
    Jamie Studwell
    last modified by Jamie Studwell
  • Canvas Data and Analytics

    Not sure if this is the correct place to post this information but I want to share a tool that the company we use for institutional analytics, HelioCampus, just released. It is free to use and allows institutions...
    Stefanie Sanders
    created by Stefanie Sanders
  • Canvas Data - Due dates are not showing

    Hi Canvas Team,   Using canvas CLI I'm getting data from canvas and created reports using PowerBI. Everything works fine but if assign any assignment to specific students that assignments are not showing due dat...
    Stefanie Sanders
    created by Stefanie Sanders
  • Deobfuscate user_dim.id?

    Canvas Data portal question: how do I link from somewhere (say Quiz_submission_fact.user_id) to a user? the "id" field in the user_dim table (downloaded) is described as "obfuscated" and does not match format of user_...
    Stefanie Sanders
    created by Stefanie Sanders
  • Canvas Data API Authentication

    Synopsis Calls to the Canvas Data API need to be authenticated. The Canvas Data API documentation provides example code that isn't explained very well. This post will explain what's going on so that people can prepare...
    James Jones
    last modified by James Jones
  • Is assignment data updated across the import tool or tracked when using external tools?

    Hi, there data geniuses,      We have two questions that you can hopefully assist our team with:   When using the course import tool, when assignments are imported into the new course shell, are t...
    Jayde Colquhoun
    last modified by Jayde Colquhoun
  • Cannot find learning_outcome_question_result_fact

    Does anyone know why the table learning_outcome_question_result_fact may be blank in the database? I can pull up the info from Settings/Reports/Outcome Results but my database seems to be missing the data fr...
    Stefanie Sanders
    created by Stefanie Sanders
  • Using Canvas Data CSVs to generate rudimentary stats?

    Hi all,   Due to the Covid-19 outbreak, our university is now fully online.  We have usage data from the Admin>Analytics section to get page views and participations, which gives some high level dat...
    Stefanie Sanders
    created by Stefanie Sanders
  • SQL query that shows all student page views in a sub-account

    I'm fairly new to Canvas Data and SQL. Our IT department recently created an SQL Server for Canvas Data and I'm now able to run queries.  I tried to create a query to display terms, the sub-account, course n...
    Glenn Saito
    last modified by Glenn Saito
  • Canvas Data Access Offering: Share Your Thoughts about Datasets

    Data is a powerful tool that has the potential to transform the way we offer education to students. Over the past five years, the Canvas data sharing product has been very important to our users and institutions. ...
    Samuel Timme
    created by Samuel Timme
  • Custom user fields in the Canvas API

    Institutions sometimes use the custom data fields available in the Canvas user API (Users - Canvas LMS REST API Documentation) to store additional information about users that could be displayed in a roster or used wh...
    cward@instructure.com
    last modified by cward@instructure.com
  • Is there an active Early Warning System project in the Canvas community written in Java?

    Is anyone aware of an Early Warning system for assessing student engagement in courses that is written in Java?  Preferably not a commercial product.  
    Gary Sharpe
    last modified by Gary Sharpe
  • How to store canvas data directly in sharepoint or azure database

    Hi Canvas Team,   I'm planning to do power bi reports using canvas data. Using Canvas Data CLI tool data is storing in local pc, is there any way to store data in SharePoint or azure database directly.   mo...
    Stefanie Sanders
    created by Stefanie Sanders
  • Canvas data dumps: full history or delta?

    Hi,   I'm using the canvas-data-sdk package to download Canvas data via its API in Python.  I've been using the following commands:   ``` canvas-data -c config.yml list-dumps # lists the daily dumps ...
    Stefanie Sanders
    created by Stefanie Sanders
  • Help with higher education measures

    First, I am going to admit that I am not fluent in using Canvas data or Power BI that we are trying to set up at our university. I have more experience with Excel, so if I use the wrong terminology, please forgive me ...
    Stefanie Sanders
    created by Stefanie Sanders
  • Is the use of a specific developer key recorded in Canvas Data anywhere? If yes, what information is recorded and how to get it?

    Developer Key is generated when integrating a third party product into canvas environment.