DataStudio Basics Google Professional Data Engineer GCP

  1. Home
  2. DataStudio Basics Google Professional Data Engineer GCP
  • It turns data into dashboards and reports
  • Output is informative, easy to read, easy to share, and fully customizable.
  • Has drag and drop report editor
  • Offers charts as line, bar, and pie charts, geo maps, area and bubble graphs,
  • Provides paginated data tables, pivot tables, and more.
  • Make interactive reports with viewer filters and date range controls.
  • Include links and clickable images
  • Has dimension for xaxis and metrics for yaxis
  • does not allow aggregations on metrics
  • Filter controls give viewers a way to focus on subsets of the data.
  • Caching types – query cache, pre-fetch cache.
    • Query cache cannot be turned off.
    • Pre-fetch cache can be turned off and is valid only for owner’s credentials for data access.
  • Can create new fields using formulas or functions and add them to charts.
  • Annotate and brand reports with text and images.
  • Apply styles and color themes
  • To view a Data Studio report, a browser and an internet connection is needed.
  • To create or edit a file in Data Studio, you must:
  • be signed into a Google account
  • be in one of the supported countries

Connect to data

Connect to data sets as

  • Google Marketing Platform products, including Google Ads, Analytics, Display & Video 360, Search Ads 360
  • Google consumer products, such as Sheets, YouTube, and Search Console
  • Databases, including BigQuery, MySQL, and PostgreSQL
  • Flat files via CSV file upload and Google Cloud Storage
  • Social media platforms such as Facebook, Reddit, and Twitter

Share and collaborate

  • easy to share with individuals, teams, or the world.
  • Invite others to view or edit reports
  • With sharing can work together in real time as a team.


Data Studio Community Visualizations

  • It allows to build and use own custom visualizations
  • Flexibility to use any visualization library and custom JavaScript and CSS.
  • define style elements
  • Use event driven model to posts data and style information
  • Data and style options are defined in a config JSON.
  • The data configuration sets the number of dimensions and metrics the visualization supports. The style configuration defines style selectors in property panel.
  • The interaction configuration defines how chart interactions work for a community visualization. This is optional.

Writing the visualization code:

  • Data Studio helper library is the interface between you and Data Studio.
  • To use the library, provide a callback function that renders the visualization.



  • To load a community visualization, all of resources must be publicly available in a Google Cloud Storage bucket.
  • Create a bucket and upload files using either the web interface or the gsutil.