Sewa Grih Rin Data Analyst Interview Questions and Answers for Experienced

Q1. Tell me about the types of join sql.
Ans. 
Types of join SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q2. Tell about the dax function
Ans. 
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
• DAX functions are used to create calculated columns, measures, and calculated tables in Power BI and Excel.

• DAX functions include mathematical, logical, statistical, and text functions.

• Examples of DAX functions are SUM, AVERAGE, IF, RELATED, CALCULATE, etc.
Answered by AI
Add your answer

Reasoning , SQL and probability

Q1. SQL queries and python
Add your answer
Q2. Reasoning and guesstimate
Add your answer

Q1. Reportings applicable to function
Ans. 
Reportings are essential for any function to track progress and identify areas of improvement.
• Regular reports should be generated to track progress and identify areas of improvement.

• Reports should be customized to the specific function and its goals.

• Reports should be easily understandable and actionable.

• Examples of reportings applicable to functions include sales reports, performance reports, and budget reports.
Answered by AI
Add your answer
Q2. Regulatory updates going on business environment
Ans. 
Regulatory updates are constantly shaping the business environment, impacting industries and companies in various ways.
• Regulations can affect everything from product development to marketing and sales strategies

• Changes in regulations can create new opportunities or pose challenges for businesses

• Industries such as healthcare, finance, and technology are particularly affected by regulatory updates

• Examples of recent regul...read more
Answered by AI
Add your answer

Q1. Why this job with this profile. They never read my CV before interview
Add your answer
Q2. Useless questions not centred around JD
Add your answer

Q1. Self information, previous and current company details
Add your answer

Q1. Technical knowledge and Excel knowledge.
Add your answer

Questions based on SQL,Python and computer networks

Q1. About salary,6 working days,
Add your answer