You're reading from FinOps Handbook for Microsoft Azure Empowering teams to optimize their Azure cloud spend with FinOps best practices

Product type Paperback

Published in May 2023

Publisher Packt

ISBN-13 9781801810166

Length 256 pages

Edition 1st Edition

Tools

Azure

Concepts

Cloud Computing

Author (1):

Maulik Soni

View More author details

Table of Contents (19) Chapters

Preface

1. Part 1: Inform

2. Chapter 1: Bringing Visibility and Allocating Cost FREE CHAPTER

3. Chapter 2: Benchmarking Current Spend and Establishing Budgets

4. Chapter 3: Forecasting the Future Spend

5. Chapter 4: Case Study – Beginning the Azure FinOps Journey

6. Part 2: Optimize

7. Chapter 5: Hitting the Goals for Usage Optimization

8. Chapter 6: Rate Optimization with Discounts and Reservations

9. Chapter 7: Leveraging Optimization Strategies

10. Chapter 8: Case Study - Realize Savings and Apply Optimizations

11. Part 3: Operate

12. Chapter 9: Building a FinOps Culture

13. Chapter 10: Allocating Costs for Containers

14. Chapter 11: Metric-Driven Cost Optimization

15. Chapter 12: Developing Metrics for Unit Economics

16. Chapter 13: Case Study – Implementing Metric-Driven Cost Optimization and Unit Economics

17. Index

Why subscribe?

18. Other Books You May Enjoy

Forecasting based on past usage

Cloud spend forecasting based on past usage is achieved by querying the usage data and using some form of forecasting algorithm to predict future spend. In our case, the data source will be SQL Server in which we ingested the past 12 months of usage data. For more details, please see the Getting your Azure usage data section. We will continue to use Power BI to query the data and create forecasts:

Open the Microsoft Power BI Desktop tool.
Under the Home tab in the top toolbar, select SQL. Then, select SQL Server and connect to your SQL server database where we have imported past usage data. Be sure to select Data Connectivity mode as DirectQuery: