Data and Analytics Discussions

Discuss, share tips, and ask questions about data and analytics across all our products

So, not super familiar with Azure but we've managed to set up a pipeline (but getting occasional fails) and debating finisihing incremental approach. I do ultimately want to get this into a postgres d...

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

Hi -- I'm having trouble getting dap syncdb to work in a reliable/predictable manner w/r/t the application of upstream table schema changes to my local database. For some reason it seems to be trying ...

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

A higher-up asked my boss and me whether it's possible to track which faculty members are using the Attendance (Roll Call) tool in their courses. Since we have it disabled by default in all of our cre...

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

Hi, I've just updated to the latest v1.0.0 version of the dap-client plus updated the cryptography to v42.0.5 & even when I now attempt to run just 'dap --version' I get the aforementioned DLL load er...

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

After upgrading to the 1.0.0 DAP client yesterday, I'm now getting a very specific error: ERROR - [Errno 28] No space left on device It appears that the DAP client is now loading up my /tmp location (...

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

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull in...

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

Greetings, I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not...

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

Hi all, I was able to populate local PostgreSQL using the Python dap client, but there seems to be a discrepancy in the number of rows imported compared to what I see in the Canvas web app.For example...

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

A couple of years ago, I submitted this question to the community: https://community.canvaslms.com/t5/Data-and-Analytics-Group/How-to-Track-External-App-Usage/m-p/529110#M1466 Now that Canvas Data Por...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 9 Replies

We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can ca...

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

Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs.It states that web_logs defines as follow:Store...

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

Hi all,My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back ...

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

Hi all,   I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the c...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 7 Replies

Hi everyone,does anyone have any experience or lessons learned in regards to processing the CD2 web_logs table in AWS (Glue / Athena / etc)?We don't have any immediate specific use cases, but we know ...

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

Greetings, I'm curious how others are using and managing the Canvas web_logs data and activity reporting. There's a lot of, often vague but genuine, interest in this data for things like, Querying cou...

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

I have an instructor that uses both PDFs and links to websites for students to access and read.  The analytics will show if they downloaded the PDFs but not if they accessed the links.  Is there a way...

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

Our organization would like to have access to Canvas Data 2. Going through Canvas Data 2 blogs, it says to contact the Customer Success Manager to get unboarded. I have no direct contact with CSM wher...

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

I'm working with exported data from CD2.  I'm trying to understand how a version of a quiz submission (QUIZ_SUBMISSIONS.QUIZ_VERSION) relates to the version of the quiz.  I don't see a version assigne...

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

Good Morning, I'm an LMS Admin trying to assist my BI Systems Director with our transition to Canvas Data 2.0 and Managed Teaching & Learning. We pull submission data to share with our campuses and pr...

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

I have a question relating to Canvas data 2.0. Will this result in any changes/updates to the admin reports - meaning the student submissions report, grade export, user course log, etc.?Will there be ...

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

We want to do some statistics on the use of "Act as ...", and try to do this by checking the CD2 web_logs (/dap/query/canvas_logs/table/web_logs/data). When we look in the column "value.real_user_id" ...

Community Participant Data and Analytics Group
  • 1 Likes
  • 2 Replies

Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade? In the scores table, scores.course_score is a boolean value where true "represents the overall score...

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

Hi -- I'm trying to run my DAP init/sync process in AWS Lambda which does not have a writable filesystem by default. This had been working fine as of DAP Client version 0.3.15, but more recent version...

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

We're trying to find the course publish date and who published over a range of courses.  We know we can use the Course Audit API - https://canvas.instructure.com/doc/api/course_audit_log.html Checking...

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

I am attempting to use SQL to query the tables to identify the current score or points/points possible by student for each class and for each assignment as well as any quizzes (etc...). If there is a ...

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

Good morning, we were looking at Canvas Data 2, and at the data available to us. We do not have access to web_logs.   We have found out that we do not have web_logs because we subscribed to the servic...

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

