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.
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.