With what you're trying to do, you could run the code from a server and host the database in the same place. The code could run locally on a machine as long as the user has relevant permissions, however it may be best running on a server, where the authorised user can log on and query data, it's really up to the school how it can be implemented. Hi David, the way it works is we use Groupcall's Xporter to take data from an MIS system, and then basically populate the data into a PostgreSQL database, which can then be queried and visualised using something like Superset (or if the school has a prioprietary BI tool they can use that). You mention Groupcall Xporter and Apache Superset in your post, is your project basically some kind of application that gets data from Groupcall and puts it into Superset? How is this application implemented - as something a school installs on a web server and points users at?

I agree with the general idea of a project of some sort to work on data analytics for schools, but your website is rather short on detail. If a bunch of data-processing scripts already existed in some form which I could use that would be very handy and save a lot of time.

I'd split users into groups (teachers, senior management, finance, etc) and generate a separate dashboard for each, making sure each dashboard could only be viewed by the appropriate users. My current plan for data analytics for our school / group is to have a set of (probably Python) scripts that take in data from CSV / XML files (we export data from the iSAMS API) and produce a set of static HTML files that can then be served to appropriate users, with suitible authorisation settings.

I was curious if anyone had any ideas, feedback or can poke any holes in this, or even better, would like to contribute to the project?I agree with the general idea of a project of some sort to work on data analytics for schools, but your website is rather short on detail.

Bi tools open source