Smart analytics

Introduction to GCP

Nabeel Imam

Content Developer at DataCamp

Databases

  • Store structured data in tables
  • Provide easy access and editing

A person files a document in a filing cabinet.

GCP's Cloud SQL

Logo of Google Cloud SQL

Introduction to GCP

The global bank

A global financial network, showing different locations, each with their own currency, connected by a network on a map.

Introduction to GCP

The infinite database

Cloud Spanner

Logo of Cloud Spanner.

  • Unlimited scale
  • Supports multiple read write operations at the same time
Introduction to GCP

Analytic needs

How do we run analytics on big databases?

A person uses a tablet device to view analyses and visualizations while robotic arms place items on shelves in a warehouse.

  • Data warehouses collect, sort, and collate data
    • Get it ready for analysis
Introduction to GCP

Analytics in the warehouse

  • Centralized updates for fast, consistent analytics
  • Optimized for reading, complex queries; less suited for writing or data entry

A data warehouse is the central node in a network of financial institutions spread across the globe, all connected to each other.

Introduction to GCP

Analytics with GCP

BigQuery

Logo of Google BigQuery.

  • Fully managed serverless warehouse
  • Optimized for complex analytics
  • Scales up automatically

Looker

Logo of Google Looker.

  • Business Intelligence platform
  • Interactive visualizations and real-time analytics
  • Dashboards with BigQuery
Introduction to GCP

Data lakes

A person stores an important document in a bank locker.

  • Centralized store for structured, semi-structured, and unstructured data
Introduction to GCP

Data lakes

  • Offer high flexibility
    • Central repository for diverse data types
  • Handle petabytes from sources like social media
  • Enable big data analytics and machine learning

  • GCP Data Lake service: scalable, cost-effective solution for data from various sources

  • GCP BigLake: integrates BigQuery to data lakes

Introduction to GCP

Let's practice!

Introduction to GCP

Preparing Video For Download...