Reporting and other activities

I have recently been playing with a range of different reporting tools and applications to see whether I can use them for work. We currently have a spreadsheet that allows staff to input monthly stats (Youtube views, gate counts, resource usage, student enquiries, etc.) and I have created seperate tabs that aggregate the data into quarterly summaries. These summaries also contain formulas that compare current quarter vs previous quarter, same quarter last year, and also has a difference percentage (colour coded to show negative as red, positive as green).
This spreadsheet has grown over time and is starting to get a bit bloated. I have in the past created MS Access databases for similar purposes but I find that most of the staff here are not familiar with Access and they have been met with mixed results. Ideally I want to store the data in a database but make it simple for people to upload monthly stats and I want to display the data in reports and dashboards. It needs to be secure so that only staff have access to the data/reports/dashboards but at the same time, user friendly so that staff can easily enter data, edit data and be able to add comments regarding issues or special events.

In addition to a whole bunch of commercial tools that cost a various amount of money (I feel like a business case/proposal will need to be created soon), I have also been looking at some cheaper alternatives such as Google charts, R Studio, MongoDB. I have also in the past played with Flourish/Canva for a data storytelling course I did but this is aimed more at infographics than business dashboards. Below is a dashboard created using MongoDB Atlas using dummy 'movie' data. I don't mind the NoSQL structure and the use of JSON to store records - my experience is more in line with SQL and normalisation to ensure tables are created from duplicated data but I can see the appeal of NoSQL. I like being able to do analysis and generating reports via the app (and embedding them into web pages - such as below) but I think I would need to move to a paid plan for some of the features I am after (such as authentication).

The whole concept of hosting a dashboard also sent me down a rabbit hole looking at Django, Flask and some other web frameworks for building websites. I also started looking at creating subdomains - only the tip of the iceberg at this point, still soooo much to learn and I admit that the use of netlify and 11ty have made this site relatively easy to build and manage - don't have to worry much about anything other than static content. I would like to create something using Django or Flask (leaning more towards Django at this stage even though it seems to be the more involved of the two) so I have a steep learning curve ahead but looking forward to learning more about it and strengthening my Python skills while I'm at it!