Cosmopolitan Industries Privet Assistant Manager Business Analyst Interview Questions and Answers

Basic Aptitude, time and distance, time and work, basic class 10 maths

Q1. Guesstimate - detergent used in hospital in a day
Add your answer
Q2. Position of responsibility
Ans. 
I have held multiple positions of responsibility in my previous roles, including leading project teams and managing client relationships.
• Led a project team to successfully implement a new software system

• Managed client relationships and ensured customer satisfaction

• Served as a mentor to junior team members and provided guidance on complex projects
Answered by AI
Add your answer

Q1. Guestimate - flights in mumbai airport in a day
Add your answer
Q2. What is that makes you a suitable candidate and why EXL
Ans. 
I am a suitable candidate for the Business analyst role at EXL due to my strong analytical skills, experience in data analysis, and ability to drive business insights.
• I have a strong background in data analysis and have successfully implemented data-driven strategies in my previous roles.

• I possess excellent analytical skills which enable me to interpret complex data and provide valuable insights for decision-making.

• I h...read more
Answered by AI
Add your answer

Q1. Sql round basic to advance questions in star format answer
Add your answer

Q1. Sql python and dashboard then amazon leadership questions
Add your answer

Q1. About previous project
Add your answer
Q2. Python code and some sql quries
Add your answer

Sql and business metrics designing

Q1. Tell me a business problem that you solved
Ans. 
Implemented a data analytics solution to optimize inventory management and reduce costs
• Identified key factors affecting inventory levels and costs

• Developed a predictive model to forecast demand and optimize ordering quantities

• Implemented a dashboard for real-time monitoring of inventory levels and performance

• Collaborated with cross-functional teams to ensure successful implementation
Answered by AI
Add your answer
Q2. Youtube wants to open a new office, what factors would h consider
Ans. 
Factors to consider when opening a new office for Youtube
• Location - proximity to talent pool, access to transportation

• Cost - real estate prices, taxes, cost of living

• Market - target audience, competition in the area

• Infrastructure - availability of utilities, internet connectivity

• Regulations - local laws, permits required
Answered by AI
Add your answer

Q1. Problem situation given and what metrics would you design around it
Add your answer

Good and got time to keep my point

Q1. What is your weakness
Add your answer
Q2. How well you know python
Ans. 
I have a strong understanding of Python and have used it extensively in my previous projects.
• Proficient in Python programming language

• Experience in using Python for data analysis and visualization

• Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib

• Have developed scripts and automation tools using Python
Answered by AI
Add your answer

Q1. Use cases - Precondition and postcondition
Add your answer
Q2. Jira tool and explain
Ans. 
Jira is a project management tool used for tracking and managing tasks, issues, and workflows.
• Jira is commonly used in software development teams to track bugs, tasks, and user stories.

• It allows for creating and assigning tasks, setting priorities, and tracking progress.

• Jira integrates with other tools like Confluence and Bitbucket for seamless project management.

• Users can create custom workflows, dashboards, and repor
Answered by AI
Add your answer

Great one really enjoyed the process.

Q1. Why we should hire you?
Add your answer
Q2. What is your strength & weakness?
Add your answer

Q1. SQL joins inner join, outer join and left join
Add your answer
Q2. It was about window function , like we have to use row_number.....don't remberer exact question
Add your answer