HACKER Q&A
📣 Tarks

What would you use to track and update a small companies KPIs?


I'm looking to track some company KPIs, we've been using excel which has all the drawbacks you'd expect.

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

I'm guessing this is a common "We've outgrown the simplest thing that just works" solution and my google fu is failing me

  👤 anotherhue Accepted Answer ✓
sounds like a standard BI platform. I'd reach for Google Data Studio, others like PowerBI.

No need to re-invent the wheel with your own DB.

https://www.reddit.com/r/PowerBI/comments/s3o6hi/the_most_in...

👤 Irongirl1
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.

See HN post:https://news.ycombinator.com/item?id=31493118

👤 mejutoco
What is the input data of these kpis?

If it is people entering data then excel or gsheets.

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).

👤 markus_zhang
If it's a small company I still feel Excel/Google sheet is OKish. How many KPIs and how many teams are we talking here?