Reports

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

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

Primary data source

• Billing Data: Cost and usage data imported into the DoiT platform from your cloud service providers (AWS, Google Cloud, Microsoft Azure) or connected third-party platforms. Cloud billing data give you visibility into your cloud spend, allowing you to uncover cost and performance optimization opportunities.

• BigQuery Intelligence: DoiT BigQuery Intelligence maintains an audit log sink for BigQuery jobs. Reports that use this data source runs queries in the Google Cloud billing project of the Google Cloud account you have connected to DoiT Cloud Intelligence, and consumes that project’s BigQuery compute capacity (on-demand bytes or reservation slots). Performance and query cost depend on your audit log volume, selected time range, and filters.

• Kubernetes Utilization: CPU and memory utilization data of Kubernetes clusters. This option is available only if you have onboarded Kubernetes clusters to the Kubernetes Intelligence.

Supplementary data source

• DataHub data: Available if you choose Billing Data as the primary data source. 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.

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.

  • Amazon Web Services: See AWS cost data latency in DoiT console.

  • Azure: Microsoft Azure Cost Management exports are updated on a daily basis. See Cost and usage data updates and retention for how often Azure Cost Management receives usage data.

  • Google Cloud: See Google Cloud's frequency of data loads.

  We recommend considering metric amounts (Cost, Usage, etc) for a day as final after a three-day delay. Note that there is no SLA for data latency, and the data may change if corrections are applied.

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

Rounding of numbers

Cloud Analytics reports in the DoiT console round numbers to two decimal places, with each value rounded separately. While this is a standard way to present tabular data, it may occasionally lead to minor discrepancies between row or column totals and the sum of their cells.

To access unrounded values for full precision, export the data to CSV or Google Sheets, or use the Reports API to get report results.

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 use US and Canadian Pacific Time (UTC-8) and observe daylight saving time shifts in the United States.

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

• BigQuery Intelligence audit logs data use 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:

• Data points limits

• Data ingestion limits

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 billing data

To backfill AWS historical billing data, please open an expert inquiry.

For Google Cloud, see Import historical data(GCP).

For Microsoft Azure, see Backfill historical data.

Best practices

Learn about best practices that help you improve the accuracy and effectiveness when building reports.