eClerx Data Analyst Interview Questions, Process, and Tips

Good maths English communication

Q1. Myself and aptitude
Add your answer
Q2. Myself and location
Add your answer
Q3. Last company and roles
Add your answer
Q4. Education and background
Add your answer
Q5. Hobbies and hobbies
Add your answer

Q1. Why excel is used for data analyst?
Ans. 
Excel is used for data analysis due to its user-friendly interface, powerful data manipulation capabilities, and ability to create visualizations.
• Excel allows for easy data entry and manipulation, making it accessible for users of all skill levels.

• It has powerful functions and formulas for data analysis, such as VLOOKUP, SUMIF, and PivotTables.

• Excel can create visualizations like charts and graphs to help analyze and p...read more
Answered by AI
Add your answer

Q1. Tell me about yourself?
Add your answer

Q1. Sql based questions
Add your answer
Q2. Pivot table in excel
Ans. 
A pivot table in Excel is a powerful tool for summarizing and analyzing data.
• Pivot tables allow you to reorganize and summarize selected columns and rows of data in a spreadsheet.

• You can easily group data, calculate totals, averages, and other statistics, and create custom calculations.

• Pivot tables are dynamic and can be easily updated as the source data changes.

• They are useful for analyzing large datasets and identify...read more
Answered by AI
Add your answer

Q1. What is DML in SQL ?
Ans. 
DML stands for Data Manipulation Language in SQL, used for managing data in a database.
• DML is used for inserting, updating, deleting, and retrieving data from a database.

• Common DML commands include INSERT, UPDATE, DELETE, and SELECT.

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2);
Answered by AI
Add your answer
Q2. How you perform exists query in SQL?
Ans. 
To perform an exists query in SQL, use the EXISTS keyword followed by a subquery that returns at least one row.
• Use the EXISTS keyword in the WHERE clause of the main query

• Follow the EXISTS keyword with a subquery that returns at least one row

• The EXISTS query will return true if the subquery returns any rows, otherwise false
Answered by AI
Add your answer
Q3. What is lookup in excel?
Ans. 
Lookup in Excel is a function that searches for a value in a range and returns a corresponding value in the same position from another range.
• Lookup function helps in finding specific information in a table or range of data.

• Common lookup functions in Excel include VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP.

• Example: =VLOOKUP(A2, B:C, 2, FALSE) - this formula searches for the value in cell A2 in the first column of range ...read more
Answered by AI
Add your answer
Q4. Explain DCL in sql ?
Ans. 
DCL stands for Data Control Language in SQL, used to control access to data stored in a database.
• DCL commands include GRANT and REVOKE, which are used to give or revoke permissions on database objects.

• GRANT command is used to give specific privileges to a user or role.

• REVOKE command is used to take back privileges that were granted with the GRANT command.
Answered by AI
Add your answer

Basic aptitude question from Quants, Reasoning only, no English comprehension was asked to me.

Q1. The post for which I was shortlisted was Product Data Management Analyst and required a Bachelor's Degree in Electrical/Electronics/Mechanical. Questions were mainly asked on Electrical circuits and compo...read more
Add your answer

Q1. SQL table prepare, SQL commands, Claus in SQL, swap two no code in python,
Add your answer
Q2. Logical reasoning que
Add your answer
Q3. Mostly SQL que which is adding any random row in table
Add your answer