Installed the instructure-dap-client in Python 3.10 (tried 3.11 as well). Getting an error each time we try to invoke it:[SSLCertVerificationError: (1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate ve...

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

I have an instructor that created new quizzes for an entrance survey and an exit survey that gauges students' knowledge pre & post course. I've downloaded our Canvas Data 2, and loaded it all into Pow...

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

I'm part of the support team at a small private college (around 1500 students) and we're working towards migrating all our courses' classic quizzes to new quizzes. I was curious if there was a way to ...

Community Member Data and Analytics Group
  • 1 Likes
  • 4 Replies

Data and Analytics Blog

Read tips and tricks about Instructure's data and analytics features

Overview: Introducing the GA release of the Data Access Platform CLI & Client Library! In this post, we'll walk you through everything you need to know to effectively utilize the Data Access Platform ...

  • 0 Likes
  • 0 Replies

In the past two days, our weblogs (including user_agents table) data processing experienced some issues while completing the query jobs for customers in the North Virginia region. As an effort to prev...

Instructure Alumni Data and Analytics Group
  • 1 Likes
  • 16 Replies

This is a notice to customers, that our data processing experienced some issues and queries returned 502 while execution time started to increase. We have set the Canvas Data 2 status to Performance d...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

What is Canvas Data 2? Canvas Data is a comprehensive analytics solution. It offers administrators and institutions the ability to access and analyze data related to student and course activities wi...

Instructure Data and Analytics Group
  • 8 Likes
  • 2 Replies

A bug fix that was released on September 22nd may affect your integrations:What was the problem that we fixed? For the tables that use the function compose_version_global, the resulting id’s can be in...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 1 Replies

Queries for Canvas metrics.  Anyone have sql queries for clicks, views for assignments by college. And other metric queries for external ,tools used, submissions in a day by college. If you have a sta...

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

Back at the start of the year I had the idea to repurpose some of the reports we had previously created to support our residential campuses.  This included a modified version of an early warning repor...

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

In the past two days, our Canvas Data data processing experienced some issues while building files for Canvas Data customers in the North Virginia region. Some customers might not see the latest data ...

Instructure Alumni Data and Analytics Group
  • 2 Likes
  • 1 Replies

Since Caliper events were introduced, some Caliper events have been mistakenly classified as events triggered by an application (where an agent is a software application), instead of end-user trigged ...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

We have identified a root cause of the request data loss and remedied the situation. Unfortunately, the volume of requests was very high and up to 20% of request logs were omitted from the Canvas Data...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

Due to the unprecedented volume of requests coming to Canvas application servers, our request data sharing process for the North Virginia region has experienced some request log data loss on 8/24, 8/2...

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 2 Replies

In the Canvas Data (2018-12-11) release, an identifier that is a reserved word in some systems (such as AWS Redshift) was introduced in some Outcomes Tables. The ‘percent’ column in the learning_outco...

Instructure Data and Analytics Group
  • 3 Likes
  • 1 Replies

We're proud to introduce a Canvas Network course being offered FREE by Jing Qi and Brian Reid of Dartmouth College. The course is titled "Analytics in Course Design: Leveraging Canvas Data," and will ...

Instructure Alumni Data and Analytics Group
  • 10 Likes
  • 1 Replies

Data and Analytics Blog

Read the latest updates for Data and Analytics products from the Product Blog.

Data Access Platform CLI & Client Library is now GA

(Instructure)
The Product Blog

Canvas Data

Canvas LMS

Developers

  • 5 Likes
  • 6 Replies

The Data & Insights team is continuing to look at how we can improve the experience when using the Data Access Platform (DAP) Query API directly and we'd like to get your input.

(Instructure)
The Product Blog

Canvas Data

  • 3 Likes
  • 10 Replies

As the end of 2023 is approaching, we offer you a brief retrospective of what’s new with Canvas Data, an important reminder about migrating data to Canvas Data 2 as Canvas Data 1 reaches end-of-life t...

(Instructure)
The Product Blog

Canvas Data

Canvas LMS

  • 3 Likes
  • 12 Replies

In the November 8th Canvas deploy, Admin Analytics will release a new navigation.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 5 Likes
  • 5 Replies

Great news for Catalog users (and future Catalog users) : I am happy to announce that as per our commitments, Catalog data is available, labeled as BETA, via the CD2 API and CLI. Isn’t it great? 珞

(Instructure Alumni)
The Product Blog

Canvas Catalog

Canvas Data

  • 2 Likes
  • 0 Replies

TLDR: The Admin Analytics and New Analytics feature options will default ON in the December 16 Canvas release.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 3 Likes
  • 4 Replies

As we are approaching our next significant release, Canvas Data 2 will include weblogs (currently requests table in CD1). Important note:  the target release date has changed from 21 June to 5 July an...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 4 Likes
  • 16 Replies

I’m excited to let you know that we’re planning to release filter updates to Admin Analytics in the July 5th Canvas deploy and changes to the Overview dashboard in the June 21st Canvas deploy. 

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 2 Likes
  • 4 Replies

We've appreciated all the great feedback on Canvas Data 2 since we released it in March. Today we are going to share some updates on planned features as well as guidance related to timelines and migra...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 6 Likes
  • 21 Replies

Admin Analytics will be available as a Feature Option with the March 29th Canvas deploy.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 11 Likes
  • 18 Replies

The day is fast approaching when customers can opt in to Canvas Data 2.  It’s been a major development effort and finally, the big day is the 18th of March. YEEEY. 拾 Read on to learn more about this e...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 5 Likes
  • 1 Replies

We are very excited to share that Canvas Data 2 has evolved from infancy into adolescence. We started last year in June with inputs and feedback from 13 Alpha customers from two regions and have grown...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 9 Likes
  • 12 Replies

It is time to share progress on the Canvas Data 2 product development.

(Instructure Alumni)
The Product Blog

Canvas Data

  • 11 Likes
  • 13 Replies

First, a big THANK YOU to all who have completed the CD2 survey. I was really excited to see how this number has been growing day by day, a number that shows a great interest in what we are building. ...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 6 Likes
  • 19 Replies

As promised, in this blog post I will share some further news on our progress with Canvas Data 2. In my previous post I mentioned why we needed to re-architecture our data pipeline and what things we ...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 9 Likes
  • 9 Replies

Let’s just start in medias res because I am pretty sure that most of you are curious about not just the state of the Canvas Data 2 but also about what comes next (and why it didn’t come yet). The ques...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

  • 11 Likes
  • 14 Replies

When I think about education and what it means to me, one word irrevocably comes to my mind which is “Ikigai”—the Japanese word referring to something that gives a person a sense of purpose. Let's tal...

(Instructure Alumni)
The Product Blog

Canvas Data

Canvas LMS

General Education

  • 4 Likes
  • 0 Replies

Hi, @dlyons! I am the account admin for our district. We monitor the use of accommodations for our students and would like to pull usage data for the use of the Microsoft Immersive Reader tool in Canv...

(Community Participant)
The Product Blog

Canvas

Canvas Data

Canvas Partners

  • 0 Likes
  • 0 Replies