Learn how to set up the required tables and data for use with Datalab.
- [Instructor] Let us go ahead…and set up BigQuery with some data…before we start using it in Datalab.…The exercise files folder contains…a website_visit_data.csv file.…We will first load that into BigQuery.…Let's go to the BigQuery console in GCP.…Here create a new dataset called EDA…under the current project.…
Now the dataset EDA is created.…Let us load the website_visit_data.csv file…into a new table called Website Visits.…We click on Create Table…and create table from an uploaded file.…We can now select the file website_visit_data,…open, file format is CSV.…Destination project is My First Project,…it is set as EDA…and the table type is native.…
The destination table name is website_visits.…We will select auto detect schema and input parameters…and then we click on Create Table.…The job is now running to create the table.…And the table is now created.…You can click on the table…to see the contents and the data.…
Next, we will similarly load the campaign_data.csv file…into a table called Campaigns.…We go back to the dataset,…
- Setting up Cloud DataLlb for exploratory data analytics
- Segmentation and profiling
- Reading and writing data from BigQuery
- Managing cloud storage buckets
- Creating visualizations of BigQuery data with the GCP Charting API
- Managing Datalab instances
Skill Level Intermediate
Predictive Customer Analyticswith Kumaran Ponnambalam1h 37m Intermediate
1. Exploration Options in GCP
2. Cloud Datalab Basics
3. Datalab: BigQuery
4. Datalab: Cloud Storage
5. Datalab: Visualizations
6. EDA with GCP: Use Case
7. Managing Datalab
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.