Allcargo Logistics Data Analyst Interview Questions and Answers

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

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

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

SQL, Python and Power BI

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

Python, SQL, Aptitude

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
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Add your answer