Asset Library / FinOps Use Cases / Analyze marketplace vendors costs
FinOps Practitioners want to be able to answer the question: How much are we spending each month on vendor products that were purchased via a Cloud Service Provider’s marketplace?
SELECT ChargePeriodStart, ChargePeriodEnd, ProviderName, PublisherName, InvoiceIssuerName, ROUND(SUM(EffectiveCost),2) AS TotalEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? AND InvoiceIssuerName != PublisherName GROUP BY ChargePeriodStart, ChargePeriodEnd, ProviderName, PublisherName, InvoiceIssuerName ORDER BY TotalEffectiveCost ASC
Calculate percentage of normalized and queryable data in data warehouse, repository, or similar, vs Accounts Payable Invoice.
The main output of this capability is a data repository of normalized, queryable data from which reporting, analysis, and visualization of cloud cost and usage will occur. This KPI is about organizing the foundation for insights and making it accessible for cost-insight products.
Spend included in queryable data warehouse (or similar) / Total Cloud Spend
Data Sources:
Related Capabilities
This measures any one single user accessing any insight Cost Insight Products.
This can be any company-internal user experience where costs are surfaced to consumers: Analytic dashboards, reports, developer portal, etc. (Caveat: Users are not possible to track in company-external CSP Cost/Billing portals!)
Number = Raw count of Monthly Active User (MAU), or any one single user accessing any insight Cost Insight Products
Data Sources:
Related Capabilities
FinOps Practitioner
Reporting & Analytics 
Licensing & SaaS