Delhivery Production Analyst Interview Questions and Answers

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

Q1. Show me the PowerBi Data Relations
Ans. 
PowerBI Data Relations show how tables are related to each other in a data model.
• Data relations are created by linking columns between tables.

• One table can have multiple relationships with other tables.

• Data relations can be one-to-one, one-to-many, or many-to-many.

• PowerBI automatically detects and creates relationships based on column names.

• Data relations can be edited and managed in the Relationship view.
Answered by AI
Add your answer
Q2. Python code issue resolve
Add your answer

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

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