About the group

Harness the Power of Your Data

Gain meaningful insights from your data. Anthology Illuminate's (formerly Blackboard Data) engaging reports empower you to understand complex metrics at-a-glance

Get a clear picture of the learning activity at your institution. Know where and how you need to focus. Take the right action at the right time.
Illuminate Developer gives you direct access to the underlying data model powered by the Illuminate platform. It is helpful for Developers, Researchers, and System Administrators who want to create custom queries and analyses based on their institutional data. 

Explore Illuminate files: https://community.blackboard.com/groups/files/127

Saas Clients can request and use Illuminate at https://data.blackboard.com/
Illuminate Reporting runs on https://aws.amazon.com/quicksight/

Learn more about Snowflake and SQL by taking this awesome new course: https://data-explorers.blackboard.com/

Ten things to remember about data and statistics.

SQL for DDA queries:
https://github.com/carolynponce?tab=repositories
https://github.com/hcrites-cscc/blackboard
https://github.com/zenandjuice/bbLearnDDA

Tutorial for SQL in DDA:
https://terrytips.co/at2023-sql/

LTI code samples:
https://github.com/1EdTech/ltibootcamp

AI Developer Assistant
https://chatgpt.com/g/g-67b0b8c0b1d4819186026bdcdcc78aa1-blackboard-data-illuminate-ai-developer

Take part in the Discussion

Relevance
Duncan Wallace
Hi, I was wondering if people with some experience here could point me in the right direction. I desperately want to be able to get data into and out of Snowflake and after a bit of research decided that RESTful API access (using a JWT) ...
Nicole Trudell
We've been asked to provide data by College on the following: Courses with a syllabus (tricky because there is no syllabus item type) Courses using the attendance tool Courses using the gradebook (not overall grade, but gradebook in ...

@Nicole Trudell
There are a few ways to collect building blocks, internal Bb tools, and LTI tools.

We are working on ...

This is a query that reports tools used in student submissions:

with daily_activity as (

select
s.id,
s.name as ...

Rayan Fargo
Greetings, I understand there is a centralized way using Anthology Illuminate to generate reports automatically for all students/all classes in terms of Analytics -> Course Activity alerts (i.e., 1-Overall grade, 2-Missed ...
Jin Tan
Hello everyone. Hope this message finds you well. I wonder if anyone can provide some hints to me. I'd like to write a query using the new Reporting Framework tool on Blackboard Administrator Panel. The query is about to return a list of ...

@Jin Tan
I think you have Illuminate Extended Features.  We can help with Snowflake SQL development.
 

@Szymon Machajewski can you help with snowflake sql?

Steven Chippendale
I am getting to grips with Illluminate for the first time. The Ally reports include unused courses, so I wanted to report on Ally using Illumate, and apply filters. Has anyone worked out if any of the tables available contain the Ally ...

@Steven Chippendale

You can get the Excel version of the Ally report and this will give you detailed scores for PDF, ...

Dawn Hart
Has anyone conduct course reviews in Blackboard Ultra? Our institution has all online content go through a strict review before begin published. We currently send the course content to peer reviewers via a word doc. I would like to ...

@Dawn Hart
You can enable self-registration in the course, so reviewers can add themselves as students.

You can ...

Szymon Machajewski
Note the new AI category! Award Winners will be recognized across 9 categories:  Assessment & Institutional Effectiveness: This award recognizes customers that have successfully grown in their assessment practices and ...
Steven Chippendale
Can anyone please point me to the table and field that identifies a site as an Organization site? TIA.
course.stage:service_level::string = 'C'
Lou Stringer
Hi folks, I'm trying to report on discussions usage - just the total number of total posts, and maybe the number of responses and replies for each discussion. However, I can't see any way to get this data - is this available anywhere? ...
Lou,

Great topic. To understand your own business case in detail, I would suggest running some experiments. ...

@Szymon Machajewski Thank you very much for that. I hadn't thought about the submission table, I'll have a look.

Steve Bailey
Hi all. I've been contacted by a client who is struggling to extract data from Illuminate Developer (Snowflake) to Azure. I'm wondering if anyone has experience in this area and can share how they have achieved this, whether natively ...

@Steve Bailey
Later reply, but we use Python to pull data from Snowflake and import into local tools.  When the data ...

Unal Aksu Unal Aksu Aug '24

@Steve Bailey
We are using Azure Synapse Analytics to retrieve data from Snowflake. For this, we use Snowflake ...

Group Admins