I used to do this in a spreadsheet for an old client. The spreadsheet combined two sources into a single flat table:
1. AWS resource list, tags and spend.
2. Datadog utilisation.
From this sheet a derivative sheet was created that had functionality on it, so that the data sheet could be regularly updated. The sheet was sorted in order of cost, and a cumulative sum totalled up all the spend. The column next to that gave a cumulative percentage of total spend so you could quickly see how spend was distributed.
There was a set of indicator columns at the end of table calculated by formula which show 0 or 1 dependent on whether the indicator applied. The indicators where things like:
1. Can down-grade instance.
2. Can kill instance.
3. Consider for contract.
4. Cheaper on Azure.
5. Can be on-demand.
6. Is unreliable.
etc.
As we thought of new things I'd add them to the spreadsheet. This was of working was very effective.
1. AWS resource list, tags and spend.
2. Datadog utilisation.
From this sheet a derivative sheet was created that had functionality on it, so that the data sheet could be regularly updated. The sheet was sorted in order of cost, and a cumulative sum totalled up all the spend. The column next to that gave a cumulative percentage of total spend so you could quickly see how spend was distributed.
There was a set of indicator columns at the end of table calculated by formula which show 0 or 1 dependent on whether the indicator applied. The indicators where things like:
1. Can down-grade instance.
2. Can kill instance.
3. Consider for contract.
4. Cheaper on Azure.
5. Can be on-demand.
6. Is unreliable.
etc.
As we thought of new things I'd add them to the spreadsheet. This was of working was very effective.