Skip to content

Cross-source questions

PowerSchool and Canvas in one question

Ask questions that join PowerSchool attendance and enrollment with Canvas course activity and missing work, with the query and lineage for each system.

Short answer

One question can span PowerSchool and Canvas, such as which students absent more than five days this term also have three or more missing Canvas assignments. Nexatron queries each within the requesting user’s existing access, combines the results in an isolated step inside your workspace, and shows each source’s query. PowerSchool and Canvas are both available.

Example joined questions

Questions to ask. Each needs data from both systems; the answer depends on your own data and definitions.

  • Which students absent more than five days this term also have three or more missing assignments in Canvas?
  • How does the daily attendance rate at each school compare with the share of its students active in Canvas each week?
  • Which students marked present in PowerSchool have had no Canvas activity in the last ten days?
  • How do missing assignment rates in Canvas differ between chronically absent students and their classmates, by grade?

Agree how a PowerSchool student relates to a Canvas user before joining. Most districts already sync PowerSchool rosters to Canvas with the student number as the SIS ID; matching by name is a guess.

Check before you trust a joined answer

  • Both sides use user-level access: Nexatron inherits each user’s PowerSchool roles and Canvas course roles, so a teacher sees only their own students in both.
  • Attendance is recorded by day or period and Canvas activity by event. Agree the week or term both sides are counted over.
  • Students who enroll or leave mid-term can sit in one system and not the other until the next roster sync. The answer says how many records matched.

How a cross-source answer works

  1. Each system is queried within the person’s access

    Nexatron sends each part of the question to the system that holds it. Each system answers with user-level access: Nexatron inherits the requesting user’s existing permissions in that system.

  2. Results are joined inside your workspace

    Nexatron combines each system’s results in an isolated step inside your tenant when the question is asked. Nothing has to be consolidated into a warehouse first, and there is no pipeline to build.

  3. The queries come back with the answer

    The answer carries the generated query for each system and how many records matched, so a reviewer can check which system supplied which figure and repeat the check later.

  4. Joins follow links found at setup

    Nexatron joins on the links setup found between the systems, and says how many records matched. If no record matches, it says so and marks the figures as uncertain.

  5. Currencies are never added up as they are

    Amounts in different currencies are converted with one system’s own exchange rates where a usable rate source exists, and otherwise shown side by side with the reason.

  6. Longer than a single-source answer

    These answers take longer than single-source ones.

More on how it works and its limits: Cross-source analytics and the guide to cross-source analytics without a warehouse migration.