Analyze Data Trends with BigQuery and Create Dashboards with Looker

INTERMEDIATE
120 minutes
5 tasks

In this lab, you will use Google BigQuery to analyze datasets and identify trends and patterns. Then, you will visualize this data by creating dashboards in Looker based on specific business requirements. Throughout the lab, you will gain hands-on experience with SQL query construction, data visualization, and design principles for business reporting.

Scenario

You are a data analyst at a retail company tasked with analyzing the past year's sales data to identify seasonal trends. The company's management wants to use this data to make informed inventory decisions and improve sales strategies. Your task is to query the sales data using BigQuery to uncover trends and then create visual dashboards in Looker to present these findings.

Learning Objectives

  • Execute SQL queries in BigQuery to analyze sales data.
  • Create and customize dashboards in Looker for data visualization.
  • Identify seasonal trends from retail sales data.

tasks (5)

task 1: Import sales data into BigQuery

30 min

task 2: Execute SQL queries to analyze data

20 min

task 3: Create visual dashboards in Looker

30 min

task 4: Evaluate and summarize insights for presentation

20 min

task 5: Deploy and manage permissions for Looker dashboards

20 min

Prerequisites

  • Basic understanding of SQL and data analysis.
  • Familiarity with data visualization techniques.

Skills Tested

Using BigQuery to execute SQL queries and analyze data.Creating visualizations and dashboards in Looker.Managing dataset permissions and sharing insights.

References

    Analyze Data Trends with BigQuery and Create Dashboards with Looker - Hands-On Lab - CertiPass