DAT Freight & Analytics Interview Questions and Answers

Q1. How to disable automatic sorting in the Pivot table .?
Ans. 
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.
Answered by AI
Add your answer
Q2. How do you remove duplicates in Excel. ?
Ans. 
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.
Answered by AI
Add your answer
Q3. Difference between truncate and delete command in SQL..?
Ans. 
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.
Answered by AI
Add your answer
Q4. What is RLS in Power BI .?
Ans. 
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...read more
Answered by AI
Add your answer

Q1. What are mean, median and mode.?
Ans. 
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...read more
Answered by AI
Add your answer
Q2. What are the different joins in SQL .?
Ans. 
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.
Answered by AI
Add your answer
Q3. What are stored procedures in SQL.?
Ans. 
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...read more
Answered by AI
Add your answer

They will ask about your understanding in the tools you mentioned in resume.

Q1. They will give you or ask you questions and you have to solve the problem
Add your answer

Q1. If you clear the round 1&2 then this round is applicable. Basically here your HR will be checking your behavioural skills and talks about your previous journey. And Also the salary negotiation part.
Add your answer