Add office photos
Filter interviews by
DP Associates MIS Analyst Interview Questions, Process, and Tips
DP Associates MIS Analyst Interview Experiences
1 interview found
PRADEEP
Selected
I applied via WorkIndia and was interviewed in May 2024. There were 3 interview rounds.
Basic questions which related to reasoning, Google sheet, SQL related questions and some mathematics questions.
(8 Questions)
- Q1. Ask about the cell reference?
- 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;
- Q3. Asked about SQL statement, order by, group by, where clause etc?
- 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
- 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
- Q6. Some function like vlookup, xlookup, hlookup, import range, text, workday.intl etc.
- 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...
- 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...
(2 Questions)
- Q1. The first question was in this round that tell about your self?
- Q2. Asked about previous company experience and details of job.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
(2 Questions)
- Q1. They asked my computer knowledge
- Q2. Explain about your self
(1 Question)
- Q1. What is h look up and pivot table
- Ans.
HLOOKUP is a function in Excel used to search for a value in the top row of a table or an array, while a pivot table is a data summarization tool.
HLOOKUP function searches for a value in the top row of a table or an array and returns a value in the same column from a specified row.
Pivot tables are used to summarize, analyze, explore, and present data in a spreadsheet.
HLOOKUP example: =HLOOKUP(lookup_value, table_array,...
I applied via Naukri.com and was interviewed in Jan 2022. There were 3 interview rounds.
(4 Questions)
- Q1. Why are you looking for a change?
- Q2. What are your strengths and weaknesses?
- Q3. Share details of your previous job.
- Q4. Tell me about yourself.
(1 Question)
- Q1. Every thing with respect to your applied post and ur technical background.
(1 Question)
- Q1. Everything about the process and post for which they are hiring
Interview Preparation Tips
I applied via campus placement at College of Engineering ( Formerly Pune Instiute of Enginering and Technology ), Pune and was interviewed in Nov 2024. There were 2 interview rounds.
Aptitude test contains Logical Reasoning Questions, Analytical Skills questions, and some general Questions, there are no coding questions for it
(6 Questions)
- Q1. First Question is to introduce yourself
- Q2. Want to explain me my data science project I explained it in good way
- Q3. Gave some scenario that how your project will work for these secnarios
- Q4. Asks me about the polymorphism and its example
- Q5. Asks about my family background
- Q6. Asks whether I am able to relocate
I applied via Walk-in and was interviewed in Dec 2024. There were 5 interview rounds.
(2 Questions)
- Q1. Tell me about yourself.
- Q2. What were your job responsibilities in your previous company?
Logical and reasoning questions.
Introduce the topic area of the report, outlining the purpose of the case study. Summarize the key issues and findings without providing specific details, and identify the theory employed.
(2 Questions)
- Q1. What is the importance of ensuring data accuracy in Management Information Systems (MIS)?
- Q2. Can you describe your experience in managing a complex Management Information Systems (MIS) project?
(2 Questions)
- Q1. What is your current salary?
- Q2. What percentage of salary raises do you typically issue?
Ayush rameja
Selected
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. What is DNS, HTTP/s, TLS, SSL?
- Q2. What is the latest for HTML, CSS, and JS?
(3 Questions)
- Q1. What are the latest features in ES10?
- Q2. What is the difference between async and promises?
- Q3. Why everything is a object in JavaScript
Interview Preparation Tips
K B Kushi
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Hierarchy of filters in tableau
- Q2. What are Parameter actions
- Q3. How to toggle between pages
(1 Question)
- Q1. Why did you choose Genpact
(1 Question)
- Q1. Offer negotiation
I applied via Naukri.com and was interviewed in Nov 2024. There were 4 interview rounds.
(2 Questions)
- Q1. Which is the best level in Wipro? Ans:Now Wipro has introduced quarterly appraisal system.
- Q2. What is the process of Wipro ? Ans: Wipro,a global information technology, consulting,and business process service company.
Can you recommend any free website for taking an online carrier aptitude test and recieving a detailed report on sutaible job options.
What is the best resource to learn data structure and algorithm(must contain practice assignments too)? I have stumbled across Coursera,but does it cover all essential details about DSA?
(1 Question)
- Q1. What is technical? Ans: Defination must be able to apply the technical knowledge and skills required in the specialist and professional job role.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
- Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level.
- Ans.
Create calculated fields in Tableau to dynamically adjust to changing table columns.
Use calculated fields to reference specific columns by name instead of position.
Utilize parameters to allow users to select which columns to display.
Consider using custom SQL queries to dynamically adjust to changing table structure.
- Q3. Row level security
- Q4. Tell me about your project
- Ans.
Developed a predictive model to forecast customer churn for a telecommunications company.
Utilized machine learning algorithms such as logistic regression and random forest
Performed data preprocessing and feature engineering to improve model performance
Collaborated with business stakeholders to understand key drivers of churn
Achieved 85% accuracy in predicting customer churn
Interview Preparation Tips
LoL Create
Selected
(2 Questions)
- Q1. What is a VPN, and how does it work?
- Q2. What steps would you take if the server were to go down?
Interview Preparation Tips
DP Associates Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
|
Interior Designer
4
salaries
|  ₹4 L/yr - ₹4.8 L/yr |
|
Account Assistant
4
salaries
| ₹1.4 L/yr - ₹5.4 L/yr |
|
Project Manager
3
salaries
| ₹0.6 L/yr - ₹0.9 L/yr |
|
Accountant
3
salaries
| ₹1.2 L/yr - ₹2.4 L/yr |
|
Facility Executive
3
salaries
| ₹2.2 L/yr - ₹2.2 L/yr |
TCS
Accenture
Wipro
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- DP Associates Interview Questions >
- DP Associates MIS Analyst Interview Questions
