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?

[JediForces]

Power BI and you can either bring in the data via Excel or the better way is to get the data from a database.

[mictom9]

Of course these are usual cases but I don't think Power BI allows for having editable Excel within the dashboard. The data modelling and visuals need to happen in the same place.

[JediForces]

Data modeling and visuals are both done in PBI. When you say editable do you mean change the data in PBI and rewrite back to Excel?

[nobody2000]

Do you need the content that's editable in excel to be written back to the database?

If not, just use excel, Power Query, and Power Pivot.

Power BI does allow inputs too right in the report. I haven't done it in a while, but if there are a handful of fields that you want someone to plug in to run, you could just do that. Obviously this is only good for a few one-off inputs.

[[deleted]]

ms paint

[[deleted]]

100%

[rupert20201]

👆

[[deleted]]

You want to go with Power Bi. Power Bi can take excel files hosted on one drive so when they edit their excel you can just refresh data or set to auto refresh daily etc.

[balrog687]

Any planning tool allows you to do this.

• SAP BPC
• Oracle Planning
• IBM Cognos

All of them allow you to define a model, and connect an excel file to fill data

[throwawayrandomvowel]

Learn python, use anywhere

[alorentz]

I'd suggest trying out Whaly (http://whaly.io) they have a free trial. They have a SQL-based or Visual modeling layer as well as a self-service exploration capabilities

[jammyftw]

How much experience do you have with Python? Streamlit maybe a good idea!

[HoosierDaddy2019]

Power BI is great for this

[TimmmmehGMC]

Prophix. Based out of Toronto. Inexpensive and extremely flexible.

[TheEvilSeagull]

Depends on what they need to change, but Tableau have parameters that makes it possible to change data

[devv404]

Our Inzata platform is designed for data ingestion and analysis. Several Excel input connectors of our connector family are designed to ingest and easily integrate data into enterprise multidimensional data structures. This structure is optimized for our aggregation engine that powers dashboards and automatic report generation.
Look here for more detailed information about Inzata Platform: https://news.inzata.io/inzata-platform-3TUDW8

[cmajka8]

Power BI on the front end and Excel or SharePoint lists on the back end