Filter interviews by
I applied via LinkedIn and was interviewed in Jan 2024. There were 2 interview rounds.
To disable automatic sorting in a Pivot table, go to the Pivot table options and uncheck the 'Sort automatically' option.
Open the Pivot table in Excel.
Go to the 'PivotTable Analyze' or 'Options' tab.
Click on the 'Options' button in the 'PivotTable' group.
In the 'PivotTable Options' dialog box, go to the 'Data' tab.
Uncheck the 'Sort automatically' option.
Click 'OK' to apply the changes.
To remove duplicates in Excel, use the Remove Duplicates feature under the Data tab.
Select the range of cells or columns that contain the data.
Go to the Data tab and click on the Remove Duplicates button.
Choose the columns to check for duplicates and click OK.
Excel will remove the duplicate values and keep only the unique values.
You can also choose to highlight the duplicate values instead of removing them.
Truncate is a DDL command that removes all rows from a table, while delete is a DML command that selectively removes rows.
Truncate is faster than delete as it doesn't generate any log entries.
Truncate cannot be rolled back, while delete can be.
Truncate resets the identity of the table, delete does not.
Truncate does not fire triggers, delete does.
Truncate releases the storage space, delete does not.
RLS in Power BI stands for Row-Level Security.
RLS is a feature in Power BI that allows you to restrict data access at the row level based on user roles.
It helps in ensuring that users only see the data that is relevant to them.
RLS can be implemented by defining roles and rules in Power BI Desktop or Power BI service.
For example, you can create a role that only allows access to sales data for a specific region.
RLS is us...
Mean, median, and mode are statistical measures used to describe the central tendency of a dataset.
Mean is the average of a set of numbers, calculated by summing all the values and dividing by the total count.
Median is the middle value in a dataset when arranged in ascending or descending order.
Mode is the value that appears most frequently in a dataset.
Mean is sensitive to outliers, while median is not.
Mode can be use...
Different joins in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and the matching rows from the right table.
Right join returns all rows from the right table and the matching rows from the left table.
Full outer join returns all rows from both tables, including unmatched rows.
Stored procedures are precompiled SQL statements that are stored in a database and can be executed multiple times.
Stored procedures are used to encapsulate a set of SQL statements into a single unit.
They can be used to improve performance by reducing network traffic.
Stored procedures can be parameterized, allowing for dynamic execution.
They provide a level of security by controlling access to the underlying database ob...
I applied via Approached by Company and was interviewed before Mar 2022. There were 4 interview rounds.
They will ask about your understanding in the tools you mentioned in resume.
Top trending discussions
2 Leetcode Medium questions on hackerrank
I applied via Approached by Company and was interviewed in Aug 2021. There were 3 interview rounds.
Assignment to develop a prototype
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Will be given Requirement to write code for Restraunt. Based on that have write code for delivering orders by delivery boys.
Two questions to be solved in 1 hr.
I applied via Campus Placement and was interviewed in Mar 2024. There was 1 interview round.
There were 5 question out of which 2 were coding Data Structure problems , 1 was SQL based , 1 was AI based Problem ( Machine Learning ) and 1 was to create UML Diagram.
First Coding question was pretty easy , other one was kinda tough , UML Diagram was also easy and SQL query was of moderate level.
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 2 interview rounds.
The current project follows a microservices architecture with Docker containers for scalability and flexibility.
Microservices architecture is used to break down the application into smaller, independent services that can be developed, deployed, and scaled independently.
Docker containers are utilized for packaging the application and its dependencies into a standardized unit for easy deployment and management.
Service di...
Basic coding questions
I applied via LinkedIn and was interviewed before Jan 2024. There were 2 interview rounds.
1 DSA and some simple programming questions asked.
Standard dsa questions, easy to medium
based on 2 interviews
Interview experience
based on 6 reviews
Rating in categories
8-12 Yrs
Not Disclosed
Supply Chain Associate
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager- HR
4
salaries
| ₹0 L/yr - ₹0 L/yr |
BlackBuck
Delhivery
Ecom Express
Shadowfax Technologies