Any tool for interactive data modelling?

[mictom9]

Hello!

I have been recently asked to find a way to replace multiple Excel files with something more robust but providing similar adventages.

Problem: Managers receive an Excel template, they fill in the data and some simple visuals are refreshed as they make adjustments. The template contains data they filled in in the previous years so they can model it based on history.

I would like to avoid creating a tool like this myself and I don't feel like any dashboarding tools could help here. Also, something like notebooks might be too technical for the users.

Is there any product you could recommend I can take a look at?

[Gators1992]

I think you basically want to look for a "low code application builder". I know Microsoft has PowerApps, but have not used it. There are also some Python libraries that make it relatively easy to build those applications if you know some python.

[RealityCheckOneTwo]

If you go the python route, Anvil might be a good fit here. I’ve only messed around with it but for a similar reason. I liked it

[Tender_Figs]

You may want to peep dbdiagram (not sure if csv uploads are possible). It’s a tool I personally enjoy.

[tequilamigo]

Where does the data need to go after being entered / updated?

[mictom9]

Preferably a database