[Power BI] Anomaly management report

[flanakin]

📝 Scenario

As a FinOps practitioner, I need to detect and respond to anomalies in order to minimize unexpected charges

💎 Solution

Create an Anomaly management report that includes the following KPIs:

• [ ] # anomalies per month
  • Formula: Total number of anomaly alerts "ON" per month (count of alerts generated by an anomaly detection system)
  • Assumption: each anomalies detect an unexpected or unforecasted cloud cost events in a timely manner deviating from the initial budget. Anomaly detection identified cost increases in an attempt to avoid surprise charges when the monthly bill arrives.
  • Objective: To measure the number of unpredictable variation events in the actual consumption that are detected by the system or the FinOps team
  • Value: This metric provides valuable insights into the effectiveness of the anomaly detection system and the organization's ability to proactively identify and address potential issues. It serves as an important tool for maintaining operational awareness and making informed decisions about resource allocation and system improvements.
  • (Consistently) High alert count: indicate that the anomaly detection is vigilant and identifying potential issues regularly. It is crucial to review each alert's significance and prioritize investigations based on potential impact.
  • (Consistently) Low alert count: suggests that the systems are operating within expected norms, which can be a positive sign. However, it's important to ensure that the system is not overlooking anomalies (review the anomaly detection criteria) and improve sensitivity.
• [ ] Dismissed anomalies
  • Formula: Total anomalies dismissed over the total anomalies alerted per month
  • Objective: To measure the percentage of Anomalies for which, having been flagged by the System, it has been decided that corrective measures should not be taken.
  • Value: The metric provides valuable insights into how effectively the organization is responding to anomaly alerts. It serves as an indicator of operational efficiency and risk mitigation efforts, helping to prioritize improvements in the anomaly detection and resolution processes. With this KPI we obtain information about the efficiency of the deviation alert system.
  • Low Ratio: suggests that you are effectively resolving most anomaly alerts. The company should continue to focus on proactive anomaly management, but also monitor trends to ensure that resolution rates remain high.
  • High Ratio: indicates that a substantial number of anomaly alerts are not being addressed. The company should investigate the reasons behind this, which may include resource constraints, inefficient processes, or a high volume of false positives.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

[jamelachahbar]

HI @flanakin Are we looking at a simple way to detect anomalies in powerbi using DAX measures, calculated columns, or are we looking to explore machine learning algorithms as well for this?