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.