Allcargo Logistics Data Analyst Interview Questions and Answers for Experienced

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
Add your answer

Basic aptitude tests 50 questions for 1 hr

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

First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset

Talk to the head hunter. General phone screening

Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Add your answer

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

SQL, Python and Power BI

Q1. Sql joins ,proimary key, foreign key,window functions
Add your answer
Q2. What are the different types of charges associated with logistics?
Ans. 
Logistics charges encompass various costs incurred in the transportation and storage of goods.
• Transportation Costs: Fees for moving goods via truck, rail, air, or sea. Example: Freight charges for shipping a container.

• Warehousing Fees: Costs associated with storing goods in a warehouse. Example: Monthly rental fees for storage space.

• Handling Charges: Fees for loading and unloading goods. Example: Charges for palletizin...read more
Answered by AI
Add your answer
Q3. What is the SQL query to retrieve the top three maximum salaries from a table?
Add your answer