{"id":20257,"date":"2024-03-15T12:51:27","date_gmt":"2024-03-15T12:51:27","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&#038;p=20257"},"modified":"2026-05-13T11:40:33","modified_gmt":"2026-05-13T11:40:33","slug":"from-data-to-insights-with-google-cloud","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/from-data-to-insights-with-google-cloud","title":{"rendered":"From Data to Insights with Google Cloud"},"content":{"rendered":"<p><span class=\"TextRun SCXW109528716 BCX8\" lang=\"EN-IN\" xml:lang=\"EN-IN\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW109528716 BCX8\">Unleash the power of data insights at scale with Google Cloud. This one-day <\/span><span class=\"NormalTextRun SCXW109528716 BCX8\">boot <\/span><span class=\"NormalTextRun SCXW109528716 BCX8\">camp takes you on a journey from raw data to actionable insights, <\/span><span class=\"NormalTextRun SCXW109528716 BCX8\">leveraging<\/span><span class=\"NormalTextRun SCXW109528716 BCX8\"> the power of <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW109528716 BCX8\">BigQuery<\/span><span class=\"NormalTextRun SCXW109528716 BCX8\">, Google Cloud&#8217;s serverless, highly scalable, and cost-effective cloud data warehouse. Master the techniques to transform vast datasets into actionable insights and drive impactful decisions for your business<\/span><span class=\"NormalTextRun SCXW109528716 BCX8\">.<\/span><\/span><span class=\"EOP SCXW109528716 BCX8\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unleash the power of data insights at scale with Google Cloud. This one-day boot camp takes you on a journey from raw data to actionable insights, leveraging the power of BigQuery, Google Cloud&#8217;s serverless, highly scalable, and cost-effective cloud data warehouse. Master the techniques to transform vast datasets into actionable insights and drive impactful decisions [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":12394,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["20258"],"_edit_lock":["1778672305:5091"],"_edit_last":["5091"],"permalink_customizer":["google-cloud-certification\/from-data-to-insights-with-google-cloud"],"permalink_customizer_regenerate_status":["1"],"_thumbnail_id":["12394"],"_wp_page_template":["default"],"price":["29900"],"wpdocs-meta-bdt":["38999"],"wpdocs-meta-gbp":["999"],"wpdocs-meta-usd":["1199"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"_yoast_wpseo_wordproof_timestamp":[""],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Get your hands dirty with data and become an insights powerhouse. This immersive one-day bootcamp plunges you into the world of BigQuery, Google Cloud's serverless data warehouse.\u202f  "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["From Data to Insights with Google Cloud Course Overview:"],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["From Data to Insights with Google Cloud- What You'll Learn:  "],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course":["4"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features of the course From Data to Insights with Google Cloud:  "],"_key_features_heading":["field_645388ceffdd1"],"key_features":["6"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who Should Attend this Course, \"From Data to Insights with Google Cloud\": "],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend":["1"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["What are the prerequisites for the training?"],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["<ul>To get the most out of this course, participants should have: <\/ul>\r\n\r\n<li>Basic familiarity with SQL. <\/li>"],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why choose CloudThat as a \"From Data to Insights with Google Cloud \" training partner?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["8"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification details:"],"_certification_heading":["field_64538bffffdd5"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Modules covered in the training program "],"_course_outline_heading":["field_64538a8effdd4"],"course_section":["14"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":[""],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["2741"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["6.5"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":[""],"_faq_heading":["field_64538c59ffdd8"],"curriculum":[""],"featured":[""],"views":["1209"],"level":["intermediate"],"current_students":["0"],"duration_info":["3 Days"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"Who should attend this course? \",\"answer\":\"Data analysts, \\n\\nBusiness analysts, \\n\\nBusiness intelligence professionals, \\n\\nMarketing analysts and anyone wanting to turn data into actionable insights using Google Cloud. \"},{\"question\":\"What are the prerequisites? \",\"answer\":\"Basic familiarity with SQL. \"},{\"question\":\"What will I learn in the \\\"From Data to Insights with Google Cloud\\\" course? \",\"answer\":\"Write high-quality SQL queries for BigQuery. \\n\\nTake advantage of BigQuery's query cache for efficient data analysis. \\n\\nLink data across multiple tables using JOINs and other techniques. \\n\\nUse window functions to aggregate data efficiently. \\n\\nClean and transform data using Cloud Dataprep. \\n\\nCreate compelling data visualizations with Google Data Studio. \\n\\nStore and ingest new datasets into BigQuery. \\n\\nDesign effective and scalable schemas for BigQuery. \\n\\nOptimize queries for performance and cost. \\n\\nControl access with data security best practices. \\n\\nPredict future outcomes using BigQuery Machine Learning. \"},{\"question\":\"Is this a hands-on course? \",\"answer\":\"This course features extensive hands-on labs and exercises in every module, allowing you to gain practical experience working with BigQuery and other Google Cloud tools. \"},{\"question\":\"What makes CloudThat a good choice for this training? \",\"answer\":\"We are Google Cloud Platform Authorized Trainers, ensuring you receive the most up-to-date and relevant information. \\n\\nOur instructors are industry-recognized experts with real-world experience. \\n\\nWe emphasize hands-on learning through labs, projects, and case studies. \\n\\nWe offer customized learning paths for different skill levels. \\n\\nOur courses are interactive and engaging, keeping you motivated and engaged. \\nWe provide placement assistance and career support resources. \\n\\nOur course content regularly reflects the latest trends and best practices. \\n\\nWe have positive reviews and testimonials from satisfied learners. \"},{\"question\":\"How can I register for this course? \",\"answer\":\"Please visit our website or contact us directly to inquire about registration options and upcoming course dates for career advancement. \"},{\"question\":\"What tools and technologies will be covered in the course? \",\"answer\":\"This course dives deep into Google Cloud's BigQuery, a serverless, highly scalable, and cost-effective cloud data warehouse. You'll master the art of querying, analyzing, and visualizing vast datasets using BigQuery's powerful features. Additionally, you'll explore other valuable tools like: \\n\\nCloud Dataprep: Effortlessly clean and transform your data for seamless analysis. \\n\\nGoogle Data Studio: Craft compelling data visualizations to communicate insights effectively. \\n\\nBigQuery ML: Leverage the power of machine learning to predict future outcomes and make data-driven decisions. \\n\\nCloud Storage: Securely store and manage your data within the Google Cloud Platform. \\n\\nCloud SQL: Access and manage relational databases seamlessly in the cloud. \"},{\"question\":\"What is the course schedule and format? \",\"answer\":\"The \\\"From Data to Insights with Google Cloud\\\" bootcamp is a one-day intensive program designed to maximize your learning quickly. The format is highly interactive and hands-on, featuring: \\n\\nLive instructor-led sessions: Experienced GCP professionals guide you through the course material and answer your questions in real time. \\n\\nInteractive lab exercises: Apply your theoretical knowledge to practical scenarios, solidifying your understanding and building confidence. \\n\\nCase studies and real-world examples: Learn from how other organizations leverage BigQuery and GCP to solve data challenges. \\n\\nGroup discussions and collaborative learning: Share your insights and perspectives with fellow learners to gain diverse viewpoints. \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"after_completing_course_0_desciption":["Create high-quality SQL queries. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Take advantage of BigQuery's query cache. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Link data across multiple tables. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Use window functions to efficiently aggregate data. "],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["Our Google Cloud Platform training modules have 50% - 60% hands-on lab sessions to encourage Thinking-Based Learning (TBL)."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning (PBL)."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["GCP-certified instructor-led training and mentoring sessions to develop Competency-Based Learning (CBL)."],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Well-structured use cases to simulate challenges encountered in a Real-World environment during Google Cloud Platform training."],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Integrated teaching assistance and support through an experts-designed Learning Management System (LMS) and ExamReady platform."],"_key_features_4_lists":["field_6103ad559f5b3"],"key_features_5_lists":["Being an official Google Cloud Platform Training Partner, we offer authored curricula aligned with industry standards."],"_key_features_5_lists":["field_6103ad559f5b3"],"who_should_attend_0_attend_lists":["Data analysts, business analysts, business intelligence professionals. "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"course_features_0_features_list_0_list":["Specialized GCP Focus: CloudThat specializes in cloud technologies, offering focused and specialized training programs. We are Authorized Trainers for the Google Cloud Platform. This specialization ensures in-depth coverage of GCP services, use cases, best practices, and hands-on experience explicitly tailored for GCP."],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Industry-Recognized Trainers: CloudThat has a strong pool of industry-recognized trainers certified by GCP. These trainers bring real-world experience and practical insights into the training sessions, comprehensively understanding how GCP is applied in different industries and scenarios."],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Hands-On Learning Approach: CloudThat emphasizes a hands-on learning approach. Learners can access practical labs, real-world projects, and case studies that simulate actual GCP environments. This approach allows learners to apply theoretical knowledge in practical scenarios, enhancing their understanding and skill set."],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["Customized Learning Paths: CloudThat understands that learners have different levels of expertise and varied learning objectives. We offer customized learning paths, catering to beginners, intermediate learners, and professionals seeking advanced GCP skills."],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["Interactive Learning Experience: CloudThat's training programs are designed to be interactive and engaging. We utilize various teaching methodologies like live sessions, group discussions, quizzes, and mentorship to keep learners engaged and motivated throughout the course."],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_0_features_list_5_list":["Placement Assistance and Career Support: CloudThat often provides placement assistance and career support services. This includes resume building, interview preparation, and connecting learners with job opportunities through our network of industry partners and companies looking for GCP-certified professionals."],"_course_features_0_features_list_5_list":["field_644a0fc80e680"],"course_features_0_features_list_6_list":["Continuous Learning and Updates: CloudThat ensures that our course content is regularly updated to reflect the latest trends, updates, and best practices within the GCP ecosystem. This commitment to keeping the content current enables learners to stay ahead in their GCP knowledge."],"_course_features_0_features_list_6_list":["field_644a0fc80e680"],"course_features_0_features_list_7_list":["Positive Reviews and Testimonials: Reviews and testimonials from past learners can strongly indicate the quality of training provided. You can Check feedback and reviews about our GCP courses that can provide potential learners with insights into the effectiveness and value of the training."],"_course_features_0_features_list_7_list":["field_644a0fc80e680"],"course_features_1_heading":["Learning objective of the course:"],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["Write efficient SQL queries, explore public datasets, and easily analyze large datasets."],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Clean and manipulate data using Cloud Dataprep to prepare it for analysis and visualization."],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Use Google Data Studio to communicate insights clearly and effectively."],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Understand BigQuery storage options and structure your data for optimal performance."],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_4_list":["Secure your data warehouse and control access with confidence."],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_features_1_features_list_5_list":["Predict future outcomes and make data-driven decisions using BigQuery ML."],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"course_features_1_features_list_6_list":["Enhance your career prospects with valuable skills and knowledge recognized by the industry."],"_course_features_1_features_list_6_list":["field_644a0fc80e680"],"course_features_1_features_list_7_list":["Develop critical thinking and analytical abilities to tackle complex data challenges."],"_course_features_1_features_list_7_list":["field_644a0fc80e680"],"course_features_1_features_list_8_list":["Become more comfortable and proficient in leveraging data for real-world business solutions."],"_course_features_1_features_list_8_list":["field_644a0fc80e680"],"course_features_1_features_list":["9"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":[""],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["17714"],"_certification_0_image":["field_6103ab5b2822e"],"course_section_0_module_title":["Intro to Google Cloud Platform "],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":["Topics:"],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Highlight Analytics Challenges Faced by Data Analysts "],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Compare Big Data On-Premises vs on the Cloud "],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud "],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["Navigate Google Cloud Platform Project Basics "],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["4"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["1"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Analyzing Large Datasets with BigQuery "],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Topics:"],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools "],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Demo: Analyze 10 Billion Records with Google BigQuery "],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Explore 9 Fundamental Google BigQuery Features "],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_3_lession_title":["Compare GCP Tools for Analysts, Data Scientists, and Data Engineers "],"_course_section_1_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["4"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Activities: "],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Lab: BigQuery Basics "],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["1"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["2"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Exploring your Public Dataset with SQL "],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":["Topics: "],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Compare Common Data Exploration Techniques "],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Learn How to Code High Quality Standard SQL "],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Explore Google BigQuery Public Datasets "],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_3_lession_title":["Visualization Preview: Google Data Studio "],"_course_section_2_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["4"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section_1_title":["Activities: "],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Lab: Explore your Ecommerce Dataset with SQL in Google BigQuery "],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["1"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["2"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Cleaning and Transforming your Data with Cloud Dataprep "],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":["Topics:"],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Examine the 5 Principles of Dataset Integrity "],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Characterize Dataset Shape and Skew "],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Clean and Transform Data using SQL "],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Clean and Transform Data using a new UI: Introducing Cloud Dataprep "],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["4"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Activities: "],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Lab: Creating a Data Transformation Pipeline with Cloud Dataprep "],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["1"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["2"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["Visualizing Insights and Creating Scheduled Queries "],"_course_section_4_module_title":["field_612f5535940c3"],"course_section_4_module_description":[""],"_course_section_4_module_description":["field_612f564c921af"],"course_section_4_section_0_title":["Topics: "],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["Overview of Data Visualization Principles "],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["Exploratory vs Explanatory Analysis Approaches "],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_2_lession_title":["Demo: Google Data Studio UI "],"_course_section_4_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_3_lession_title":["Connect Google Data Studio to Google BigQuery "],"_course_section_4_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["4"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section_1_title":["Activities: "],"_course_section_4_section_1_title":["field_612f5233b0278"],"course_section_4_section_1_lesson_list_0_lession_title":["Lab: How to Build a BI Dashboard Using Google Data Studio and BigQuery "],"_course_section_4_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list":["1"],"_course_section_4_section_1_lesson_list":["field_612f530a0ac40"],"course_section_4_section":["2"],"_course_section_4_section":["field_612f51e6b0277"],"course_section_5_module_title":["Storing and Ingesting new Datasets "],"_course_section_5_module_title":["field_612f5535940c3"],"course_section_5_module_description":[""],"_course_section_5_module_description":["field_612f564c921af"],"course_section_5_section_0_title":["Topics: "],"_course_section_5_section_0_title":["field_612f5233b0278"],"course_section_5_section_0_lesson_list_0_lession_title":["Compare Permanent vs Temporary Tables "],"_course_section_5_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_1_lession_title":["Save and Export Query Results "],"_course_section_5_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_2_lession_title":["Performance Preview: Query Cache "],"_course_section_5_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list":["3"],"_course_section_5_section_0_lesson_list":["field_612f530a0ac40"],"course_section_5_section_1_title":["Activities: "],"_course_section_5_section_1_title":["field_612f5233b0278"],"course_section_5_section_1_lesson_list_0_lession_title":["Lab: Ingesting New Datasets into BigQuery"],"_course_section_5_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_1_lesson_list":["1"],"_course_section_5_section_1_lesson_list":["field_612f530a0ac40"],"course_section_5_section":["2"],"_course_section_5_section":["field_612f51e6b0277"],"course_section_6_module_title":["Enriching your Data Warehouse with JOINs "],"_course_section_6_module_title":["field_612f5535940c3"],"course_section_6_module_description":[""],"_course_section_6_module_description":["field_612f564c921af"],"course_section_6_section_0_title":["Topics:  "],"_course_section_6_section_0_title":["field_612f5233b0278"],"course_section_6_section_0_lesson_list_0_lession_title":["Merge Historical Data Tables with UNION "],"_course_section_6_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_1_lession_title":["Introduce Table Wildcards for Easy Merges "],"_course_section_6_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_2_lession_title":["Review Data Schemas: Linking Data Across Multiple Tables "],"_course_section_6_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_3_lession_title":["Walkthrough JOIN Examples and Pitfalls "],"_course_section_6_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list":["4"],"_course_section_6_section_0_lesson_list":["field_612f530a0ac40"],"course_section_6_section_1_title":["Activities: "],"_course_section_6_section_1_title":["field_612f5233b0278"],"course_section_6_section_1_lesson_list_0_lession_title":["Lab: Troubleshooting and Solving Data Join Pitfalls "],"_course_section_6_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_1_lesson_list":["1"],"_course_section_6_section_1_lesson_list":["field_612f530a0ac40"],"course_section_6_section":["2"],"_course_section_6_section":["field_612f51e6b0277"],"course_section_7_module_title":["Partitioning your Queries and Tables for Advanced Insights "],"_course_section_7_module_title":["field_612f5535940c3"],"course_section_7_module_description":[""],"_course_section_7_module_description":["field_612f564c921af"],"course_section_7_section_0_title":["Topics: "],"_course_section_7_section_0_title":["field_612f5233b0278"],"course_section_7_section_0_lesson_list_0_lession_title":["Review SQL Case Statements "],"_course_section_7_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_1_lession_title":["Introduce Analytical Window Functions "],"_course_section_7_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_2_lession_title":["Safeguard Data with One-Way Field Encryption "],"_course_section_7_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_3_lession_title":["Discuss Effective Sub-query and CTE design "],"_course_section_7_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_4_lession_title":["Compare SQL and Javascript UDFs "],"_course_section_7_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list":["5"],"_course_section_7_section_0_lesson_list":["field_612f530a0ac40"],"course_section_7_section_1_title":["Activities: "],"_course_section_7_section_1_title":["field_612f5233b0278"],"course_section_7_section_1_lesson_list_0_lession_title":["Lab: Creating Date-Partitioned Tables in BigQuery "],"_course_section_7_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_7_section_1_lesson_list":["1"],"_course_section_7_section_1_lesson_list":["field_612f530a0ac40"],"course_section_7_section":["2"],"_course_section_7_section":["field_612f51e6b0277"],"course_section_8_module_title":["Designing Schemas that Scale: Arrays and Structs in BigQuery  "],"_course_section_8_module_title":["field_612f5535940c3"],"course_section_8_module_description":[""],"_course_section_8_module_description":["field_612f564c921af"],"course_section_8_section_0_title":["Topics: "],"_course_section_8_section_0_title":["field_612f5233b0278"],"course_section_8_section_0_lesson_list_0_lession_title":["Compare Google BigQuery vs Traditional RDBMS Data Architecture "],"_course_section_8_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_8_section_0_lesson_list_1_lession_title":["Normalization vs Denormalization: Performance Tradeoffs "],"_course_section_8_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_8_section_0_lesson_list_2_lession_title":["Schema Review: The Good, The Bad, and The Ugly "],"_course_section_8_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_8_section_0_lesson_list_3_lession_title":["Arrays and Nested Data in Google BigQuery "],"_course_section_8_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_8_section_0_lesson_list":["4"],"_course_section_8_section_0_lesson_list":["field_612f530a0ac40"],"course_section_8_section_1_title":["Activities: "],"_course_section_8_section_1_title":["field_612f5233b0278"],"course_section_8_section_1_lesson_list_0_lession_title":["Lab: Querying Nested and Repeated Data "],"_course_section_8_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_8_section_1_lesson_list_1_lession_title":["Lab: Schema Design for Performance: Arrays and Structs in BigQuery "],"_course_section_8_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_8_section_1_lesson_list":["2"],"_course_section_8_section_1_lesson_list":["field_612f530a0ac40"],"course_section_8_section":["2"],"_course_section_8_section":["field_612f51e6b0277"],"course_section_9_module_title":["Optimizing Queries for Performance"],"_course_section_9_module_title":["field_612f5535940c3"],"course_section_9_module_description":[""],"_course_section_9_module_description":["field_612f564c921af"],"course_section_9_section_0_title":["Topics: "],"_course_section_9_section_0_title":["field_612f5233b0278"],"course_section_9_section_0_lesson_list_0_lession_title":["Walkthrough of a BigQuery Job "],"_course_section_9_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_9_section_0_lesson_list_1_lession_title":["Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs "],"_course_section_9_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_9_section_0_lesson_list_2_lession_title":["Optimize Queries for Cost "],"_course_section_9_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_9_section_0_lesson_list":["3"],"_course_section_9_section_0_lesson_list":["field_612f530a0ac40"],"course_section_9_section":["1"],"_course_section_9_section":["field_612f51e6b0277"],"course_section_10_module_title":["Controlling Access with Data Security Best Practices "],"_course_section_10_module_title":["field_612f5535940c3"],"course_section_10_module_description":[""],"_course_section_10_module_description":["field_612f564c921af"],"course_section_10_section_0_title":["Topics: "],"_course_section_10_section_0_title":["field_612f5233b0278"],"course_section_10_section_0_lesson_list_0_lession_title":["Data Security Best Practices "],"_course_section_10_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_10_section_0_lesson_list_1_lession_title":["Controlling Access with Authorized Views "],"_course_section_10_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_10_section_0_lesson_list":["2"],"_course_section_10_section_0_lesson_list":["field_612f530a0ac40"],"course_section_10_section":["1"],"_course_section_10_section":["field_612f51e6b0277"],"course_section_11_module_title":["Predicting Visitor Return Purchases with BigQuery ML "],"_course_section_11_module_title":["field_612f5535940c3"],"course_section_11_module_description":[""],"_course_section_11_module_description":["field_612f564c921af"],"course_section_11_section_0_title":["Topics: "],"_course_section_11_section_0_title":["field_612f5233b0278"],"course_section_11_section_0_lesson_list_0_lession_title":["Intro to ML "],"_course_section_11_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_11_section_0_lesson_list_1_lession_title":["Feature Selection "],"_course_section_11_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_11_section_0_lesson_list_2_lession_title":["Model Types "],"_course_section_11_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_11_section_0_lesson_list_3_lession_title":["Machine Learning in BigQuery "],"_course_section_11_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_11_section_0_lesson_list":["4"],"_course_section_11_section_0_lesson_list":["field_612f530a0ac40"],"course_section_11_section_1_title":["Activities: "],"_course_section_11_section_1_title":["field_612f5233b0278"],"course_section_11_section_1_lesson_list_0_lession_title":["Lab: Predict Visitor Purchases with a Classification Model with BigQuery ML "],"_course_section_11_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_11_section_1_lesson_list":["1"],"_course_section_11_section_1_lesson_list":["field_612f530a0ac40"],"course_section_11_section":["2"],"_course_section_11_section":["field_612f51e6b0277"],"course_section_12_module_title":["Predicting Visitor Return Purchases with BigQuery ML "],"_course_section_12_module_title":["field_612f5535940c3"],"course_section_12_module_description":[""],"_course_section_12_module_description":["field_612f564c921af"],"course_section_12_section_0_title":["Topics: "],"_course_section_12_section_0_title":["field_612f5233b0278"],"course_section_12_section_0_lesson_list_0_lession_title":["Structured vs Unstructured ML "],"_course_section_12_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_12_section_0_lesson_list_1_lession_title":["Prebuilt ML models "],"_course_section_12_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_12_section_0_lesson_list":["2"],"_course_section_12_section_0_lesson_list":["field_612f530a0ac40"],"course_section_12_section_1_title":["Activities: "],"_course_section_12_section_1_title":["field_612f5233b0278"],"course_section_12_section_1_lesson_list_0_lession_title":["Lab: Extract, Analyze, and Translate Text from Images with the Cloud ML APIs "],"_course_section_12_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_12_section_1_lesson_list_1_lession_title":["Lab: Training with Pre-built ML Models using Cloud Vision API and AutoML "],"_course_section_12_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_12_section_1_lesson_list":["2"],"_course_section_12_section_1_lesson_list":["field_612f530a0ac40"],"course_section_12_section":["2"],"_course_section_12_section":["field_612f51e6b0277"],"course_section_13_module_title":["Completion "],"_course_section_13_module_title":["field_612f5535940c3"],"course_section_13_module_description":[""],"_course_section_13_module_description":["field_612f564c921af"],"course_section_13_section_0_title":["Topics:"],"_course_section_13_section_0_title":["field_612f5233b0278"],"course_section_13_section_0_lesson_list_0_lession_title":["Summary and course wrap-up "],"_course_section_13_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_13_section_0_lesson_list":["1"],"_course_section_13_section_0_lesson_list":["field_612f530a0ac40"],"course_section_13_section":["1"],"_course_section_13_section":["field_612f51e6b0277"],"sale_price_dates_start":[""],"sale_price_dates_end":[""],"_wp_old_date":["2024-03-14"],"_yoast_wpseo_title":["Unleash Data Analytics with Google Cloud - CloudThat"],"_yoast_wpseo_metadesc":["Unleash the power of your data! Master Google Cloud Platform to transform raw data into actionable insights. Learn data extraction, analysis, and visualization for informed decision-making."],"_regular_price_wmcp":["{\"USD\":\"1199\",\"GBP\":\"999\",\"BDT\":\"38999\"}"],"_yoast_wpseo_content_score":["90"],"wpdocs-meta-rand":["1399"],"wpdocs-meta-aed":["2099"],"offline_price":[""],"offline-bdt":[""],"offline-gbp":[""],"offline-rand":[""],"offline-aed":[""],"offline-usd":[""]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/20257"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":1,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/20257\/revisions"}],"predecessor-version":[{"id":28523,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/20257\/revisions\/28523"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/12394"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=20257"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=20257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}