Upload Button Icon Add office photos

Allcargo Logistics

Compare button icon Compare button icon Compare

Filter interviews by

Allcargo Logistics Data Analyst Interview Questions and Answers

Updated 7 Jun 2024

Allcargo Logistics Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 7 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Give me details of your past projects that impacted organisation?
  • Q2. Resolve the current case problem by providing your approach.

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What is the mean of DHL. ( full form).
  • Ans. 

    DHL stands for Dalsey, Hillblom, and Lynn, the surnames of the founders. It is a global logistics company.

    • DHL is a multinational courier, parcel, and express mail service.

    • It was founded in 1969 by Adrian Dalsey, Larry Hillblom, and Robert Lynn.

    • DHL provides services for shipping, tracking, and delivering packages worldwide.

    • The mean of DHL refers to the average or central tendency of the company's operations, such as rev...

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Highlight min & Max sales for each year in tableau.
  • Ans. 

    Use Tableau to highlight the minimum and maximum sales for each year.

    • Create a new worksheet in Tableau

    • Drag the 'Year' field to the Columns shelf

    • Drag the 'Sales' field to the Rows shelf

    • Drag the 'Sales' field again to the Color shelf

    • Right-click on the 'Sales' field in the Color shelf and select 'Measure' > 'Min'

    • Right-click on the 'Sales' field in the Color shelf again and select 'Measure' > 'Max'

    • Format the visualization

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Safety related questions were asked..
  • Q2. U must have full knowledge of axcel.

I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Sql query, MS excel and puzzles
  • Q2. Assumptions of linear regression model
  • Ans. 

    Assumptions of linear regression model

    • Linearity: relationship between independent and dependent variables is linear

    • Independence: residuals are independent of each other

    • Homoscedasticity: variance of residuals is constant across all levels of predictor variable

    • Normality: residuals are normally distributed

    • No multicollinearity: independent variables are not highly correlated with each other

  • Answered by AI
  • Q3. Puzzle of how to fill 4litres water in 3litre and 5litre capacity vessel

Interview Preparation Tips

Interview preparation tips for other job seekers - Its easy they will ask very basic questions and about the projects

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

SQL, Python Coding & MCQ test

Round 2 - Case Study 

Behavioural questions mostly, they tey ro find approach.

Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiations
  • Q2. Location preference
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It is the 30 mins of mathatic question and easy done .

Round 2 - Coding Test 

2 QUESTIONS are give ,you have to solve the q in 30 mins

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude tests 50 questions for 1 hr

Round 2 - Coding Test 

1) find number of set bits in given number
2) add to numbers represented by linked list

Interview Preparation Tips

Topics to prepare for Exl India Data Analyst interview:
  • C
  • C++
  • DSA
Interview preparation tips for other job seekers - Basic dsa and aptitude is enough for passing the interview
My interviewer did not asked me any guesstimate but some of my friends told me that their interviewer asked them guesstimates
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Case Study 

Talk to the head hunter. General phone screening

Round 2 - One-on-one 

(1 Question)

  • Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Round 3 - Case Study 

Shared a dataset and wanted me to provide some insights and also build some slides to present

Interview Preparation Tips

Interview preparation tips for other job seekers - better to ask about the team structure and also training, career development
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Python, SQL, Aptitude

Round 2 - Technical 

(3 Questions)

  • Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
  • Q2. PowerBI - Create Bookmarks in Power BI
  • Ans. 

    Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.

    • Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

    • Users can add bookmarks by selecting 'Add' and then naming the bookmark.

    • Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

    • Bookmarks can be used to save different views of a report for easy acc

  • Answered by AI
  • Q3. SQL - Find cumulative Profit sum in a given table.
  • Ans. 

    Use SQL query with window function to find cumulative profit sum in a given table.

    • Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

    • Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

    • Ensure the table has a column for date and profit to order and calculate cumulative sum.

  • Answered by AI

Allcargo Logistics Interview FAQs

How many rounds are there in Allcargo Logistics Data Analyst interview?
Allcargo Logistics interview process usually has 1 rounds. The most common rounds in the Allcargo Logistics interview process are One-on-one Round.

Tell us how to improve this page.

Allcargo Logistics Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

DTDC Express Interview Questions
3.7
 • 153 Interviews
Exl India Interview Questions
3.5
 • 104 Interviews
FedEx Express Interview Questions
4.0
 • 93 Interviews
GATI-KWE Interview Questions
3.9
 • 88 Interviews
DHL Express Interview Questions
4.1
 • 65 Interviews
DP World Interview Questions
3.9
 • 63 Interviews
Maersk Line Interview Questions
4.1
 • 29 Interviews
FM LOGISTIC Interview Questions
3.8
 • 25 Interviews
View all

Fast track your campus placements

View all
Allcargo Logistics Data Analyst Salary
based on 5 salaries
₹3.5 L/yr - ₹7 L/yr
9% less than the average Data Analyst Salary in India
View more details

Allcargo Logistics Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

3.0

Salary

4.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Assistant Manager
116 salaries
unlock blur

₹4 L/yr - ₹13.5 L/yr

Senior Executive
109 salaries
unlock blur

₹3.5 L/yr - ₹7.5 L/yr

Deputy Manager
81 salaries
unlock blur

₹6.1 L/yr - ₹17.5 L/yr

Executive
64 salaries
unlock blur

₹2.4 L/yr - ₹5.5 L/yr

Operations Executive
49 salaries
unlock blur

₹2.5 L/yr - ₹4.6 L/yr

Explore more salaries
Compare Allcargo Logistics with

DTDC Express

3.7
Compare

GATI-KWE

3.9
Compare

Exl India

3.5
Compare

DHL Supply Chain

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview