How can we create reports from devOps capability assessment for Audit?

Question

How can we generate and present reports from the DevOps Capability Assessment for audit and compliance purposes?
and
Do you also know how we can create cost management report from pricing calculator?

Answer 1

Hello Sakshi Bansal,

Thank you for reaching out to Microsoft Q&A

There's no inbuilt dashboard available in the DevOps Capability Assessment and Pricing Calculator, as a workaround you can export the assessment's CSV results and Pricing Calculator results as xlsx and import the same CSV/xlsx in Power BI and create a dashboard/report. in order to create dashboard/report via csv in Power BI, Refer this 2 Documents:

1. https://www.thebricks.com/resources/guide-how-to-create-power-bi-dashboard-from-csv-file
2. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report

You can also use Azure inbuilt tools for compliance and security:

1. Microsoft Defender for Cloud: Offers vulnerability assessments, compliance dashboards, and security alerts integrated with Azure Security Center. Helps meet frameworks like PCI DSS, SOC, and ISO.
2. Azure Monitor and Log Analytics: Captures audit events, maps to compliance standards (e.g., NIST AU-2, AU-3), and integrates with Security Center for policy enforcement.
3. Cost Management: You can directly get reports of your existing workload and the cost its consuming by visiting Cost Management. Refer: https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/reporting-get-started