وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Data Analytics with Google Cloud BigQuery and Looker Studio

سرفصل های دوره

When you think about the best storytellers of the 21st century, you might not think… data? But data analytics play an increasingly large role in how we interpret what’s happening around us and is indispensable in solving real-world problems. In this course, learn how to use Google Cloud BigQuery and Looker Studio to tell your data analytics stories. Instructor Yoyu Li provides a step-by-step demonstration of solving a real-world data analytics challenge, looking at global temperature changes over nine decades. Yoyu shares a full view of the process of telling a story with data, starting from a problem statement. She shows you how to use public datasets in BigQuery, how to run SQL queries, how to add data sources, and visualize data in Looker Studio. Yoyu starts each chapter with a problem to solve, so you can immediately see the concepts in action as go you along.


01 - Introduction
  • 01 - Tell a story with data using Google Cloud BigQuery and Looker Studio
  • 02 - Who this course is for

  • 02 - 1. Visualizing BigQuery Data as Line Charts in Looker Studio
  • 01 - Introduction to Google Cloud BigQuery and Looker Studio
  • 02 - Using a public dataset in BigQuery
  • 03 - Running an SQL query in BigQuery
  • 04 - Aggregation functions in BigQuery
  • 05 - Aggregation across multiple tables in BigQuery
  • 06 - Creating a line chart in Looker Studio
  • 07 - Challenge Visualize global temperature changes using BigQuery and Looker Studio
  • 08 - Solution Visualize global temperature changes using BigQuery and Looker Studio

  • 03 - 2. Dimensions and Column Charts in Looker Studio
  • 01 - Joining two datasets in BigQuery
  • 02 - Dimensions in line charts and column charts
  • 03 - String functions in BigQuery
  • 04 - Updating an existing BigQuery data source in Looker Studio
  • 05 - Challenge Visualize temperature trends in selected countries in Looker Studio
  • 06 - Solution Visualize temperature trends in selected countries in Looker Studio

  • 04 - 3. Intermediate SQL Transformation and Geo Charts in Looker Studio
  • 01 - Creating a geo chart in Looker Studio
  • 02 - Anatomy of a complex SQL query
  • 03 - Challenge Comparing countries temperature changes in a geo chart
  • 04 - Solution Comparing countries temperature changes in a geo chart

  • 05 - Conclusion
  • 01 - Continue your data analytics journey
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 15866
    حجم: 166 مگابایت
    مدت زمان: 66 دقیقه
    تاریخ انتشار: 15 تیر 1402
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید