Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

Hello all, Our institution has kicked off an initiative to utilize CD2 data to develop robust student success KPIs and, later, metrics for instructor success.We're looking to learn from those who are already down this path and hear about your success...

  • 2 Likes
  • 2 Replies

I am trying to run an initdb command using dap and connecting to an existing SQL server DB and Table but receiving an "unrecognized dialect" error. Can someone point out if this is the correct way of setting the connection string in the environment v...

  • 0 Likes
  • 2 Replies

Hi, We recently had a space issue with the PC where we routinely run a syncdb on the web_logs table in the canvas_logs namespace. The space issue has now been resolved but when I attempt a dap syncdb it is erroring with "The maximum interval for this...

  • 0 Likes
  • 3 Replies

  EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and s...

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

I just noticed an update (posted about a week ago) to the canvas product roadmap that seems to indicate that "New Quizzes data is now available in DAP/CD2, providing seamless access to key data points for analysis. Institutions can now retrieve quiz ...

  • 1 Likes
  • 1 Replies

When I try to run the following command: dap initdb --namespace canvas --table accounts I receive the error: missing dependency: `asyncpg`; you may need to run `pip install pysqlsync` although pysqlsync is installed already. (pysqlsync 0.8.3) Any adv...

  • 0 Likes
  • 3 Replies

Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page ...

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

  I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key informat...

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

Has anyone implemented some form of data profiling, quality assurance checks, or similar mechanisms to identify significant changes and/or problems in the data you're bringing in from DAP? If so, would you be willing to share what you're doing as exa...

  • 0 Likes
  • 2 Replies

I am aware that Canvas offers a limited analytics suite for courses. I am also aware that you can track the course time spent per student. We would like to average how long it takes our students to complete our courses, but as far as I can tell, ther...

  • 0 Likes
  • 1 Replies

This is what I currently see, but we do not have that feature enable and it would be highly needed to pull attendance reports across different courses. Many thank in advance. Guido Reverdito  

  • 0 Likes
  • 3 Replies

The issue -- we currently pull reports from the api/v1/reports several times a day, and the person who is responsible for those jobs that has complained to me on multiple occasions that they take a long time and often get stuck or fail, because of th...

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

Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to determine which files are visible to students (on...

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

I am developing a AWS process that uses a Step Function to coordinate Lambda Calls in order to get data from the DAP client for our data lake.  However, I am running into an issue with the Submissions table where it is taking almost an hour for an In...

  • 0 Likes
  • 1 Replies

Hello - I am trying to decipher the web_application_action column in the web_logs table. Per the schema, the integers returns should be referring to "The action in the Canvas web application used to service this request."  I can not find any referenc...

  • 0 Likes
  • 4 Replies

Using Canvas Data 2 data, I'm looking at student answers for Calculated questions.  When a question is correctly answered, the Answer_ID is populated.  When the question is incorrectly answered the Answer_ID is empty/blank, in fact the name/value pai...

  • 1 Likes
  • 2 Replies

Hi all, We have a small number of records for the CD2 web_logs table where the course_id column is populated by what looks like the shard id (flashbacks to CD1) and not the course id. (I don't mean the shard_id + course_id, but just the four digit sh...

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

Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data.We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP...

  • 2 Likes
  • 1 Replies

We upgraded to the new DAP CLI 2.0.0 and are trying to use the new logging feature but we're getting "Error: No such option: --loglevel" This is our command: dap initdb --table attachments --namespace canvas --loglevel debug  

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

Hello all, I am sitting in a session at instructurecon right now and a lot of people are asking questions about getting started with their reporting and analytics goals. I thought I would make this post so that people could connect.

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

The context_modules_progressions table is said to show which items a student has completed, started and not started in a module.   https://developerdocs.instructure.com/services/dap/dataset/dataset-namespaces/dataset-canvas#dap_schemas.canvas.context...

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

Hello friends! I am reaching out to better understand what the wider community, or those willing to have a quick email chat, is doing with regards to understanding their Outcomes.   Previously, we had a person from our Data & Research Team who would ...

  • 2 Likes
  • 2 Replies

Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data.We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP...

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

We're having issues with the SQL generated by the DAP. I was on the 1.3.1, and now using 1.4.0,  to see if that might resolve the issue. I'm using the python dap module to sync/init  and using the MS SQL Dialect for our canvas data 2 tables and I not...

  • 4 Likes
  • 5 Replies

This API is working great for students:  https://xxx.test.instructure.com/api/v1/courses/:courseid/analytics/users/:userid/activity But it is limited to student data.  How are folks using the API to get high level activity data by course? 

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

I'm working on an archiving scheme for our past courses. As part of this, I'm interested in finding a way to generate a report featuring all the courses that have had no user access in five or more years. How might one find this out using Canvas data...

  • 0 Likes
  • 2 Replies

Is there a way to tell via CD2 if a course is using Enhanced Rubrics?  I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian

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

Hi,  When I try to export a table through dap intidb command for a table from canvas space: context_module_progress. I use the following command:  dap --loglevel debug initdb --connection-string "mssql://username:password@prodsqlserver.database.wind...

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

Hello,  I'm posting here for our developer. I hope someone can help steer us in the right direction. We have been running the CD2 API for almost a year. We have run a full reload of the tables once with a column addition, and process delta runs daily...

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

Hi,I am trying to load two tables from canvas namespace into SSMS through the use of DAP command line interface:This is the command that I am using:dap initdb --connection-string "mssql://username:password@princedev.database.windows.net:1433/princedb...

  • 1 Likes
  • 2 Replies