I'm looking to track some company KPIs, we've been using excel which has all the drawbacks you'd expect.<p>I thought there'd be some tool which for example stores the data in a SQL db, has a secruity model like RBAC, provides both a frontend and APIs so that data can be updated both manually and programmatically, along with being able to be queried by reporting endpoints etc<p>I'm guessing this is a common "We've outgrown the simplest thing that just works" solution and my google fu is failing me
sounds like a standard BI platform. I'd reach for Google Data Studio, others like PowerBI.<p>No need to re-invent the wheel with your own DB.<p><a href="https://www.reddit.com/r/PowerBI/comments/s3o6hi/the_most_indepth_comparison_of_bi_tools_followup/" rel="nofollow">https://www.reddit.com/r/PowerBI/comments/s3o6hi/the_most_in...</a>
I'm not techie by any means so I read the question as an "ease of access for multiple parties without vendor lock-in" issue. I would want the front-end views to customizable based on roles, access levels or whatever and it seems to me (I plan on using this myself) that the best answer is Cube.<p>See HN post:<a href="https://news.ycombinator.com/item?id=31493118" rel="nofollow">https://news.ycombinator.com/item?id=31493118</a>
What is the input data of these kpis?<p>If it is people entering data then excel or gsheets.<p>If it is a database then a few sql queries and data studio or even a custom dashboard with plotly or so would work (if you have developers on the team and protected pages slready).