Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

The enrollment_term_dim table already has the date_start and date_end fields, but they are not populated yet. Any idea when these fields will be populated?

Community Contributor
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Does your institution have a clearly defined understanding or procedure concerning the governance of Canvas data. We had been using Canvas data extensively to address various questions ranging from student, course to departmental level. Now Instructu...

Community Novice
Data and Analytics Group
  • 0 Likes
  • 0 Replies

We currently leverage the Canvas Analytics API to query page views as a measure for engagement.The page views are, typically, less than the counts per user from the requests table - which makes logical sense.  However, the magnitude of this differenc...

  • 16 Likes
  • 50 Replies

I can't find anything in the documentation discussing encryption for Canvas Data. When the data is instantiated in Redshift, is encryption enabled to protect data at rest? Is there any encryption on the flat file repository?Glenn AuerbachUniversity o...

  • 6 Likes
  • 3 Replies

Hey all,I posted to feature suggestions a while ago asking for implementation of scoring details for the total grade so students can see how their overall grade aligns with the class average. While procrastinating from studying for my finals I create...

Community Novice
Data and Analytics Group
  • 1 Likes
  • 0 Replies

This is a user action from the Grades tool that allows students to see course average & range for each graded assignment.  It's a click on the button on the right-hand menubar marked "show all details"I think it might be '/api/v1/courses/<###>/ping' ...

  • 5 Likes
  • 1 Replies

I'm having some issues installing on ubuntu linux.  I have the latest nodejs available for ubuntu - v0.10.37Can anyone help with this?  I get the following results when I install canvas-data-cli:  root@canvasb:/home/millerjm# npm install -g canvas-da...

  • 6 Likes
  • 3 Replies

I am using MS Access to join my tables and look at the resultant data.  When I bring in the quiz_submission_fact date field as type "date/time", MS Access errors out.  It does not recognize it as a date/timestamp (2015-11-05 15:10:18.738301). Any sug...

  • 6 Likes
  • 1 Replies

Greetings, I am using the new canvasDataCli and I have successfully synced my data but was wondering if someone could provide sample syntax for unpacking the files and adding headers?

  • 2 Likes
  • 2 Replies

Hi there,Following the terrific advice provided by James Jones and using some tools available on the Web, I built a signature file, generated an HMAC-SHA-256 digest and had it base64 encoded. I then tried testing the access using Postman.  Here's a s...

  • 2 Likes
  • 3 Replies

How will grading periods be used in Canvas Data?  For example, Current and Final grades which are available in Canvas Data, are likely aggregate grades over the duration of the term.  If the term is full year and the institution is using grading peri...

Community Champion
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Didn't see anything similar to an e/r diagram - or anything that depicts the relationships between the tables in the documentation portal.  Did I miss it? 

  • 11 Likes
  • 21 Replies

web_applicaiton_action isn't spelled correctly.  hopefully this will save some of you some time banging your head against a wall trying to figure out why your sql isn't working...!

Community Novice
Data and Analytics Group
  • 1 Likes
  • 0 Replies

SynopsisCalls 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 the signature needed to use the ...

Community Champion
Data and Analytics Group
  • 21 Likes
  • 6 Replies

Hi, I'm looking for a "data extract date" or "data as of date" so that we know when the data was pulled into Redshift.  I didn't see a status date or table anywhere in the documentation, but maybe I missed it?  We could retrieve the max(timestamp) fr...

  • 3 Likes
  • 12 Replies

Still getting my feet wet here, but, I'm curious why there is sometimes more than one fact file. Here's an example:

  • 2 Likes
  • 1 Replies

I have been working with one of our Analyst in Institutional Research to try and get our data into database software we can work with to start evaluating what all is there and what we can do with it. For background, we are on the free tier. With that...

  • 2 Likes
  • 1 Replies

Is there a document that specifies individual data elements that are:Available in Canvas Data but not via the API; andAvailable via the API but not in Canvas Data?Maybe Deactivated user​ can answer?

  • 6 Likes
  • 6 Replies

Contrary to what appears to be a common belief, not all Canvas admins are computer geeks. Most of us did not need those skills in the prior LMSs we migrated from - everything was done through the UI. Many of us, myself included, are becoming more gee...

  • 8 Likes
  • 10 Replies

I know this is a total newby question, but when I review the BI tools to access the data files, they all seem to require Amazon Redshift Credentials, which are only available in the paid version of Canvas Data. Some of us (most of us) need informatio...

  • 4 Likes
  • 5 Replies

Hello.  We are building a report with grades for students who dropped the course.  The report grades earned on any assignments before the student dropped as well as current and final scores and grades.  We have discovered that the enrollment_fact tab...

Community Contributor
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hi, I am new to the Python requests library and I am trying to figure out how to make an api call to dump the data files from Canvas. I keep getting a 404 error, so I just want to make sure I'm forming the request correctly. I looked at the API guide...

  • 12 Likes
  • 25 Replies

We are looking to extract and report on  Outcome data.  Is there a time frame when this would be included in the data ?

  • 1 Likes
  • 1 Replies

We have configured an ODBC connection per the information we found elsewhere.  Testing it while configuring indicates it was successful.  We can use it with no problems to retrieve information into Excel.  However, when trying to link to the same tab...

  • 1 Likes
  • 1 Replies

We have configured the ODBC connection and can connect to tables and retrieve data using Excel, but when trying to link to tables using Access we receive the message: "Reserved error (-7733); there is no message for this error."  Has anyone else expe...

  • 1 Likes
  • 1 Replies

In the data portal it says "Please note that the date specified does not reflect the actual dates of the data, but instead when the data was finished exporting. The most recent data in a given export is generally 24-36 hours older than the date given...

Community Contributor
Data and Analytics Group
  • 1 Likes
  • 1 Replies

I noticed today when working in one of my sub accounts, that I can access the Canvas Data menu item from the SubAccounts.   Is there anything special about accessing the Canvas Data panel from a SubAccount?    Thanks< Glen

Community Champion
Data and Analytics Group
  • 1 Likes
  • 0 Replies

Looking at the "Create Credentials" page, it looks like I, as myself, can create a single set of credentials.   So, If I want to share those credentials with others, they all use a common set of credentials created by me.      If things go sideways, ...

  • 2 Likes
  • 3 Replies

Looking at the Docs, it looks like I would use the option to Create API Credentials.    This for sure lets myself, and anyone I give them to, access to download the data files and load them into my private DBMS.   But, I was told that Civitas, in par...

  • 2 Likes
  • 2 Replies