KPI & Dashboard Library

This page provides curated examples, formulas, and downloads for high-impact KPIs and dashboards used in Power BI, SQL, and MicroStrategy.

Financial KPIs

Average Revenue Per User - key for SaaS and subscription-based businesses.

Total marketing/sales cost divided by new customers acquired.

Estimates total revenue expected from a customer over their relationship.

Revenue minus cost of goods sold, expressed as a percentage.

Tracks subscription-based recurring revenue on a monthly basis.

Cumulative year-to-date sales totals segmented by geographic region.

Daily sales vs. sales on the same weekday of the previous year.

Recurring revenue lost due to cancellations or downgrades, expressed as a percentage of starting MRR.

Percentage of new users who complete a key activation step (e.g., first login, email verification, or first core action) within a set time window.

Percentage of customers lost over a given time period.

Customer loyalty metric based on likelihood to recommend.

Percentage of users in a signup cohort who remain active at specific time intervals (e.g., Day 1, Day 7, Day 30).

Measures how quickly issues are resolved after being reported.

Percentage of users who complete a desired goal or action.

Track AWS/Azure/GCP spend, anomalies, and reserved instance utilization with Power BI.

Visualize slowest queries, execution trends, and index usage by module or user.

Monitor dropoff across signup, email, install, and activation milestones.

Track pollution hotspots, AQI distributions, and city-level air quality using geospatial visuals and real-time data.

Don't see the KPI you need? Contact us and let us know!