Understanding Your Google Cloud Costs - Cloud

Setting Up Your Google Cloud Billing Account


  • Organizing Your Google Cloud Resources
    • Resources Hierarchy
    • Structure
  • Managing Billing Accounts
    • Navigation menu > Billing > Manage Billing Account
  • Managing Billing Access Permissions
  • Google Cloud Resource Management
    • Navigation menu > IAM & Admin > Manage resources
  • Tracking and Understanding Your Google Cloud Costs
    • Understanding Your Google Cloud Invoice
    • Exploring Your Google Cloud Costs with Billing Reports
  • Exporting your Billing Data and Creating Custom Dashboards

Understanding and Analyzing Your Costs with Google Cloud Billing Reports


  • Theory
    • Google Cloud cost management tools provide greater visibility, accountability, control, and intelligence so that you can scale your business in the cloud with confidence
    • Google Cloud Billing reports is a cost management tool that provides built-in reporting within the Cloud Console
  • How much am I spending?
    • The chart
    • Filters and grouping
  • What are my cost trends?
    • View your cost trend over a specified time period
    • View your cost trend by location
    • View your cost trend by credits
  • What are my cost drivers?
    • Find the unexpected cost increase
  • How can I see a summary of my costs?
    • Click Cost breakdown in the left panel

Analyzing Billing Data with BigQuery


  • Theory
    • BigQuery is Google's serverless, highly scalable enterprise data warehouse that is designed to make data analysts more productive with unmatched price-performance
  • Locate your dataset and table in BigQuery
    • Navigation menu > BigQuery
  • Examine the billing data
    • Schema, Details, and Preview
  • Analyze data using SQL queries
    • EDITOR

Visualizing Billing Data with Google Data Studio


  • Theory
    • Google Data Studio allows you to unlock the power of your data with interactive dashboards and beautiful reports that inspire smarter business decisions
    • With Data Studio, you can
      • Connect: easily access a wide variety of data. With built in and partner connectors, you can connect to virtually any type of data stream
      • Visualize: turn your data into compelling stories of data visualization art. You can quickly build dashboards with Data Studio's web-based reporting tools
      • Share: share your reports and dashboards with individuals, teams, or the world
  • Export your data to BigQuery
  • Explore your billing data in BigQuery
  • Visualize in Data Studio
    • Link
    • Create > Explorer > Add Data > Add > BigQuery
    • Custom Query

Examining BigQuery Billing Data in Google Sheets


  • Theory
    • BigQuery helps users deal with large datasets using high speed compute power
    • Sheets
      • Sheets is a collaborative, smart, secure spreadsheets application for fast-moving organizations
    • Sheets data connector
      • Sheets data connector dynamically connects Sheets to BigQuery
    • Refresh your data
    • Control access
  • Open Sheets and connect to BigQuery
    • Google Sheet
    • Plus Sign > Data > Data connectors > Connect to BigQuery > Get Connected
  • Write Query
  • Organize and analyze your spreadsheet
  • Analyze your data
  • Pivot table
  • Schedule a refresh of your data
    • Record a macro to refresh your data
    • Extensions > Macros > Record Macro
    • Schedule your macro
  • Change who can see and edit queries and results
Share: