GLASGOW|01- JUNE|Query Data in Google sheets with SQL

[Pretty548]

Coursework content

Querying Data in Google Sheets with AQL (=QUERY())

Estimated time in hours

2

What is the purpose of this assignment?

The purpose of this assignment is to teach trainees how to extract, analyze, and interpret data using Google Sheets. It focuses on using the QUERY() function in Sheets to filter and summarize large datasets. This is essential for data-driven decision-making, reporting, and performance evaluation in business environments.

Trainees Will Learn To:

Import and organize raw data into Google Sheets.

Use the =QUERY() function to analyze data with SQL-like statements.

Identify trends, filter relevant data, and calculate KPIs.

Make data-driven recommendations based on query results.

How to submit

1. Combine both of these sheets into one. You can create a new sheet for each piece of work.

2. Share a link to your Google Sheet on your own copy of this ticket. Make sure to give read access to your sheet, you can do this by clicking the “Share” button, then change “Restricted” to “Anyone with the link”.

Anything else?

No response