A brief writeup of my BBWorld09 session. The PowerPoint file is here:

PowerSight Presentation from BBWorld09

What is the PowerSight Kit?

What is the PowerSight Kit? It’s a series of views in the database that are denormalized to make them easier to query. They include:

• rpt_gradebook
• rpt_learning_context
• rpt_learning_context_size
• rpt_member
• rpt_person
• rpt_template
• rpt_tracking

All of these views have interesting information in them, but for my purposes, I spent my time analyzing rpt_tracking. Rpt_tracking contains a record for every action taken in Vista, along with who took the action, which section it was in, which tool was used, and exactly when (down to the millisecond!). So you can see how parsing through this data could yield some useful results.

» Continue reading “Extracting Useful Information from the Powersight Kit”