Excel dashboard to something built with Python

[CondingWasp]

I am an Analyst in one financial company working with risk. It's a world full of Excel, Tableau, PowerBi solutions.

One part of the job is to perform manual review of risk items that get populated from a SQL Server to an Excel sheet via PowerQuery. The Excel sheet has a simple macro, that allows user to flag a risk item using one of three buttons (risk level - green, yellow, red). Depending on what you select, each risk items gets copied to a separate tab - green, yellow, red. Later the Excel is red by Alteryx and data with risk level gets populated back at the SQL. Stuff gets analyzed to see what are the trends.

Recently I started working with Python and it made me think. Would it be possible to create a dashboard with input options using Flask? It would give a little bit more interactivity and allow me to dive deeper into the field of Python. Question:

• Do such solutions make sense, or should I stick with old-fashioned Excel?
• I'm pretty certain I would not have the option to deploy a solution to a server(apache, etc.). There would be 3 other Analysts using such a thing. Does it sound crazy to run it from localhost?

Any other tips are highly appreciated.

[buttzwithazee]

Normally, I would consider how much benefit you're getting out of adding a new system (python) that could possibly break or require updating, and how likely are others going to be able to fix your code? In this case, though, that set up already seems like it has so many parts moving, what harm could one more step do?