Samsung Business Analyst Interview Questions and Answers

Q1. What is join in sql
Ans. 
Join in SQL is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is uniquely identified

• It must contain unique values and cannot have NULL values

• Primary key can be a single column or a combination of columns

• Example: 'ID' column in a 'Users' table can be a primary key
Answered by AI
Add your answer

1 hour baisc on general aptitude

It was simple but lengthy

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. About resume and technical
Add your answer

Q1. What is an inactive relationship in PBI
Ans. 
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
• Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.

• These relationships do not impact the data model or query performance, but can clutter the model view.

• To remove an inactive relationship, you can delete it from the relationship view in Power BI.

• Ina...read more
Answered by AI
Add your answer
Q2. Import vs Direct Query vs Live connection
Ans. 
Import vs Direct Query vs Live connection
• Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required

• Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed

• Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Answered by AI
Add your answer

Q1. Sql rank order explain
Ans. 
SQL rank order function explanation
• Rank order function in SQL assigns a rank to each row based on a specified column

• It can be used to determine the top or bottom N records in a dataset

• Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
Answered by AI
Add your answer
Q2. Merging two tables
Ans. 
Merging two tables involves combining data from both tables based on a common key.
• Identify a common key between the two tables

• Use SQL JOIN statements to merge the tables

• Choose the appropriate type of join (e.g. inner join, outer join)

• Consider the size of the tables and the performance implications of the merge
Answered by AI
Add your answer

Detailed case with four questions, required intensive number crunching and data analysis.
Suggestions: Stick to your basic understanding of the problem statement and state all your assumptions clearly.

A real business case was presented in a group of 5-7 people. Each one of us was given a specific role and we were told to discuss the case as a group and come up with a detailed solution.
A brief description of your answers/approach: We discussed the problem in hand from different angles - considering each function in detail. In the end of the discussion, we presented the business model of our idea to the Apple representatives in the form of a presentation.

Q1. Tell me about yourself
Add your answer
Q2. Tell me about a time when you had to deal with a difficult colleague
Add your answer
Q3. Biggest achievement
Add your answer
Q4. Resume based questions
Add your answer
Q5. Next part of the interview was case presentation - the at-home case we submitted before the GD round. We were given 10 minutes to give a detailed PPT on the case, which was followed by 30 minutes of Q&A se...read more
Add your answer