About

ryan_schulte
Ryan Schulte
Rank:
Community Novice
Title:
Joined:
Nov 6, 2015 7:29:50 AM
Posts:
10
Solutions:
0
Likes Received:
27
Bio:
An amazing Instructure Community member

Most Liked Posts

Hello Everyone,I am trying to calculate the amount of time a student has logged into a give course.  So far I have been able to do this if it is the student's first course but cannot distinguish b...
Likes: 5
Hello Everybody,Thank you for the tips.  I think sorting by user-id, then timestamp oldest-newest and lastly removing dups on session ID works.  you can pivot the data for count of session to get logi...
Likes: 4
Hello,We have been trying to grasp this concept as well.  Comparing all the places the login data comes from it is clear to me that last user access is typically the most up to date.  However, it has ...
Likes: 4
I am not using MySQL but I thought I would throw my experience in the mix.  I do not use MySQL and prefer to query directly to the database.A couple simple things that I do to reduce the data is to fi...
Likes: 3
I have started to transition some of our reports to Power BI, although most have been unrelated to academics thus far.  If Canvas BI developers want to collaborate and / or share count me in though.  ...
Likes: 3

Most Recent Posts

I have a few reports which connect to Canvas Redshift via ODBC through Excel.  They have worked 100% until this morning.  The query will run with no errors and the column titles will load however ther...
Jul 7, 2017 6:36:36 AM
Stuart,There are only two reports I have created which rely on the Request table.  For both reports I am looking at / analyzing real specific things so the queries I am running are not pulling in more...
May 22, 2017 9:46:38 AM
It seems like a lot of institutions are using the bulk downloads.  We are querying Redshift via ODBC into excel files and putting them in sharepoint.  Our Power BI reports refresh from those sharepoin...
May 19, 2017 9:18:44 AM
I have started to transition some of our reports to Power BI, although most have been unrelated to academics thus far.  If Canvas BI developers want to collaborate and / or share count me in though.  ...
May 17, 2017 6:46:45 AM
Brian,I really do not mess with the requests table all that much.  At the request of course designers, I have compared page designs to see which yields higher page requests and also used it in cases w...
Jan 4, 2017 2:38:49 PM

Latest Badges

First Like Received

First Like Received

Earned: 2024-01-05

Instructure Community: 8 Year

Instructure Community: 8 Year

8 Years with Instructure Community

Earned: 2024-01-03

Instructure Community: 7 Year

Instructure Community: 7 Year

7 Years with Instructure Community

Earned: 2024-01-03

Instructure Community: 6 Year

Instructure Community: 6 Year

6 Years with Instructure Community

Earned: 2024-01-03