Eloelo Data Analyst Interview Questions and Answers for Freshers

SQL, excel, tableau , looker studio

Q1. What is your notice period.
Add your answer

Q1. Difference between Drop and Truncate ?
Ans. 
Drop deletes the table structure and data, while truncate only deletes the data.
• Drop is a DDL (Data Definition Language) command, while truncate is a DML (Data Manipulation Language) command.

• Drop removes the table from the database, while truncate only removes the rows from the table.

• Drop is slower and requires more permissions than truncate.

• Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
Answered by AI
Add your answer
Q2. To write SQL queries
Add your answer

Q1. Why you are switching to non-core?
Ans. 
I am switching to non-core because I want to explore new opportunities and challenges outside of my current field.
• Seeking new challenges and opportunities

• Exploring different industries and roles

• Developing new skills and gaining diverse experience
Answered by AI
Add your answer
Q2. What are your expected salary?
Ans. 
I am looking for a competitive salary that reflects my skills and experience in the data analysis field.
• Research the average salary for Data Analysts in your area to have a realistic expectation

• Consider your level of experience, education, and any specialized skills you bring to the table

• Be prepared to negotiate based on the company's budget and benefits package
Answered by AI
Add your answer

Was asked about a case study regarding cost and profit, interviewer was observing my logical thinking and approach towards the problem.
Basically they'll check if you are covering all aspects or not.

SQL easy to medium level

Q1. Medium level SQL question
Add your answer
Q2. Case study on Bigbasket/Instagram
Add your answer

Prepare basics such as group by, case functions, aggregation and some theoretical part such as sequence of sql query execution, basic concepts of dbms

Case study on analytics side like think like a product analyst and define metrics for a feature for example feature that count your daily steps.

Q1. Culture related Queries
Add your answer
Q2. Salary expectations and negotiation deal
Add your answer

A Google Form-based Aptitude Test with Basic Questions

Q1. Asked Basic Time Complexity and DSA Questions like Time Complexity Of quick sort use of stack Data Structure etc
Add your answer

It was the final round asked to do a medium-level coding Question to convert a number such as 244 to word i.e Two Hundred and Forty four

Q1. What is lazyloading
Ans. 
Lazy loading is a design pattern commonly used in software development to defer the loading of non-essential resources until they are actually needed.
• Lazy loading helps improve performance by only loading resources when they are required.

• It is commonly used in web development to load images, videos, or other content as the user scrolls down a page.

• Lazy loading can also be used in database queries to fetch data only whe
Answered by AI
Add your answer
Q2. What is difference between angularJS and angular 2
Ans. 
AngularJS is the first version of Angular, while Angular 2 is a complete rewrite with improved performance and features.
• AngularJS is based on JavaScript, while Angular 2 is based on TypeScript.

• AngularJS uses controllers and $scope for data binding, while Angular 2 uses components and directives.

• AngularJS has two-way data binding, while Angular 2 has one-way data binding.

• AngularJS has a digest cycle for change detection...read more
Answered by AI
Add your answer

Q1. Puzzle asked from CEO
Add your answer

Q1. Why would you like to join us
Add your answer
Q2. Why would u like to join us
Add your answer