DP Associates Interview Questions, Process, and Tips

Basic questions which related to reasoning, Google sheet, SQL related questions and some mathematics questions.

Q1. Ask about the cell reference?
Add your answer
Q2. What is joins in SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q3. Asked about SQL statement, order by, group by, where clause etc?
Add your answer
Q4. What is Power BI?
Ans. 
Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.
• Business analytics tool by Microsoft

• Used for visualizing and analyzing data

• Allows users to create interactive reports and dashboards

• Integrates with various data sources such as Excel, SQL databases, and cloud services
Answered by AI
Add your answer
Q5. What is pivot table and how to use that?
Ans. 
A pivot table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Allows users to reorganize and summarize selected columns and rows of data

• Can perform calculations, such as sums, averages, counts, etc., on the summarized data

• Provides a dynamic way to view and analyze data from different perspectives

• Commonly used in Excel, Google Sheets, and other spread
Answered by AI
Add your answer
Q6. Some function like vlookup, xlookup, hlookup, import range, text, workday.intl etc.
Add your answer
Q7. What is inventory management system?
Ans. 
An inventory management system is a software tool that helps businesses track and manage their inventory levels, orders, sales, and deliveries.
• Automates inventory tracking and management processes

• Provides real-time visibility into inventory levels

• Helps optimize inventory levels to prevent stockouts or overstocking

• Facilitates order management and fulfillment

• May include features like barcode scanning, serial number track...read more
Answered by AI
Add your answer
Q8. How does FMS work?
Ans. 
FMS stands for Facility Management System, which is a software solution used to manage and optimize the maintenance and operations of facilities.
• FMS helps in tracking and managing assets, equipment, and resources within a facility.

• It can schedule preventive maintenance tasks to ensure equipment is functioning properly.

• FMS can also track work orders, manage inventory, and provide reporting and analytics on facility oper...read more
Answered by AI
Add your answer

Q1. The first question was in this round that tell about your self?
Add your answer
Q2. Asked about previous company experience and details of job.
Add your answer