Skip to main content

Reports

Overview​

DoiT Cloud Analytics reports help you visualize and interpret data in your cloud environment. Whether you're monitoring cloud usage, tracking costs, or analyzing performance, Cloud Analytics reports enable you to identify trends and patterns and gain insights to make informed decisions.

Data source​

You can use Cloud Analytics reports to analyze data from the following sources:

  • Billing data of public clouds: Cost and usage data imported into the DoiT Platform from your cloud service providers (AWS, Google Cloud, or Microsoft Azure). Cloud billing data give you visibility into your cloud spend, allowing you to uncover cost and performance optimization opportunities for your organization.

  • Your own data ingested via DoiT DataHub: DoiT DataHub allows you to import data from various sources into DoiT Cloud Analytics. Together with cloud billing data, they provide a contextualized dataset for you to make informed decisions regarding resource allocation, spending, and overall business performance.

  • BigQuery activity data: DoiT BigQuery Lens maintains an audit log sink for BigQuery jobs. You can use data in the BigQuery Lens audit log sink for your own analysis.

When working with Cloud Analytics reports, keep in mind that the available options, including metrics and dimensions, vary with data source.

Data latency​

  • Billing data: Cloud Analytics refreshes billing data every hour. However, the freshness of the billing data itself is decided by the corresponding cloud service provider. See AWS cost data latency in DoiT console and Google Cloud's frequency of data loads. Microsoft Azure Cost Management data is updated on a daily basis.

    You can consider metric amounts (Cost, Usage, etc) for a day final after a three-day delay. Note that there is no SLA for data latency, and the data may change if there are corrections that need to be applied.

  • DataHub data: Data imported via the DataHub API will be available in Cloud Analytics within 15 minutes after a successful API call.

Time zone​

When importing data from cloud service providers, DoiT Platform keeps the original time zones of the data without adjustment.

  • Google Cloud billing data uses US and Canadian Pacific Time (UTC-8) and observes daylight saving time shifts in the United States.

  • AWS and Microsoft Azure billing data uses the Coordinated Universal Time (UTC).

  • BigQuery Lens audit logs data uses the Coordinated Universal Time (UTC).

Keeping the original time zones allows you to easily compare data presented in the DoiT Platform and data in cloud providers' native tools. If your organization adopts a multicloud strategy, be aware of the specific time zone applied to cost and usage data when using DoiT Platform for cost management. See Time zone in multicloud reports for more information.

Limitations​

Be aware of the following limitations when building or running reports:

See also​

Reports API​

DoiT Reports API is an easy-to-use RESTful API. It allows you to programmatically access Cloud Analytics reports and returns the latest reports data in JSON format. See Reports API for more information.

DataHub API​

DataHub API allows you to import data from internal and external sources into the DoiT Platform for contextualized analysis. See DataHub and DataHub API for more information.

Backfill historical data​

To backfill AWS historical billing data, please open a support ticket with us. For Google Cloud, see Import historical data(GCP). Microsoft Azure billing data is backfilled from January 1, 2023.

Last updated on