Let's say I have a room of computers that I want to show how each is utilized, and I have separate text documents that shows monthly user counts, and for each cpu what software was launched on each. I'd love to show a graph of usage over time and what was used to determine future software / hardware needs based on trends.
What is the best way to collect this data in one place and visualize it? Is there any tools that automate this process easily? Excel manual data entry and graphs is what I'm working with and thinking there has to be a better way.
Any recs would be appreciated.