Retool PM here. This sounds like a good use case for Retool! (I built something similar to join performance data with metadata using Retool in my last role).
While we don't currently support using Python or R in apps, we do have something new shipping soon that'll make it easier to run heavier statistical lifting server side. If you're interested in a beta access, or even pairing on a build session, let me know at [email protected].
Also, I think pre-calculating values and storing them in a database table is a smart idea if your velocity is increasing and you want folks to be able to access reports themselves. Your users will get a snappier app and you'll have a historical record of experiment results to reference.
While we don't currently support using Python or R in apps, we do have something new shipping soon that'll make it easier to run heavier statistical lifting server side. If you're interested in a beta access, or even pairing on a build session, let me know at [email protected].
Also, I think pre-calculating values and storing them in a database table is a smart idea if your velocity is increasing and you want folks to be able to access reports themselves. Your users will get a snappier app and you'll have a historical record of experiment results to reference.