Not knowing the exact situations, it’s hard to give any accurate suggestions.
I’d like to share some of my thoughts.
Google spreadsheet instead of Excel?
- Excel pros
- most people are familiar with it
- some basic data manipulations are easy (some difficult though)
- the download -> update -> upload and share process is stressful
- when someone made a edit mistake, it could be disastrous
- visualization is limited and not really easy to use
Since the data you use are manually inputted, I suppose data size is not big. Google spreadsheet might keep the pros and solve the cons. And redash do support using google spreadsheet (without using any SQL). So you could try the combination.
Is sql necessary?
It is for redash, but not quite so for some other tools, such as tableau, metabase, superset.
I personally think GUI based tools works well for small-sized dataset and simple need for visualization.
If Google Spreadsheet migration is not really applicable, I would expect your excel to be really nightmerish. The remain choice would be migration your main datasource to some db.
In this case, I believe both migration to db + BI tool and continually using excel would be painful. It depends on which pain you would prefer.
The former choice would pay off in the long run if
- the business or the data-driven planning need is growing
- you would like to have more experience and skills on the technical side
Hope this helps.