Business Analyst Interview Questions

I would explain to the stakeholder that the purpose of the Business Requirements elicitation meeting was designed to identify the business need not to design the solution.

Great answer and exactly right!

nice!!

1. Review documentation/ release notes. 2. List/ Review the steps in the upgrade. 3. Get the other parties involved to set aside time. 4. Then I would look at the media, and take any backups if needed. 5. I would set up a time which i would communicate to the users asking them to stay out of the system. 6. Complete the upgrade 7. Communicate with the users that it is ok to log back in to the system.

A functional requirement is the what; a system requirement is the how.

A functional requirement is what the system should do. It is what function is wanted. Non functional is how that is achieved. It specifies how that system should work.

A functional requirement describes the observable behavior of a system. It describes how the work should be done. A system requirement describes the needs of the system (computer) to be able to use the software or hardware. Some examples of functional requirement are “user must be able to login to their account” “user must be able retrieve password”. Some examples of system requirements are “the system must be able to operate in windows and Mac operating systems”

An average in which each quantity to be averaged is assigned a weight. These weightings determine the relative importance of each quantity on the average. Weightings are the equivalent of having that many like items with the same value involved in the average.

Step 1: Calculate profit (250 * 250 * 0.27 = 16875) Step 2: Calculate discount price (250 * 0.9 = 225) Step 3: Calculate price of chair (250 * 0.73 = 182.5) Step 4: Calculate profit margin ( (225 - 182.5)/225 = .19) Step 5: Calculate new conversion rate (225 * 0.19 * x = 16875) x = 395 395/50000 = 0.79% the new conversion rate

This is incorrect Old revenue = 50000*250*.005=250*250 New revenue with conversion rate r% = 50000*r*250*.9 = old revenue = 250*250 r = .55%

Scenario 1 Number of sales=50,000*.5/100 = 250. Revenue=250*250 = 62,500. Profit is 27%. Therefore 62,500 = 1.27*cost Therefore cost = 49,212.598. Profit = 62,500-49212.598 = 13,287.40. Cost of chair = 250/1.27 = 196.85 Scenario 2 Number of sales = 50,000*r/100 = 500*r (r is new converion rate) Revenue = 500*r*.9*250 Total cost = 500*r*196.85 Profit = 500*r(250*.9-196.85) = 13,287.40 500*r*(28.1496) = 13,287.40. Therefore r = 0.944. The first answer considers profit as margin (percentage of sales) which seems incorrect or needs to be clarified

I described a simple statement: Select (Name all columns from tables or use * for all) From (table name(s)) Where (any conditions, join statements ect) Group By / Order By to sort or aggregate the data

SELECT for which columns to include in the result, (tables must be present in the FROM clause), can also include aggregates like COUNT(), SUM(), AVG() FROM for which tables to select rows/attributes from WHERE which is used to filter rows based on a given criteria with comparisons (=, !=, , and keywords LIKE and BETWEEN), INNER JOIN and LEFT/RIGHT OUTER JOIN to combine data across multiple tables ORDER BY DESC/ASC to specify ordering of a specific column name GROUP BY to group data based on the tables passed HAVING to filter rows based on an aggregate used in the SELECT statement that cannot be used with the WHERE clause

Inner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the Key

Specified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table.