Samsung
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Top trending discussions
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
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
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
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
1 hour baisc on general aptitude
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
It was simple but lengthy
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
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...
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
I have strong analytical skills, excellent communication and problem-solving abilities, and a keen eye for detail.
Strong analytical skills
Excellent communication and problem-solving abilities
Keen eye for detail
I applied via Campus Placement
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.
I applied via Job Portal
based on 5 reviews
Rating in categories
Sales Executive
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
959
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
871
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
526
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
481
salaries
| ₹0 L/yr - ₹0 L/yr |
Apple
LG Electronics
Sony
Xiaomi