Skip to content

Bitcoin Dashboard Project Details

Executive Summary

Create a dashboard with the latest Bitcoin price that updates each day.

Outline

Crypto Data Download provides historical Bitcoin price data. Use this data to power the dashboard.

Tools

  • Google Cloud Functions
  • Google Cloud Scheduler
  • Healthchecks.io
  • Google BigQuery
  • Google Data Studio

Languages

  • Python
  • SQL

High level operations

Collect and store the data in BigQuery using Google Cloud Functions

Schedule the Cloud Function to run each day using Google Cloud Scheduler.

Monitor the execution of the Cloud Functions by using Healthchecks.io

Build a Data Studio dashboard from the created view in BigQuery.

Transform the raw data uploaded into a more usable form by creating a view from the raw data.

Visualisation

Bitcoin dashboard in DataStudio.