I need some help.
We have a set of metric data feeding from a spreadsheet, but need some sort of GUI so the end users can easily add/update the data. It's not just managing the spreadsheet, but also making sure it's modeled a certain way so it can feed into the dashboard and the users didn't really understand that. Things like having a unique ID for each metric, so when they made changes month to month, they would give two metrics the same number so the data would be off.
Anywho, back in the day I would have whipped up a Microsoft access form LOL, but I'm pretty sure that's not the latest technology? Any better suggestions?
I was paired to work with one of the software developers on my team, but I could tell by the meeting he was about to over complicate this. I feel I should just gather resources and create a solution on my own
We have a set of metric data feeding from a spreadsheet, but need some sort of GUI so the end users can easily add/update the data. It's not just managing the spreadsheet, but also making sure it's modeled a certain way so it can feed into the dashboard and the users didn't really understand that. Things like having a unique ID for each metric, so when they made changes month to month, they would give two metrics the same number so the data would be off.
Anywho, back in the day I would have whipped up a Microsoft access form LOL, but I'm pretty sure that's not the latest technology? Any better suggestions?
I was paired to work with one of the software developers on my team, but I could tell by the meeting he was about to over complicate this. I feel I should just gather resources and create a solution on my own