Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

I am looking for some ideas, how to teach PE on canvas? 

Community Member
Data and Analytics Group
  • 2 Likes
  • 0 Replies

I'm looking for the best way to extract all user quiz responses across my entire organization.  For example, I have a post-course survey that collects feedback in the form of multiple choice questions and essay questions.  I want to see the individua...

  • 2 Likes
  • 4 Replies

Does anyone know if the outcomes tables are complete in Canvas Data?I can create the report I need using the API, grabbing the following information :api/v1/accounts/#{account_id}/outcome_groups?per_page=100outcome_group_id, outcome_group_title, pare...

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

We ran into some weird data while parsing the canvas tables which we were hoping you can explain àIssue - Student has an assignment record in CANVAS_SUMISSION_FACT but does not have a record in CANVAS_SUBMISSION_DIMCanvasUserid - '242384501320919508'...

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

I have been using this for new conversations created, I have an issue that every now and again it doesn't pass through the conversation id in the body. So it makes difficult to keep it consistent.Has anyone else experienced this issue?

  • 1 Likes
  • 5 Replies

Hello,I am being asked to pull in metrics from Canvas into Power BI.  Any assistance would be appreciated.  I have reviewed the Developer Key Creation.  Unsure how to tie it together.Thanks,Mo

  • 3 Likes
  • 3 Replies

Is anyone seeing a set of duplicate records appearing in the file_dim file?  My data load failed last night with this error on the file_dim load.Caused by: java.sql.SQLException: SQL Server Native Client : bcp_batch failed (sql state = 23000,01000) :...

  • 1 Likes
  • 3 Replies

The past two mornings, a subset of files in the data export contain data from the wrong tables. Later in the day, we notice that the exports have been corrected. We use the CLI tool to download and unpack the data exports. Is this something others ar...

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

Good day,I've been directed to this forum and i hope someone can assist me.I know that Multiple markers/assessors can mark an assignment and a moderator of sorts can chose the final mark.I've been told that the rubric reviews stay as part of the asse...

  • 0 Likes
  • 1 Replies

Is there a way in which I can get data regarding chat activity in courses? I have been looking in the Canvas Data tables, but can't find anything particularly useful. Also, the API doesn't seem to have anything. Does anyone have any suggestions, plea...

  • 1 Likes
  • 2 Replies

When I pull a canvas provisioning report I see a status column that lists courses as unpublished or published. Makes perfect sense. At my school we use oracle and have a reporting dashboard provided by OIT. When I search for unpublished courses I hav...

  • 2 Likes
  • 6 Replies

I'm trying to calculate the average number of times a student logs into Canvas, on an iPad, by program and term. I've been searching Canvas Data that's imported in our data warehouse to see if this exists.In pseudonym_dim you have last_login_at, curr...

  • 4 Likes
  • 4 Replies

Hello,I've been testing adding outcomes to my courses on the free for teachers site (https://canvas.instructure.com  )In doing this, I've created/deleted a lot of courses to start fresh every now and again. What I've run into is that when I import an...

  • 1 Likes
  • 2 Replies

Anyone using Talend to connect to the redshift database?

  • 1 Likes
  • 1 Replies