CloudMonitorFinOps/reporting

Power BI Azure FinOps FOCUS Reports for CloudMonitor

About CloudMonitor

CloudMonitor is a revolutionary FinOps tool that enables companies to automate cost governance and proactively reduces cloud consumption and costs.
CloudMonitor consists of 4 seperate reporting areas:

1. FinOps - Monitor your cloud spend.
2. Microsoft 365 Analytics - Keep a centralised view of your 365 tenant and users (under development).
3. Security and Compliance - How well does your organisation adhere to cloud security best practices (under development).
4. Sustainability - What is your organisations cloud impact from an environmental sustainability and energy consumption perspective (under development).

The CloudMonitor reports are available in this GitHub repository as an open-source resource for you and your organisation to adapt to your specific requirements.

What is FinOps?

FinOps is an operational framework and cultural practice which maximizes the business value of cloud, enables timely data-driven decision making, and creates financial accountability through collaboration between engineering, finance, and business teams.

Learn more at: FinOps Foundation

Looking for CloudMonitor Enterprise?

Click the following link to visit the CloudMonitor website: CloudMonitor

How to connect the CloudMonitor Dataset and Reports

Example using the Power BI FinOps Reports for CloudMonitor.

1. Download the dataset file "CloudMonitor FinOps Dataset.pbix"
2. Download required report files e.g. "Executive Summary.pbix" or "Costs.pbix"

Connecting the Dataset in Power BI Service

1. Open the dataset file and publish it to your target workspace.
2. In Power BI Service, navigate to the recently published dataset file and go to the dataset settings.
   
3. Under the parameters section, enter the customer ID which was provided to you and apply.
   
   
4. Under the data source credentials section, click on edit credentials and enter the username and password provided to you.
   
   
5. Ensure that you have selected Organizational under the Privacy level settings.
6. Repeat steps 4-5 for the remaining datasource.

Connecting the Dataset in Power BI Desktop

1. Open the CloudMonitor FinOps Dataset.pbix file and in the top menu, select Edit Parameters under the Transform Data menu.
   
2. In the dialogue which opens, enter the customer ID which was provided to you and click OK.
   
3. From the options and settings menu in the file dialogue, select Data source settings.
   
4. In the window which pops up, select one of the datasources and click Edit Permissions.
   
5. In the next window, make sure that Organizational is selected for the Privacy Level.
   
6. Click on edit under the credentials section and in the following window select the Database option in the left hand menu and then enter the username and password which was provided to you.
   
7. Repeate steps 4-6 for the remaining datasource.
8. Once done you may close the datasource settings window.

Connecting the Report Files to the Dataset

Before connecting the report files, you must first publish the Dataset to a Power BI Workspace.

1. When you open a report file, you will see the following popup mentioning that the report could not connect to a dataset.
   
2. Click on edit, and from the next window select the dataset file which you published to the Power BI Service.
   
3. The report will now load and display the following detail in the lower right of the Power BI window, showing which dataset and workspace you have connected to.