AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
DAT Freight & Analytics Interview Questions, Process, and Tips
Top DAT Freight & Analytics Interview Questions and Answers
- Q1. How to disable automatic sorting in the Pivot table .?asked in Supply Chain Associate interview
- Q2. Difference between truncate and delete command in SQL..?asked in Supply Chain Associate interview
- Q3. How do you remove duplicates in Excel. ?asked in Supply Chain Associate interview
DAT Freight & Analytics Interview Experiences
2 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Jan 2024. There were 2 interview rounds.
(4 Questions)
- 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.
- 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.
- 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.
- 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...
(3 Questions)
- 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...
- 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.
- 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...
Interview Preparation Tips
- Statistics
- Power Bi
- Advanced Excel
- SQL
- Database
- Python
Skills evaluated in this interview
Top DAT Freight & Analytics Supply Chain Associate Interview Questions and Answers
Supply Chain Associate Interview Questions asked at other Companies
Selected
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.
(1 Question)
- Q1. They will give you or ask you questions and you have to solve the problem
(1 Question)
- 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.
Interview Preparation Tips
All the best đź‘Ť
Top DAT Freight & Analytics Supply Chain Associate Interview Questions and Answers
Supply Chain Associate Interview Questions asked at other Companies
Jobs at DAT Freight & Analytics
Top trending discussions
Interview questions from similar companies
Interview QuestionnaireÂ
4 Questions
- Q1. Tell me about yourself
- Q2. Just a min on T20 cricket
- Q3. Improving quality of education in India
- Ans.
Improving quality of education in India
Investing in teacher training and development
Increasing access to technology and digital resources
Encouraging parental involvement in education
Promoting vocational education and skill development
Addressing the issue of inadequate infrastructure and resources
- Q4. Question on B. Tech project
Interview Preparation Tips
Experience: Reasoning / Analytical : there were many questions on venn diagram.. relationships.. cube problem... etc etc... VERBAL: questions on correction of sentences... jumbled sentences.. series... etc etc....
Total Questions: 60
College Name: NIT WARANGAL
Interview QuestionnaireÂ
22 Questions
- Q1. What are the subjects you have command in?
- Q2. Tell me about your final year project?
- Q3. Tell me about the industrial training you had?
- Q4. How does an induction motor works?
- Q5. Why motor is rated in KW whereas Transformer and generator in KVA?
- Ans.
Motors are rated in KW because they consume power, while transformers and generators are rated in KVA because they produce power.
Motors convert electrical energy into mechanical energy, so they consume power and are rated in KW.
Transformers and generators produce electrical energy, so they are rated in KVA based on their apparent power.
KVA takes into account both the real power (KW) and the reactive power (KVAR) produc...
- Q6. What is the type of motor used in ceiling fans?
- Ans.
The type of motor used in ceiling fans is an induction motor.
Ceiling fans typically use single-phase induction motors.
These motors are designed to provide a constant speed and are efficient in converting electrical energy into mechanical energy.
The motor consists of a stator and a rotor, with the stator being the stationary part and the rotor being the rotating part.
The stator contains windings that create a rotating m...
- Q7. Hoe does a thermal power plant works?
- Ans.
A thermal power plant generates electricity by converting heat energy into mechanical energy.
Thermal power plants use fossil fuels or nuclear energy to heat water and produce steam.
The steam drives a turbine, which is connected to a generator that produces electricity.
The heat source can be coal, natural gas, oil, or nuclear reactions.
The steam is condensed back into water and recycled in a closed-loop system.
Thermal p...
- Q8. Write a program to make a GP
- Ans.
A program to generate a geometric progression (GP).
Take the first term, common ratio and number of terms as input.
Use a loop to calculate each term of the GP.
Print the generated GP as output.
- Q9. Write a program to print factorial using recursion
- Ans.
A program to print factorial using recursion
Define a function to calculate factorial recursively
Base case: if the number is 0 or 1, return 1
Recursive case: multiply the number with factorial of (number - 1)
Print the factorial of a given number
- Q10. Write the logic to reverse a string without using string fnctions
- Ans.
Logic to reverse a string without using string functions
Iterate through the string from the last character to the first
Create a new string and append each character to it in reverse order
- Q11. Tell me about yourself?
- Q12. What are your hobbies?
- Q13. Apart from your technical pat and studies what have you done in college?
- Q14. What do you prefer, ethics or values?
- Q15. Suppose you are working in office and somebody came and slapped you, what will you do?
- Q16. Tell me about yourself for 5 minutes
- Q17. What are your views about Mr. Narendra Modi as PM of India
- Q18. Any extra curricular activities you have participated in school or college
- Q19. What are your strengths?
- Q20. What are your weaknesses?
- Q21. Being an Electrical engineer why do you want to join an IT company
- Q22. What do you know about TCS?
Interview Preparation Tips
Experience: In email writing one question was given describing the situation and maximum word limit. It has the keywords given to be used. 1 question, 10 minutes.This section is generally used to check your verbal ability. Make sure to use all the keywords given and complete it within time, with no spelling mistakes of course. Missing a keyword or a spelling mistake could be your goodbye to qualified list.The second section had 30 questions of quantitative aptitude. Duration 70 mins. There are questions from various sections, such as Time and speed, Time and distance, Data interpretation,etc.There are 2-3 star marked questions which have more weight-age. There my also be a dummy question who doesn't have any matching answer. Make sure uh don't attempt these questions.26-27 questions is the cut-off for qualified list.But you have to do the email writing part correctly.
Tips: Practice email writing online from various websites such as technicalbaba.com, indiageeks.comPractice quantitative aptitude as it is a must in any interview you will face. you can use R.S.Agarwal or CAT material.
Duration: 90 minutes
Total Questions: 30 + 1
Round: Interview
Experience: Greeting the interviewer is a must. Be confident and enthusiastic. Have your resume properly ready. Technical questions from your subject will be asked. Not a must that you should know any programming language like C, C++, JAVA.
Tips: Prepare 3-4 subjects of your core branch. Never try to flatter the interviewer. Be confident and answer the questions appropriately. Dont say directly " I DON'T KNOW". Atleast try even if you dont know the answer.
Round: Interview
Experience: There are certain questions which doesnt have direct answers. You have to be diplomatic about them. You should be able to see all the possible situation when a question like that is asked.
Round: Interview
Experience: The HR head may manipulate you, try to stress you, etc. Be calm and confident.Think before you speak. Prepare your answers before hand for general questions. Write your introduction on a paper and prepare it well so that you speak it confidently...
Tips: Be yourself. Be confident. Never argue with the interviewer.All the best
General Tips: Be presentable in the interview. Wear a watch. Show respect to the interviewer. Prepare 3-4 technical subjects well. Read last 15 days newspaper. Be confident when you speak. Improve your English if you are weak in it.
Skill Tips: ""
Skills: Verbal ability, Attitude, Technical knowledge, General knowledge
College Name: IMS ENGINEERING COLLEGE, GHAZIABAD
Motivation: TCS is a semi government company with a decent package and high job security.
Skills evaluated in this interview
Interview QuestionnaireÂ
4 Questions
- Q1. Tell me about your self
- Ans.
I am a Programmer Analyst with expertise in developing and maintaining software applications.
Proficient in programming languages such as Java, C++, and Python
Experience in analyzing user requirements and designing software solutions
Skilled in troubleshooting and debugging software issues
Strong knowledge of database management systems like MySQL and Oracle
Familiarity with software development methodologies like Agile an...
- Q2. Tell me about your family
- Ans.
I come from a close-knit family with diverse backgrounds and interests.
My parents are both educators, and they instilled in me a love for learning and problem-solving.
I have two siblings, an older brother who works in finance and a younger sister who is studying medicine.
We often gather for family dinners and enjoy discussing various topics, from technology to current events.
My family has been a great support system th...
- Q3. How flexibility can help, what are its advantages and disadvantages
- Ans.
Flexibility can bring advantages like adaptability and creativity, but can also lead to indecisiveness and lack of focus.
Flexibility allows for adaptability to changing situations and creativity in problem-solving.
It can also lead to indecisiveness and lack of focus if not balanced with structure and clear goals.
Advantages include increased resilience, better teamwork, and improved communication.
Disadvantages include p...
- Q4. Why is your english score bad
- Ans.
My English score is bad due to lack of practice and exposure.
Lack of practice and exposure to English language
Difficulty in understanding complex grammar rules
Limited vocabulary and poor pronunciation
Lack of confidence in speaking and writing English
Possible language barrier if English is not my first language
Interview Preparation Tips
Experience: Basic aptitude questions with some application based questions which do not require any calculation. Second section tests the verbal ability of the student with few grammar based questions and few word analogy related.
Tips: Good practice of basic aptitude questions covering most of the topics and critical reasoning questions without using pen and paper will help a lot.If you are a voracious reader you need not worry for verbal section but if you hardly read then start reading from now and develop a habit.
Duration: 40 minutes
Total Questions: 40
Round: Interview
Experience: Be honest and answer the questions confidently. For all the questions I supported myself with good answers and some examples. For the question regarding my verbal ability in which I scored less marks I answered that I recognise that weakness and started reading newspapers and word power book.
Tips: Only confidence is the mantra for hr interview. Support your answer and stick to your answer. If possible give examples and be expressive.
Skill Tips: Showcase your strengths and make the interviewer ask what you want him to ask take him in your direction.
Skills: Communication skills, Body language, Verbal ability, Critical thinking
College Name: IIT Madras
Interview Preparation Tips
Experience: No one would be eliminated in this round. They will provide you ample time - around 40-50 minutes to write a response on a case study. The topic would be new and unheard of, but you can think and write peacefully in that amount of time.
Tips: Make sure you highlight the points made and do remember them for the Group Discussion phase.
Round: Group Discussion
Experience: One-third of the guys will get selected for the interviews from each group of 8-10 guys. The topic of the GD would be same as the case study. Now, its time for you to recall the points you made during the writing section. The GD will last for around 15-20 minutes.
Tips: Good communication skills, relaxed but expressive tone. Don’t be silent and try to speak up whenever you get a chance. Try to bring new air into the discussion and think from all the different perspectives. You should speak at least 2-3 times, even if you just say 1-2 sentences each time. That will do. They also individually ask each person to speak, specifically those who could not speak, but you had better not be that guy or girl. There is no need to fight for summarizing the GD. Try to show that you are involved throughout the GD.
Round: HR Interview
Experience: There will be two guys, one from technical and the other HR. They both ask questions at the same time and they discuss among each other as well. They mostly try to detect any fraud or fake thing you did in your project or intern. All the technical questions come from your CV. So, your fate is kind of in your hands only.
Tips: Prepare hard for Projects, Internships etc. Don’t panic. They try to see how you react in a pressure situation and actually behave as if you are not impressing them. Just be calm and keep on speaking. If there is something you want to say and they interrupt you, its better you ask them to give you a chance to explain it in details. Do have a few questions in mind to ask them about your job profile and Wipro. That is the final nail in the coffin.
Skill Tips: A minimum CGPA of 8.0 was mentioned and later they relaxed it to 7.9. They were giving quite some importance to the Internships and Projects undertaken and were trying to judge if you actually did something new and genuine. They were dwelling deep into it. As I said, prepare well for them just like you prepare for BTech Project Viva. They do ask a lot of questions.HR questions should be prepared thoroughly. A background check of Wipro and IT sector companies is a must. Prepare well for group discussions. Try to get background information about the IT sector and the company. Prepare your CV thoroughly.
College Name: IIT KHARAGPUR
Interview Preparation Tips
Experience: Fundae session by seniors and a resume workshop by some company. Also, sent resume to some seniors for their opinions and I think this was an important part of it.
Tips: I suggest Pre-placement talks, are a must. What is more important is not to believe the PPTs completely and ask seniors about the level of fundaes (finance/tech/otherwise) and preparation required to crack the company. There is a lot of good material on ATKEARNEY and other website. Other than that I used the material available for years.
Round: Interview
Experience: Final offers in my division were 12. There were two levels of case interviews. The first interview was to judge if I would be suitable for the Strategy and Operations profile or for the Technology and Integration profile. There were two interviewers. They explained to me both the profiles and asked me what I wanted to choose and why. Then asked me some general HR questions like why consulting, why you etc. Then started off with an informal case study. It was about a new company which wanted to start a new low cost airline and had no experience in this market till now. It has two options: either to acquire an existing company or to build up all processes on their own. I was first asked to qualitatively mention what all aspects I would consider. After that they asked me what new things could this company do. They were pretty satisfied with my answers and I was confident of getting listed in the next round. In the next round there was single interviewer who was looking quite senior. Asked some HR questions. One case study about a consumer durables dealer which was again qualitative. Asked some HR questions that's it.
General Tips: Lack of interaction with seniors throughout IIT stay was one thing for which I had to pay. I had no seniors in my wing and I had no fundae of the amount of preparation required.
So make sure that you have certain information.
College Name: IIT-Bombay
Interview Preparation Tips
Experience: 1 round of 10 minutes duration.
Depends very much on what position they are trying to fill in and area of expertise of the interviewer(s). They asked me basic questions on Image Processing. Interview went decent
College Name: IIT MADRAS
Interview Preparation Tips
Experience: Simple Aptitude - just brush up basics - be quick in your solving.
Duration: 120min minutes
Total Questions: 50+10
Round: HR Interview
Experience: Pretty simple interview round - was asked few HR questions. Majorly it was a informative session where i was told about the job profile and tested whether I was willing to take up the responsibility & commitment.
College Name: IIT MADRAS
Motivation: Just applied gen. Got through.
Interview Preparation Tips
Experience: The aptitude test basically consisted of questions from Data Structures and some other simple algorithms and also on Object Oriented Analysis. The aptitude test was tricky (having negative markings +2/-1 scheme). To cross this test speed and skill are essential.
The next test was a coding exams there were three questionsÂ
1) Given a linked list, link the odd nodes followed by the even nodes in place.
2) Given a dictionary of words find words that are anagrams of each other.
3) Given a binary tree and a node print that node's path from root.
Duration: 95 minutes
Round: Technical Interview
Experience: There were 4 rounds of interviews...
the details are as follows
Interview 1 - This interview was basically DS based interview and certain concepts of networking were touched. I
told them that i am interested in data structures and cryptography so most of the questions came from those areas only.
Interview 2 - Was again technical. The interviewer asked me on Data Structures and a Dynamic Programming problem and some other puzzles to solve.
Interview 3 - This was technical but they evaluated the design skills. Asked me on ER diagrams, class diagrams and
database design and system design and some basic questions from OS.Â
Interview 4 - This was also a technical interview mainly on problem solving and DS design (how would you design a DS to handle this situation and so on).
Round: HR Interview
Experience: There was no HR interview as such. They were asking questions in tech interviews such as tell me about yourself and so on.
General Tips: Data Structures, OOPS and OS. Solve a variety of problems. All the best!!!
College Name: NIT WARANGAL
DAT Freight & Analytics Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
DAT Freight & Analytics Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
DAT Freight & Analytics Reviews and Ratings
based on 6 reviews
Rating in categories
|
Supply Chain Associate
12
salaries
|  â‚ą3 L/yr - â‚ą10.9 L/yr |
|
Data Analyst
5
salaries
| â‚ą7.5 L/yr - â‚ą9.5 L/yr |
|
Software Engineer
4
salaries
| â‚ą6 L/yr - â‚ą20 L/yr |
|
Associate
4
salaries
| â‚ą9.5 L/yr - â‚ą9.5 L/yr |
|
Supply Chain Analyst
4
salaries
| â‚ą4.6 L/yr - â‚ą17.4 L/yr |
BlackBuck
Delhivery
Ecom Express
Shadowfax Technologies
- Home >
- Interviews >
- DAT Freight & Analytics Interview Questions
