Intact Green Services Data Annotation Engineer Interview Questions and Answers for Experienced

Data entry involves inputting, updating, and maintaining information in a database or system.

• Inputting data accurately and efficiently

• Updating existing data with new information

• Maintaining data integrity and organization

• Using software tools like Microsoft Excel or Google Sheets

• Ensuring data security and confidentiality

• Example: Entering customer information into a CRM system

To extract data from a database, one can use SQL queries or programming languages like Python or R.

• Use SQL queries to extract data from a database

• Use programming languages like Python or R to extract data from a database

• Connect to the database using appropriate credentials

• Identify the tables and columns from which data needs to be extracted

• Write the query or code to extract the data

• Save the extracted data in a desired

Tableau has 14 datatypes including string, integer, float, date, boolean, and more.

• Tableau has 14 datatypes

• String, Integer, Float, Date, Boolean, and more

• Data types can be changed in Tableau

• Data types affect how data is displayed and aggregated

• Examples: String - 'John Smith', Integer - 25, Float - 3.14, Date - 01/01/2021, Boolean - True/False

Vlookup() is a function in Excel that can be used to copy records from one sheet to another based on a common identifier.

• The Vlookup() function searches for a value in the first column of a table array and returns a corresponding value in the same row from a specified column.

• The common identifier used in the Vlookup() function should be present in both the source and destination sheets.

• The Vlookup() function can be use...read more