Samsung Insights and Analytics Manager 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

Q1. Share details of your previous job.
Add your answer
Q2. What is your family background?
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. Where do you see yourself in 5 years?
Add your answer
Q5. What are your strengths and weaknesses?
Add your answer
Q6. Tell me about yourself.
Add your answer

Q1. 1. Methods under IND AS 115 2. Treatment under IND As 116 3. Advance tax dates 4. Treatment of rent under ind as 116 5. Rate for pv discounting of fmc 6. Changes in schedule III 7. Warranty treatment
Ans. 
The interviewee is asked about methods, treatment, advance tax dates, rent, discounting rate, changes in schedule III, and warranty treatment.
• IND AS 115 outlines the revenue recognition principles for contracts with customers

• IND AS 116 outlines the accounting treatment for leases

• Advance tax dates are the dates by which taxpayers must pay a certain percentage of their estimated tax liability

• Under IND AS 116, rent is rec...read more
Answered by AI
Add your answer

Q1. About general problems and leadership basis
Add your answer

Q1. About process and self introduction
Add your answer
Q2. All process KPI'S
Ans. 
Process KPIs are key performance indicators that measure the effectiveness and efficiency of a process.
• Process KPIs help identify areas for improvement and monitor progress towards goals.

• Examples of process KPIs include cycle time, error rate, customer satisfaction, and productivity.

• Process KPIs should be specific, measurable, achievable, relevant, and time-bound (SMART).

• Regularly tracking and analyzing process KPIs ca...read more
Answered by AI
Add your answer

Q1. Discussed on salary
Add your answer
Q2. About expectation
Add your answer