Typical Reporting for Canvas System Usage

[jfountain]

I'm interested in hearing what reports your school views on a regular basis to gauge adoption and usage of the Canvas system. 

My primary interest is in employee adoption and use of the system's tools and course engagement by faculty.  I'm also interested in measuring what tools/pages the students are accessing most often.  I've been noodling around in the Admin panel using Analytics and Reports, but it's not very robust or specific enough for metric reporting.

Background:  I am the Canvas admin at our university.  We just implemented Canvas this year; and I'm very new to Canvas Data.  Report building is not my specialty although I have a basic understanding of database structure and storage. Our data is housed internally in our University's data warehouse.  I have Power BI as my report builder, but I don't have the knowledge yet to build reports using this software.  If anybody has Power BI report structures built for Canvas that they would be willing to share, I would be forever grateful!

Thank you for any help you can provide.

[jasmiene_doming]

Hi! I am also having similar challenges whe it comes to report generation.

Like you, I am also waiting for anyone who knows Power BI to help manipulate the Canvas Data Flat Files.

My specific need to measure the user engagement  is to know which fact & dimension tables must I join in order to

generate a monthly status report for courses under each sub-account level.

SAMPLE NO. 1 

HOW TO

select sub-account + selected date range + course id + faculty who handles the course + total no. of students enrolled + number of content published 

SUB-ACCT	DATE RANGE	COURSE ID	FACULTY	NO. STUDENTS ENROLLED	NO. OF CONTENTS PUBLISHED
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	5

SAMPLE NO. 2

HOW TO

select sub-account + selected date range + course id + faculty who handles the course + total no. of students enrolled + specific content published + number of unique views + number of unique responses 

SUB-ACCT	DATE RANGE	COURSE ID	FACULTY	NO. STUDENTS ENROLLED	SPECIFIC CONTENTS PUBLISHED (Heading)	NO OF UNIQUE VIEWS	NO. OF UNIQUE RESPONSES
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	Announcement 1	15	0
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	Quiz 1	43	37
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	Discussion 1	2	0
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	Discussion 2	4	0
CAS	Sept.2-Sept. 30, 2019	ADV 2	Juana Dela Cruz	45	Discussion 3	41	0

[stuart_ryan]

Hi @jfountain  and  @jasmiene_doming ,

I have been doing a little sleuthing and wanted to pull together some useful threads that I have found which have some examples and might help get you both started.

• Compelling uses for the Requests table? 
• Power BI 
• Power BI and onsite Canvas Data warehouse 
• This video is currently being processed. Please try again in a few minutes.
   (while this is a few years old) a lot of it is still relevant today, there are some good concepts especially from about half way through with some of the questions that were asked. 
• https://community.canvaslms.com/thread/40458-specific-factdimension-table-combinations-including-fie... (another thread for you Julie that Jasmiene has going with some good comments from James Jones)

I hope that helps you both out!

Stuart