UBS Lead Business Analyst Interview Questions and Answers

Inner join combines only matching rows from two tables, while outer join includes all rows from one table and only matching rows from the other.

• Inner join only includes rows that have matching values in both tables

• Outer join includes all rows from one table and only matching rows from the other

• Example: Inner join would return only customers who have made a purchase, while outer join would return all customers with thei

Jira software is a project management tool used for tracking issues and managing tasks.

• Jira allows users to create and track issues, assign tasks, and prioritize work.

• Users can customize workflows, create dashboards, and generate reports.

• Integration with other tools like Confluence and Bitbucket is possible.

• Example: Creating a new issue, assigning it to a team member, and tracking its progress.

Performed data analysis, requirement gathering, process improvement, and documentation in past roles.

• Conducted data analysis to identify trends and insights

• Gathered requirements from stakeholders to understand business needs

• Improved processes by identifying inefficiencies and proposing solutions

• Documented findings, requirements, and processes for reference

An order management system to streamline the process of receiving, tracking, and fulfilling customer orders.

• Define user roles and permissions for accessing and managing orders

• Create a user-friendly interface for entering and tracking orders

• Integrate with inventory management system to ensure accurate stock levels

• Automate order processing and notifications to improve efficiency

• Generate reports on order status, sales tre

Data points in an order management system include customer information, order details, payment information, shipping details, and order status.

• Customer information (name, address, contact details)

• Order details (products, quantities, prices)

• Payment information (payment method, transaction ID)

• Shipping details (shipping address, tracking number)

• Order status (pending, processing, shipped, delivered)