11、Serverless Architecture: Financial Management and Security Insights

Serverless Architecture: Financial Management and Security Insights

1. AWS Pricing and Cost Estimation

AWS provides a pricing API to query the latest service prices. However, this API isn’t open - access; it requires AWS credentials. To integrate it with Excel:
1. Develop a microservice that interacts with the API. This microservice should retrieve only relevant metrics and format them for easy consumption.
2. Set up an API Gateway so that Excel can interact with the microservice.
3. Use the From Web Power Query feature in Excel to integrate live service pricing into the AWS service pricing tab of estimate spreadsheets.

This setup ensures that the spreadsheets always have the latest pricing information.

2. Cost Management in S