Add office photos
Filter interviews by
Apsis Technologies MIS Executive and Analyst Interview Questions, Process, and Tips
Apsis Technologies MIS Executive and Analyst Interview Experiences
1 interview found
Pavani M
Selected
I was interviewed in Dec 2024.
(5 Questions)
- Q1. What is Vlookup ?
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'.
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.
The syntax for Vlookup is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Example: =VLOOKUP(A2, B2:D...
- Q2. What tools you are using for primary sales data?
- Ans.
I primarily use Salesforce and Microsoft Excel for analyzing and managing primary sales data.
Salesforce for tracking customer interactions and sales data
Microsoft Excel for organizing and analyzing sales data
- Q3. Difference between Vlookup and xlookup?
- Ans.
Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible version of Vlookup.
Vlookup searches vertically in a table for a value and returns a corresponding value from a specified column.
Xlookup can search both vertically and horizontally in a table, and can return values from any column or row.
Vlookup requires the loo...
- Q4. What tool you are using the secondary sales
- Ans.
I use Salesforce CRM tool for tracking secondary sales.
Salesforce CRM is used to record and track secondary sales data
It helps in analyzing sales trends, forecasting, and performance evaluation
Customized reports and dashboards can be created for better insights
Integration with other tools like ERP systems for seamless data flow
- Q5. How much rate you can give in Excel?
- Ans.
I am proficient in Excel and can rate myself 8 out of 10.
I am skilled in using formulas and functions in Excel.
I have experience in creating pivot tables and charts.
I am proficient in data analysis and reporting using Excel.
I have used VLOOKUP, HLOOKUP, and other advanced functions in Excel.
I have completed Excel certification courses.
Top trending discussions
Interview questions from similar companies
Anonymous
I was interviewed in Dec 2024.
(27 Questions)
- Q1. Tell me about yourself
- Q2. Have you ever worked on devops
- Q3. How do you deploy tags in Jenkins and UCD
- Q4. What you will do if you get a production issue
- Q5. If the respective team is responsible to resolve an issue and they are not supporting you because of their priority items what you will do
- Q6. What is .Net Framework
- Q7. What is c#
- Q8. Page life cycle of ASP.NET and explanation
- Q9. OOPS Concept and Encapsulation Example
- Q10. Value type and Ref Types
- Q11. Constant and ReadOnly
- Q12. How can you delete the duplicate values in a table
- Q13. Difference between group by and having/ union and union all
- Q14. Query to select last 5 records in a table
- Q15. What is SMTP and what is the name space for that
- Q16. Mention few name spaces you have used in your code
- Q17. What is WEB API
- Q18. Why WEB API is crucial over Web Services
- Q19. How do you provide Security to your WEB API
- Q20. What is Authentication and Authorization
- Q21. What is difference between JSON and XML
- Q22. Filters in MVC
- Q23. What is MVC
- Q24. What is Routing in MVC
- Q25. How an application Interact with API
- Q26. Architecture of API
- Q27. What is HTTP
Interview Preparation Tips
I would say covering most of the topics in terms of definition would be the first thing we have to do, Then if you are sure about the definitions add example program for every definition by understanding the usage and functionality
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.
- Ans.
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration
I have 5 years of experience in analyzing business processes and identifying areas for improvement
I am proficient in using data analysis tools such as Excel and SQL
I have a proven track record of successfully implementing process improvements that have
- Q2. What were your job responsibilities in your previous company?
- Ans.
I was responsible for analyzing business processes, gathering requirements, creating reports, and providing recommendations for improvement.
Analyzed current business processes to identify areas for improvement
Gathered and documented business requirements from stakeholders
Created reports and presentations to communicate findings and recommendations
Collaborated with cross-functional teams to implement process improvement...
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)?
- Ans.
Ensuring data accuracy in MIS is crucial for making informed decisions, improving operational efficiency, and maintaining credibility.
Accurate data ensures that decisions are based on reliable information, leading to better outcomes.
Improves operational efficiency by reducing errors and minimizing the need for rework.
Maintains credibility of the organization by providing accurate and trustworthy information to stakehol...
- Q2. Can you describe your experience in managing a complex Management Information Systems (MIS) project?
- Ans.
I have successfully managed a complex MIS project involving multiple stakeholders and systems integration.
Led a team of analysts and developers to design and implement a new MIS system for a large financial institution
Coordinated with various departments to gather requirements and ensure alignment with business goals
Managed project timelines, budgets, and resources to ensure successful delivery
Implemented change manage...
(2 Questions)
- Q1. What is your current salary?
- Ans.
I am currently earning a competitive salary based on my experience and skills.
My current salary is in line with industry standards for my level of experience.
I am open to discussing salary expectations for this new role.
I believe my compensation should reflect the value I bring to the company.
- Q2. What percentage of salary raises do you typically issue?
- Ans.
I typically issue salary raises ranging from 2-5% based on performance and market standards.
Salary raises are typically based on performance evaluations and market standards.
Raises can range from 2-5% for average performers, higher for exceptional performers.
Consider factors like company budget and industry benchmarks when determining salary raises.
Selected
I was interviewed in Dec 2024.
(2 Questions)
- Q1. What are the seven quality control tools?
- Ans.
The seven quality control tools are essential for analyzing and solving quality-related issues in a systematic manner.
Check sheets: Used for collecting and organizing data, such as defect counts or frequency of occurrences.
Pareto charts: Helps in identifying the most significant factors contributing to a problem by displaying them in descending order.
Cause-and-effect diagrams (Fishbone diagrams): Used to identify and a...
- Q2. What is the feedback procedure?
- Ans.
Feedback procedure involves collecting, analyzing, and acting upon feedback from customers or stakeholders.
Collect feedback through surveys, interviews, or suggestion boxes
Analyze feedback to identify trends, patterns, and areas for improvement
Act upon feedback by implementing changes or addressing concerns
Follow up with customers or stakeholders to ensure their feedback was addressed
Document feedback and actions taken
(2 Questions)
- Q1. What are the Key Result Areas (KRA) for an auditor?
- Ans.
Key Result Areas (KRA) for an auditor include compliance with regulations, accuracy of financial statements, and identification of risks.
Ensuring compliance with regulations and standards
Accuracy of financial statements and reports
Identification and assessment of risks
Effective communication with stakeholders
Continuous improvement of audit processes
- Q2. Scenario based questions about quality analyst.
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
- Ans.
In Tableau, the hierarchy of filters determines the order in which filters are applied to the data.
Filters are applied in the order they appear in the Filter Shelf.
Context filters are applied first, then dimension filters, and finally measure filters.
Filters can be set to apply to all worksheets or only specific worksheets.
Example: If a context filter is applied to a dimension, it will filter the data before any other
- Q2. What are Parameter actions
- Ans.
Parameter actions allow users to dynamically change parameter values in Tableau dashboards.
Parameter actions enable users to interact with dashboard parameters by clicking on marks or selecting values.
They can be used to filter data, highlight specific information, or drive calculations.
For example, a user can click on a bar chart to update a parameter value and see corresponding changes in other visualizations.
- Q3. How to toggle between pages
- Ans.
To toggle between pages, use navigation buttons, links, or keyboard shortcuts.
Use navigation buttons like 'Next' and 'Previous'
Click on links or tabs to switch between pages
Use keyboard shortcuts like Ctrl + Tab to toggle between open tabs
(1 Question)
- Q1. Why did you choose Genpact
- Ans.
I chose Genpact for its reputation in the industry and opportunities for growth.
Genpact has a strong reputation in the industry for providing innovative solutions to clients.
The company offers a wide range of opportunities for career growth and development.
I was impressed by Genpact's focus on continuous learning and development for its employees.
(1 Question)
- Q1. Offer negotiation
Selected
I was interviewed in Jan 2025.
(1 Question)
- Q1. Self introduction
(2 Questions)
- Q1. About last Experienced
- Q2. Accounting Knowledge
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
Vishva
(2 Questions)
- Q1. Qstn related sql
- Q2. Qstn related sqlw
(2 Questions)
- Q1. Question related sql and case studies
- Q2. Qstn related sql and case studies
(1 Question)
- Q1. Salary discussion
(2 Questions)
- Q1. Question related sql and case studies
- Q2. SQL and case studies
Apsis Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Apsis Technologies MIS Executive and Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Engineer
81
salaries
|  ₹3.6 L/yr - ₹10.9 L/yr |
|
Software Developer
29
salaries
| ₹3 L/yr - ₹11 L/yr |
|
Softwaretest Engineer
23
salaries
| ₹4 L/yr - ₹7.7 L/yr |
|
Devops Engineer
21
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Automation Test Engineer
19
salaries
| ₹3 L/yr - ₹9.8 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Apsis Technologies Interview Questions >
- Apsis Technologies MIS Executive and Analyst Interview Questions
