Accelerating AI adoption for global enterprises

DXHero combines cutting-edge AI technologies with a world-class engineering team to accelerate enterprise AI transformation. From strategy and consulting to implementation, enablement, and ongoing support, we deliver end-to-end services that help organizations adopt advanced tools quickly and achieve scalable, reliable results.

「Nico Chen」的個人頭像

By Vishal Bulbule.Jan 12, 2023

1

Introduction

This article will show how we can create looker dashboard to analyse google cloud billing for each resources,projects etc.

Google Cloud Billing Export

In organization based project it is difficult to provide access to billing details for larger audience but still based on requirement we should have option to provide billing data to different team for analysis or for business.

Cloud Billing export to BigQuery enables you to export detailed Google Cloud billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset that you specify. Then you can access your Cloud Billing data from BigQuery for detailed analysis, or use a tool like Looker Studio to visualize your data.

Enable billing export to bigquery from Billing >> Billing Export tab

2

Verify data is being loaded into BigQuery dataset and tables.

Article Create Looker dashboard for Google cloud billing insight 3

Execute Sample Queries in BigQuery

Article Create Looker dashboard for Google cloud billing insight 4

Now Open Looker Studio > Blank report

Article Create Looker dashboard for Google cloud billing insight 5

Select BigQuery as datasource

Article Create Looker dashboard for Google cloud billing insight 6

Select correct project > Dataset > Table where billing data is exported

Article Create Looker dashboard for Google cloud billing insight 7

Create dashboard as per requirement including table,charts bar etc.

Article Create Looker dashboard for Google cloud billing insight 8

Publish your Dashboards.

Refer below Video for Demo


The original article published on Medium.

Tagged in :

「Nico Chen」的個人頭像

More Articles & Posts