Skip to content
Jordi Suñé edited this page Feb 6, 2023 · 4 revisions

Continuous Cloud Optimization Insights (CCO Insights)

Navigation



Overview

The Continuous Cloud Optimization Insights (CCO Insights) project is a set of Power BI Desktop Reports that enables monitoring, operation and infrastructure teams to quickly gain insights about their existing Azure Platform footprint, resources and code contribution characteristics on Azure DevOps and GitHub. CCO Insights is developed using Power Query M language and DAX that pulls information directly from different Azure REST API.

OverviewImage

CCO Insights currently includes 4 different dashboards to discover information about your Azure, Azure DevOps and GitHub cloud platforms:

  • Azure Infrastructure Dashboard: Get insights about Azure advisor optimizations, Azure Security Center Alerts, Networking, Compute, RBAC, Idle resources and Subscriptions Quotas and Limits
  • Azure Governance Dashboard: Get insights about Azure Governance aspects like Management Groups and Subscriptions hierarchy, resource tagging and naming standards, security controls, policies compliance, Regulatory Standards and Azure Blueprints
  • GitHub Contributions Dashboard: Get insights about the contributions to your GitHub project.
  • Azure DevOps Contributions Dashboard: Get insights about the contributions to your Azure DevOps (ADO) project.

This wiki includes a Deployment Guide for each dashboard (see the links above) that contains a detailed guidance on how to install and configure them, including the requirements, what REST APIs are in use, the resource providers that need to be enabled and what tabs are included as part of each dashboard by default.

The Troubleshooting Guide chapter contains guidance on how to solve potential issues that you might encounter during the dashboards' deployment. Errors like Power BI regional settings, or Privacy levels will be documented in this guide.


List of assets

  1. queries folder: Includes the M queries used in the Dashboard to pull data from Azure and Graph REST APIs. This content is for reference purposes to facilitate the Data Model comprehension and to enable contributors to expand the Dashboard capabilities.
  2. docs/assets/pictures folder: Contains all the images that the Dashboard will use when loading data from Azure. The content of this folder is dynamic and updated regularly. Make sure the computer running the Dashboard also has access to this URL via the internet.
  3. dashboards folder: This folder contains sub folders with different versions of the CCO Insights dashboards.
    • CCODashboard-Infra folder has a more generic version of the Dashboard that includes information from Azure Advisor, Azure Defender , Azure Networking REST APIs, Azure Compute and more REST and Graph APIs. This dashboard requires the installation of a custom connector.
    • CCODashboard-Governance folder has a dashboard aligned with the Microsoft Cloud Adoption Framework governance principles and will allow to get quick insights around Management Groups, Subscriptions, Blueprints, Polices, Naming Standards, Tagging and Regulatory Standards compliance. This dashboard requires the installation of a custom connector.
    • GitHub Contributions Dashboard folder: has a dashboard to get insights about the contributions to your GitHub project.
    • Azure DevOps Contributions Dashboard folder: has a dashboard to get insights about the contributions to your Azure DevOps (ADO) project.

CCO Insights Videos

To learn more about CCO Insights, see the informational videos on YouTube or by clicking on the thumbnails below.

Video0 Video1 Video2
Chapter 0 - Introduction Chapter 1 - Setup Power BI Desktop Chapter 2 - Governance Dashboard
Video3 Video4
Chapter 3 - Infrastructure Dashboard Chapter 4 - GitHub Dashboard

Reporting Issues

NOTE: If you're experiencing problems during the deployment of the dashboards, please check the Troubleshooting Guide and the Github closed issues before creating a new one.

Bugs

If you find any bugs, please file an issue on the GitHub Issues page by filling out the provided template with the appropriate information.

Please search the existing issues before filing new issues to avoid duplicates.

If you are taking the time to mention a problem, even a seemingly minor one, it is greatly appreciated, and a totally valid contribution to this project. Thank you!

Feature requests

If there is a feature you would like to see in here, please file an issue or feature request on the GitHub Issues page to provide direct feedback.



Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.



Learn More