SK Finance Limited Data Analyst Interview Questions and Answers

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer

Q1. What is your current role ?
Add your answer
Q2. Why are you looking for a job change?
Add your answer

Q1. Python based list iteration, SQL join based questions
Add your answer

Q1. What are the project you have worked upon ?
Add your answer

Asked about a case study on whom to give a loan among 1000 customers

An easy coding round was conducted that involved SQL questions.

An easy one-hour discussion based on the resume.

Q1. Asked regarding sql to make a table and given some queries to solve over the table
Add your answer
Q2. Given easy code to solve before them very easy
Add your answer

Q1. Regarding place
Add your answer
Q2. Regarding night shifts
Add your answer

Q1. Proficiency in data analytics tool level?
Add your answer

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