Data Analytics Workspace: Vocabulário em Inglês

Exercício: Data Analytics Workspace

Descreva a imagem abaixo. Confira a seção Vocabulário Útil se você precisar de ajuda.

Um profissional de dados trabalhando em sua mesa com um laptop mostrando gráficos e código SQL.

Vocabulário Útil

dataset Substantivo

Definição: a collection of data.

Exemplo: We used a customer dataset to build the report.

table Substantivo

Definição: a structured set of data in rows and columns.

Exemplo: The orders table has 10 columns.

column Substantivo

Definição: a vertical field in a table.

Exemplo: The price column is a decimal number.

query Substantivo / Verbo

Definição: a request for data (often written in SQL).

Exemplo: I ran a query to find last month’s sales.

SQL Substantivo

Definição: a language for working with relational databases.

Exemplo: She writes SQL every day to prepare reports.

pipeline Substantivo

Definição: a sequence of steps to move and transform data.

Exemplo: Our pipeline loads raw data and cleans it nightly.

ETL Substantivo

Definição: Extract, Transform, Load: a classic data-integration process.

Exemplo: The ETL job extracts CSV files, transforms them, and loads a warehouse table.

data warehouse Substantivo

Definição: a central database for analytics.

Exemplo: The dashboards read from our data warehouse.

dashboard Substantivo

Definição: a screen with charts and KPIs.

Exemplo: The marketing dashboard shows daily sign-ups.

KPI Substantivo

Definição: Key Performance Indicator: a key number that shows performance.

Exemplo: Our main KPI is monthly active users.

notebook Substantivo

Definição: an interactive document for code and analysis (e.g., Jupyter).

Exemplo: I tested the model in a notebook before production.

metric Substantivo

Definição: a measured value used to track performance.

Exemplo: Conversion rate is an important metric.

join Substantivo / Verbo

Definição: combine rows from two tables using a related key.

Exemplo: We joined orders with customers by customer_id.

null Adjetivo / Substantivo

Definição: a missing value in a table.

Exemplo: Some phone_number fields are null.

deploy Verbo

Definição: release a change to production.

Exemplo: We will deploy the new pipeline tonight.

Perguntas para Discussão

1️⃣ What data tools do you use most at work?

I use SQL and a BI tool to build dashboards.

2️⃣ What KPI is most important for your team? Why?

Monthly revenue is key because it shows business growth.

3️⃣ How often do you run your data pipeline?

It runs every night at 2 a.m.

4️⃣ Do you prefer working in notebooks or writing scripts?

I prefer notebooks for exploration and scripts for production.

5️⃣ What was the last query you wrote?

I filtered sales by region and date to check a drop in LATAM.

6️⃣ Have you ever fixed a broken pipeline? What happened?

Yes. A schema change caused errors; I updated the mapping and reran the job.

7️⃣ How do you handle null or missing values?

I drop them when safe or fill them with a default value.

8️⃣ What metric do you check first in the morning?

I check daily active users to see product health.

9️⃣ Do you use a data warehouse? Which one?

Yes, we use BigQuery/Redshift/Snowflake for analytics.

🔟 How do you make a dashboard easy to read?

I keep few charts, clear labels, and focus on 3–5 KPIs.

Atividade: Complete com o Vocabulário Técnico

Use as palavras que você aprendeu (como dashboard, query, pipeline, etc.) para completar as frases abaixo.

1To extract specific data from the database, you need to write a.

2The manager checks the salesevery morning.

3We need to fix the databecause the report is empty.

4This table has avalue in the email column.

5We store all historical data in our data.

6You shouldthe users table with the orders table.

7Conversion rate is our most importantright now.

8He is writing code in a Jupyter.

9We are ready tothe new model to production.

10Thiscontains information about 50,000 customers.