Aikya Business Solution MIS Analyst Interview Questions and Answers

Q1. Self information, previous and current company details
Add your answer

Q1. Technical knowledge and Excel knowledge.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Have you ever worked on devops
Add your answer
Q3. How do you deploy tags in Jenkins and UCD
Add your answer
Q4. What you will do if you get a production issue
Add your answer
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
Add your answer
Q6. What is .Net Framework
Add your answer
Q7. What is c#
Add your answer
Q8. Page life cycle of ASP.NET and explanation
Add your answer
Q9. OOPS Concept and Encapsulation Example
Add your answer
Q10. Value type and Ref Types
Add your answer
Q11. Constant and ReadOnly
Add your answer
Q12. How can you delete the duplicate values in a table
Add your answer
Q13. Difference between group by and having/ union and union all
Add your answer
Q14. Query to select last 5 records in a table
Add your answer
Q15. What is SMTP and what is the name space for that
Add your answer
Q16. Mention few name spaces you have used in your code
Add your answer
Q17. What is WEB API
Add your answer
Q18. Why WEB API is crucial over Web Services
Add your answer
Q19. How do you provide Security to your WEB API
Add your answer
Q20. What is Authentication and Authorization
Add your answer
Q21. What is difference between JSON and XML
Add your answer
Q22. Filters in MVC
Add your answer
Q23. What is MVC
Add your answer
Q24. What is Routing in MVC
Add your answer
Q25. How an application Interact with API
Add your answer
Q26. Architecture of API
Add your answer
Q27. What is HTTP
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

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

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Shortlisted students were divided in group of 19

Selected students from gd got the call for case study round

Q1. Questions were based on the case study and guesstimates
Add your answer
Q2. No. of aeroplane flying in the sky right now
Ans. 
It is impossible to accurately determine the exact number of airplanes flying in the sky at any given moment.
• The number of airplanes in the sky constantly changes due to take-offs, landings, and flights being at different stages.

• Factors such as time of day, weather conditions, and air traffic also affect the number of airplanes in the sky.

• Air traffic control systems may provide estimates of the number of airplanes in a
Answered by AI
Add your answer
Q3. How will u utilise 1 acre of land provided to u near ur college
Ans. 
I would utilize the 1 acre of land near my college for creating a sustainable community garden.
• Establishing vegetable and fruit gardens to promote healthy eating among students

• Setting up a composting area to reduce waste and enrich the soil

• Creating a space for outdoor classes and events to enhance learning and community engagement
Answered by AI
Add your answer
Q4. How to start a starbuck franchisein ur town
Ans. 
To start a Starbucks franchise in your town, you need to follow a specific process set by the company.
• Contact Starbucks corporate office to inquire about franchise opportunities

• Meet the financial requirements and submit a franchise application

• Find a suitable location for the Starbucks store

• Complete the required training and adhere to Starbucks' standards and guidelines
Answered by AI
Add your answer
Q5. Sql extraction of the given table and data
Ans. 
Use SQL query to extract data from a given table
• Use SELECT statement to retrieve data from the table

• Specify the columns you want to retrieve after SELECT

• Use FROM clause to specify the table name

• Add conditions using WHERE clause if needed

• Use ORDER BY clause to sort the results if necessary
Answered by AI
Add your answer

Data Analysis and Automation Testing.

Team work and communication

Q1. Work culture and promotion!!?
Add your answer
Q2. Better Income and study!?
Ans. 
Balancing income and study is possible with proper time management and prioritization.
• Prioritize tasks based on importance and deadlines

• Create a study schedule that fits around work hours

• Utilize breaks at work to study or review material

• Consider part-time study options or online courses

• Seek financial aid or scholarships to alleviate financial burden
Answered by AI
Add your answer
Q3. Work freedom!??
Add your answer

Q1. Face to face communication?
Add your answer
Q2. Discussion?
Add your answer

Q1. Qstn related sql
Add your answer
Q2. Qstn related sqlw
Add your answer

Q1. Question related sql and case studies
Add your answer
Q2. Qstn related sql and case studies
Add your answer

Q1. Salary discussion
Add your answer

Q1. Question related sql and case studies
Add your answer
Q2. SQL and case studies
Add your answer

Q1. Tell me about yourself ?
Add your answer
Q2. What are few major projects that you had in your work ?
Add your answer

Q1. Questions related to your work domain ?
Add your answer
Q2. Any software that you used (Although they will ask opposite of the software you have experience with)
Add your answer