Analyst Interview Questions in Seattle, WA

First, try and reproduce the problem and if the problem could be reproduced acknowledge there was an issue, give thanks for bringing this to the company's attention, and apologize for the customer's encounter with the issue. Offer possible solutions or workarounds while the team worked to correct the issue.

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 :-)

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 :-)

select top 10 percent topsalaries.salary from (select top 10 Salary from Employee order by Salary desc) as topsalaries order by topsalaries.Salary asc

SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 6 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY

Glass door wont let me edit but switch 6 to 10 as shown below SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 10 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY

I only know of select count(*). I think there are other ways.

Can pivot table perform this function?

Can you please list as many technical questions as you remember? I have interview with MS for a similar position and I hope your questions would help me?.

This is when you need to bring up specific school projects and assignments that dealt with problems in a similar way.

I would take the assignment or project and work on it in smaller, more managable portions which would allow me to complete the assignment within the required timeframe. If the assignment or project could not be completed within the required timeframe, it would be my responsibility to raise the issue to coworkers in order to complete the work as required.

QUESTION: What was the skills assessment test about?

The skills test was prescriped on a computer; it covered VBA, MS Excel, MS Access, and SQL

Management is about coping with complexity while leadership is about coping with change (and relationships). Managers bring order and consistency by forming plans, designing organization structures, and assessing result against plans. Leaders establish direction by developing vision of future, they communicate visions and inspire people to overcome hurdles.

Management is about coping with complexity while leadership is about coping with change (and relationships). Managers bring order and consistency by forming plans, designing organization structures, and assessing result against plans. Leaders establish direction by developing vision of future, they communicate visions and inspire people to overcome hurdles.