Business Analyst Interview Questions in Washington State | Glassdoor

# Business Analyst Interview Questions in Washington State

When interviewing a candidate for a business analyst role, employers are looking to assess your analytical problem-solving skills as well as your communication and collaboration skills. Be prepared to analyze a business case study and answer behavioral questions that often test your ability to handle challenging stakeholders or tight deadlines. Business analysts must also be creative thinkers, so expect to tackle a few unusual brainteasers that are designed to see how well you can think through a complex problem.

## Top Interview Questions

Sort: RelevancePopular Date

Feb 8, 2012

Sep 26, 2012
 What would you do if you were told to just reproduce an existing report for requirements? 1 Answerie as a system analyst you need to evaluate the report, determine if there is an existing report that would meet needs, determine what within existing report is used and how to determine what true requirements are

May 20, 2012
 Write an inner join between two tables.3 AnswersMS-SQL lets assume two tables - City and State each having common column called population here is the join on population field Select * from City Inner join State ON city.population = state.population Done :-)MS-SQL lets assume two tables - City and State each having common column called population here is the join on population field Select * from City Inner join State ON city.population = state.population Done :-)another answer. select * from table_A a, table_B a where a.population = b.population; pick one old or new school :-)

Jun 4, 2010
 You have 100grams of gold to distribute evenly among 10 goldsmiths. They are each to make 10 coins of 1 gram each. When you get them back, you know one goldsmith is making coins of 0.9 grams and keeping the rest. Measuring the least amount of times how would you determine which smith is cheating?4 AnswersThe most common answer, and the one I gave, is eliminate half of the smith, then half of the remaining and so on. However, there is a way to determine the culprit by measuring only once.You need only one measurement; together, measure 1 coin from smith A, 2 coins from smith B, 3 coins from smith C,..., and 10 coins from smith J. You know which smith ripped you off by the amount missing; total weight with accurate coins would be 55 grams. For example, if the scale read 54.7 grams you would know that smith C was the culprit since exactly .3 grams were missing (3 coins).You can do this with maximum 3 measurements. Weight 5 coins on each balance and see which one is lighter. So now you know out of which 5 coins you have the culprit. Now again weigh 2 coins on each balance, keeping one left coin with you. If they weight equal, you know the lightest coin is the one in your hand. If not, then you know out of which 2 coins is the lightest one. You can weigh them and see which is the one.Show More ResponsesYou can do this with maximum 3 measurements. Weight 5 coins on each balance and see which one is lighter. So now you know out of which 5 coins you have the culprit. Now again weigh 2 coins on each balance, keeping one left coin with you. If they weight equal, you know the lightest coin is the one in your hand. If not, then you know out of which 2 coins is the lightest one. You can weigh them and see which is the one.

Apr 27, 2012
 You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.4 AnswersSELECT Cust_ID FROM ( SELECT Cust_ID, SUM (Tran_Amt) FROM Order WHERE Order_Date between DATE_SUB( CURDATE() , INTERVAL 1 YEAR) AND CURDATE() GROUP BY (Cust_ID) ORDER BY SUM (Tran_Amt) DESC LIMIT 100) ; PS - I will suggest to replace the function CURDATE() and DATE_SUB( CURDATE() , INTERVAL 1 YEAR) with a date in number format for query performance. I don't think that we will executing the query more often.Select * FROM( Select Cust_id, Year, Totals, RANK() OVER (PARTITION by a.Year ORDER by a.Totals DESC) AS TopLimits FROM ( Select DISTINCT Cust_Id, DatePart(yy,Order_date) AS Year, SUM(Tran_Amt) OVER (Partition by a.Cust_id, DATEPART(yy,a.Order_date)) Totals FROM dbo.[Order] a ) a) b WHERE b.TopLimits <= 100 This is performs the top 100 for all the yearsSELECT TOP 100 Cust_ID, SUM(Tran_Amt) AS Total FROM Order WHERE Order_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 12, Order_Date) ORDER BY Total DESCShow More Responsesselect customer_id from (select customer_id,sum(trans_amt) as a,DATE from orders WHERE Date between DATE_SUB( CURDATE() , INTERVAL 1 Year) AND CURDATE() group by (customer_id) order by (a) DESC LIMIT 100) AS B;

May 20, 2012
 If you have two SQL database tables that are not joined together, how would you create another table to join them. 3 AnswersPretty simple question Lets say we have two tables Person and Other school - each person is student in the school, since you need to join those two tables, you need common column to share and hence forth you find the key to join. Inner Join - join table to bring records common in both the tables Outer Join - Bring results besides the ones that are common or rather bring distingushed results (uncommon) in two tables I'll write here inner join using MS- SQL Question has three part - create another table , join the reults and then populate the reults -- Create the resulting table Create Table Result { string name; } -- Join to table and insert into result table - Assuing two table person and school has common column name INSERT INTO RESULTS --whatever be the join result will populate the result table select name from Person Inner join School -- used inner join here ON person.Name= School.Name -- used the key to join -- now lets pull up the results by querying resut table Select Name from Result -- Questions resolved :-)create new table mean that -> the tables are not connected, they don't have a common column but they complete each other. they have many to many relationship mean that new table will have 2 columns (this is one option :-) ), and the both are they primary keys of both tables, so they will be presenting the both tables, and they will be primary keys and foreign key for the connecting_tables at the same time. so table 1 and table 2 are called the look up tables and the connection_table called the bridge table. so the sql code will look something like that : create table connecting_tables( id_toPresent_1st_table int(12) NOT NULL, // the variable type and length should be the identical to the variable type and length of the primary key in the 1st table id_toPresent_2st_table int(12) NOT NULL, // the variable type and length should be the identical to the variable type and length of the primary key in the 2st table //both are primary keys. PRIMARY KEY(id_toPresent_1st_table, id_toPresent_2st_table), //both are foreign keys. CONSTRAINT fk_table_1 FOREIGN KEY (id_toPresent_1st_table_Id) REFERENCES table_1(table_1_Id), CONSTRAINT fk_table_2 FOREIGN KEY (id_toPresent_2st_table_Id) REFERENCES table_2(table_2_Id) );SELECT A.id,B.id, INTO bridge_table --New table is created FROM A,B WHERE A.id = B.id

Mar 6, 2011

Apr 26, 2012
 Explain a business analysis situation that you faced in your previous job that was most challenging and how did you tackle it and what did you learn and what was your strength to solve it?1 AnswerIt was not difficult...but unexpected.