9_Cloud Datastudio

Question 1

Business Intelligence

Business Intelligence (BI) is a set of methodologies, processes, architectures and technologies that transform raw data into meaningful and useful information.

3 key component:

• Reporting
  
  • Detailes set of charts, tables and graphs
  • Used for detailes analysis
• Analytics
• Dashboards
  
  • View at a high-level
  • Key Performance Indicators (KPIs)
  • Understand progress at a glance

Question 2

What is Data Studio

• Easy to use data visualization and dashboards:
  
  • Drag and drop report builder
• Part of G Suite, not Google Cloud:
  
  • Uses G Suite access/sharing permissions, not Google Cloud (no IAM)
  • Google account permissions in GCP will determine data source access
  • Files saved in Google Drive
• Connect to many Google Cloud and other services:
  
  • BigQuery, Cloud SQL, GCS, Spanner
  • YouTube Analytics, Sheets, AdWords, local upload
  • Many third party integrations
• Price: Free
  
  • BigQuery access run normal query costs.

Question 3

Basic Process

• Connect to data source
• Visualize data
• Share with others

Creating charts:

• Use combination of dimensions and metrics
• Create custom fields if needed
• Add date range filters with ease

Question 4

Caching

• Query cache
  
  • Remembers queries issued by reports components (i.e. charts)
  • When performing same query, pulls from cache
  • If query cache cannot help, go to prefetch cache
  • Cannot be turned off
• Prefetch cache
  
  • ‘Smart cache’: predicts what ‘might’ be requested
  • If prefetch cache cannot serve data, pulls from live data set
  • Only active for data sources that use owner’s credentials for data access
  • Can be turned off
• When to turn caching off:
  
  • Need to view ‘fresh data’ from rapidly changing data set