Historical behaviour data reporting in Bromcom/Power Bi

[davie887]

We've made some nice reports using odata into Power Bi but it appears the records are only for one academic year. Has anyone figured out how to export previous years data for comparison purposes? I think I will need to mirror most of the Students and BehaviourEventRecords tables

[Devaleth]

If you want more than current year students I believe you'll need to get access to the oData feed from Vision.

[davie887]

4 minutes ago, Devaleth said:

If you want more than current year students I believe you'll need to get access to the oData feed from Vision.

 

Hi, we don't have vision, but I have the odata feed, however it is only current academic year. I am thinking I need to do a report and make the data accessible via URL (or just CSV it once as it won't change) but was hoping that someone has done the brain work already! 

 

 

 

[Devaleth]

I'm not sure then I'm afraid. I ran into the same problem and my MAT gave me access to Vision so I can get the full historical picture.

 

It's not consistent though - for instance I was able to pull historical suspension data through Bromcom oData...but only for students who had been on roll this academic year. However with behaviour records I could only get current academic year behaviour logs, no history.

[bobsmith]

if you aren't in a MAT then you won't have access to vision (which has a much more comprehensive feed) - but you can pay for it - I never got to the point of getting a price though.

 

I still think they need to make the datasets the same though - not everyone is in a bloody academy chain.

[Marci]

Yes, you can make a quickreport that takes out whatever data domain, and patch that in via live feed (get data > from web > paste livefeed URL for quickreport, accessible from reports list > select report > actions > livefeed).

For Behaviour events... set QuickReport Data domain dropdown at top middle to "Behaviour Event Records", then for auto-refreshing direct from the livefeedURL, tick the "All Date Intervals & Filters" button, set the Date Interval on the domain to "Show All". Add whatever needed from the field list.  The output of that is the equivalent of what we get from Vision - all BehaviourEventRecords recorded in the system for as long as you've been using the system.



For exporting CSV archives for a specific timeperiod, set the Date Interval to the specific date range, export, and bring the CSV in from a Sharepoint repo.

Don't use the "runtime" switch on anything that you'll be consuming direct via livefeed - you can't provide parameters on a livefeed request.

Edited April 27 by Marci

[Marci]

Quote

I still think they need to make the datasets the same though - not everyone is in a bloody academy chain.

 

I've been wanting parity across the feeds for years. Back when we first switched in 2018, I developed everything based on CloudMIS feeds, (incorrectly) assuming whatever I designed for CloudMIS we could then just swap the oData endpoint out for Vision and it'd then work for bringing in multi-school/multi-year data (because there was no documentation around any of this and I hadn't yet been given access to the Vision feed).  Ended up having to rewrite months of work due to this incorrect assumption.

Table names, structures within those tables, and even the data-type of individual fields vary from feed to feed.

Edited April 27 by Marci

[davie887]

Thanks. I put my thinking hat on and found all the data I need from 23-25 in the Behaviour and non-basic Student data domains. I am have been impressed with reporting in Bromcom, live data etc. Lightyears ahead of SIMS

 

 

 

 

Edited April 27 by davie887