DeepR Analytics Data Analyst Interview Questions and Answers

Technology making ours less human ( 15 min) online

Q1. Tell me about yourself
Add your answer
Q2. Tell me about you inters hip
Add your answer
Q3. Fixed assets with example
Ans. 
Fixed assets are long-term tangible assets that are used in the production of goods or services and are not intended for sale.
• Fixed assets are physical assets such as buildings, machinery, equipment, vehicles, and land.

• They are not intended for sale and are used for the production of goods or services over a long period of time.

• Examples of fixed assets include manufacturing plants, office buildings, delivery trucks, an
Answered by AI
Add your answer
Q4. Capital assets with example
Ans. 
Capital assets are long-term assets that are used in the production of goods or services and are not easily converted into cash.
• Capital assets are typically tangible assets such as buildings, machinery, equipment, and vehicles.

• They are used by a company to generate revenue over an extended period of time.

• Examples of capital assets include manufacturing plants, delivery trucks, office furniture, and computer systems.
Answered by AI
Add your answer
Q5. Why we use current ration
Ans. 
Current ratio is used to assess a company's ability to pay its short-term obligations with its short-term assets.
• Current ratio is a liquidity ratio that measures a company's ability to cover its short-term liabilities with its short-term assets.

• It is calculated by dividing current assets by current liabilities.

• A current ratio of 1 or higher is generally considered healthy, as it indicates that a company has enough curr...read more
Answered by AI
Add your answer

Q1. Python string is changable or not
Ans. 
Python strings are immutable, meaning they cannot be changed once created.
• Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

• For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

• To modify a string in Python, you would need to create a new string with the desired changes.
Answered by AI
Add your answer
Q2. Sql window function ?
Add your answer
Q3. Difference between having and where cause
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after the GROUP BY clause, WHERE is applied before

• HAVING can only be used with SELECT statement that contains a GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY depar...read more
Answered by AI
Add your answer
Q4. Sql union and union all
Add your answer
Q5. Python using remove duplicate value
Ans. 
Use Python's set() function to remove duplicate values from an array of strings.
• Convert the array to a set to automatically remove duplicates

• Convert the set back to a list if needed
Answered by AI
Add your answer