Edelweiss Data Analyst Interview Questions and Answers

Q1. He asked me mainly sql questions
Add your answer
Q2. After sql , he asked tableau questions
Add your answer

Q1. NANANANANANANANA
Add your answer
Q2. NANANANANANANANANA
Add your answer

Q1. NANANANAANANANA
Add your answer
Q2. NANANANANANANANANANA
Add your answer

Q1. What is Index ?
Ans. 
An index is a data structure that improves the speed of data retrieval operations on a database table.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on one or more columns of a table to speed up query processing.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer
Q2. What is RE Index ?
Ans. 
RE Index is a measure used in statistics to compare the relative importance of different variables in a regression model.
• RE Index stands for Relative Importance Index.

• It is used to determine the contribution of each independent variable to the overall variance explained by the regression model.

• A higher RE Index value indicates a greater importance of the variable in predicting the dependent variable.

• RE Index values ran...read more
Answered by AI
Add your answer
Q3. What is PE Ratio ?
Ans. 
PE Ratio is a financial metric used to evaluate a company's stock price relative to its earnings.
• PE Ratio is calculated by dividing the current stock price by the earnings per share (EPS).

• It is used by investors to determine if a stock is overvalued or undervalued.

• A high PE Ratio may indicate that a stock is overvalued, while a low PE Ratio may suggest it is undervalued.

• For example, if a company's stock is trading at $...read more
Answered by AI
Add your answer

Q1. About role in which you apply
Add your answer
Q2. About skills related to job
Add your answer

Q1. Explain Data types in SQL?
Ans. 
Data types in SQL define the type of data that can be stored in a column of a table.
• Data types include integer, float, text, date, boolean, etc.

• Each data type has specific properties and constraints.

• Examples: INT for integers, VARCHAR for variable-length character strings.
Answered by AI
Add your answer
Q2. Explain the difference between DBMS and RDBMS?
Ans. 
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
• DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS e...read more
Answered by AI
Add your answer

Hackerrank test medium difficulty

Presenting the case study which was given as a take-home assignment

Q1. What is account receivables
Ans. 
Account receivables refer to the money owed to a company by its customers for goods or services provided on credit.
• Account receivables are assets on a company's balance sheet.

• They represent the amount of money owed to the company by customers.

• Companies often have terms for when payments are due, such as net 30 or net 60.

• Monitoring and managing account receivables is important for cash flow management.

• Example: Company A...read more
Answered by AI
Add your answer

It contained python coding questions as well as machine learning questions

Q1. Sql joins, python codes
Add your answer
Q2. Complete codes and correct erros
Add your answer
Q3. Machine learning
Add your answer

Case study related to my project and background and internship