This is an eCommerce dataset exploration project using SQL on Google BigQuery. The dataset is based on the Google Analytics public dataset and contains data from an eCommerce website.
- Google Cloud Platform account
- Google BigQuery API eneble
- SQL query editor or IDE
The Ecommerce dataset is stored in the public Google BigQuery dataset. Follow these steps to access the dataset on Google Big Query:
- Sign in to your Google Cloud Platform account and create a new project.
- Navigate to the BigQuery dashboard and select your newly created project.
- In the navigation panel, select "Add Data" and then select "Search Projects".
- Enter the project ID "bigquery-public-data.google_analytics_sample.ga_sessions" and click "Enter".
- Click on the table "ga_sessions_" to the dataset.
Use SQL in Google BigQuery against the Google Analytics data set to write and execute queries to find the desired data for the purpose of answering business questions