Steps

• enable api

Costs

Very transparent with the cost - before going into a paid service will show you the cost at the side

• BI-engine
  • $30.36 monthly estimate
  • Total capacity1 GBRate$0.0416 per GB/hour ($30.36 per GB/month)Reservation cost$30.36/month

Pros

• 25 projects free

• can vizualise from aws redshift

• more chart types compared to aws

  • Chart types

• accepts excel type

• so much easier to share the dashboard

  • aws has a lot of access issues

• very budget friendly

  • have steps to ensure that you do not get charged for tutorial
  • https://cloud.google.com/bigquery/docs/bi-engine-data-studio?hl=en

  Quickstart using Data Studio | BigQuery | Google Cloud

Cons

• requires different services to upload the files and another to display the data — aka 2 apis or services to enable
• everytime you create a proj with a service you need to select location again - ie unlike aws where its just N.virginia
• stricter with the data input