REVISION: Core Data Analytics Vocabulary

Part 1. Pronunciation

Read the sentences aloud.

Pay special attention to today’s pronunciation:

• query (/kw/)
• execute (/ks/)
• syntax
• database
• dashboard
• extract

1. I need to execute a SQL query before the meeting.
2. The database contains customer information.
3. We found a syntax error in the SQL query.
4. The report shows several duplicate records.
5. I created a pivot table to analyse the sales data.
6. The dashboard updates automatically every morning.
7. We need to extract the data from another table.
8. Let’s append the new records to the existing table.
9. These insights will help the marketing team.
10. The data is stored on the main server.

Pair Work

Student A reads the sentences.

Student B listens carefully.

Correct your partner if you hear a pronunciation mistake.

Then switch roles.

Part 2. Vocabulary – spelling review

Part 3. Fill in the gaps

Complete the story using the words from the box. 

query • execute • syntax error • database • table • rows • columns • duplicate • pivot table • dashboard • extract • append • analysis • insights

Emma has just started working as a junior data analyst.

Her manager asks her to __________ a SQL __________ to retrieve sales information from the company __________.

When Emma runs the query, she gets a __________, so she carefully checks the code and fixes it.

The results appear in a __________ with twelve __________ and six __________.

Before starting the __________, Emma removes several __________ records.

Next, she creates a __________ to compare sales across different regions.

Finally, she __________ additional information from another file and __________ it to the existing dataset.

The finished report is published on the company __________, where managers can use the __________ to make better business decisions.

Part 4. Spot the mistake

Each sentence contains ONE mistake. Correct it.

1. The query were executed successfully.
2. I found a syntex error in the SQL query.
3. The database contain customer information.
4. We extracted the datas from the server.
5. This table has twelve row.
6. Every columns has a unique name.
7. We removed all duplicated records.
8. I created a pivote table yesterday.
9. Please append the new rows in the table.
10. The dashboard show the latest sales results.
11. The manager asked me make an analysis.
12. These insight helps us understand customer behaviour.

Part 5. Speaking Practice 

TASK 1

Imagine you’re a junior data analyst. You’re working on your first task. Answer the questions below.

• What data would you like to analyse?
• Where would the data come from?
• What kind of SQL query would you execute?
• What problems might you have?
• What would you put on your dashboard?

Try to use at least 5 words from today’s lesson.

TASK 2

You’re taking a Data Analytics course. Discuss the questions.

• Which topic have you enjoyed the most so far?
• Which topic has been the most difficult?
• Which tool do you want to learn next?
• What would you like to build by the end of the course?

Use at least 5 words from today’s vocabulary.