finops-intelligence

name	finops_intelligence
description	Comprehensive FinOps analysis combining cost optimization, waste identification, and chargeback reporting. Use when asked about reducing Azure spend, finding unused resources, cost per team, chargeback, showback, or cost anomalies.

FinOps Intelligence

Purpose

Unified cost intelligence skill that identifies savings opportunities, tracks cost trends, and generates chargeback/showback reports by team or project.

Procedure

Step 1: Cost trend overview

az costmanagement query --type ActualCost --timeframe MonthToDate \
  --scope "subscriptions/<sub-id>" \
  --dataset-aggregation '{"totalCost":{"name":"Cost","function":"Sum"}}' \
  --dataset-grouping name="ServiceName" type="Dimension" -o table

Summarize: total spend this month vs. last month (% change), top 5 services by spend, spending anomalies (day-over-day spikes > 20%).

Step 2: Orphaned resources (waste)

Check	Command
Unattached disks	az disk list --query "[?managedBy==null]"
Unused public IPs	az network public-ip list --query "[?ipConfiguration==null]"
Stopped-but-allocated VMs	az vm list -d --query "[?powerState=='VM deallocated']"
Unused App Service plans	az appservice plan list --query "[?numberOfSites==0]"

Step 3: Rightsizing

Identify VMs with < 5% avg CPU (14 days), App Service plans with < 20% utilization, databases with < 20% DTU/vCore. Calculate current vs. recommended SKU cost.