Gemini for Data Scientists and Analysts

In this lab, you are a data analyst who will use Gemini and BigQuery to analyze data and predict product sales as part of a proof of concept project at Cymbal Superstore. As part of the project, you will also determine if Gemini can be used to help analysts generate new SQL queries, complete queries, and explain complex queries.

 

위와 같은 설정으로 dataset을 생성한다.

 

이후 Genmini를 실행해보았다. 

 

Gemini can help you work with SQL. For instance, if you work with SQL queries that other people wrote, Gemini in BigQuery can explain a complex query in plain language. Such explanations can help you understand the query syntax, underlying schema, and business context.

이런 식으로 sql 쿼리에 대해서도 설명을 요구하면 제공한다.

 

You can provide Gemini with a prompt to generate a SQL query based on your data's schema. Even if you're starting with no code, a limited knowledge of the data schema, or only a basic knowledge of SQL syntax, Gemini can suggest one or more SQL statements.

In this task, you generate a query that lists your top products for each day. This type of query is often complex, but you can automatically create a statement using Gemini. You then use tables in the thelook_ecommerce dataset and prompt Gemini to generate a query to calculate sales by order item and by product name.

 

 

자연어로 어떤 sql문을 작성할 지 입력하면 아래와 같이 sql 문을 작성해준다.