Analyst Interview Questions | Glassdoor

# Analyst Interview Questions

"Analysts work in a variety of fields to break down complex problems and find solutions. When interviewing candidates, employers are looking for applicants who have strong analytical and problem-solving skills as well as an in-depth knowledge of the field. For more information on the specific questions you'll be asked, try researching a particular role such as business analyst, financial analyst, programming analyst, or data analyst."

## Top Interview Questions

Sort: RelevancePopular Date

Jan 14, 2010
 How would you perform an application upgrade?1 Answer1. 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.

### Information Security Analyst at Sevatec was asked...

Sep 21, 2015
 That is a SQL buffer Overflow1 AnswerSQL buffer Overflow is a malicious actor trying to inject a SQL code within an SQL command to gain access and flood the connection of the desired attack

Nov 21, 2014
 50,000 shoppers with a 0.5% conversion rate for a chair that costs \$250. Wayfair makes a 27% profit. Next, 50,000 shoppers will get a 10% discount. What is the conversion rate they must achieve to achieve the same profits as before?10 AnswersStep 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 rateThis 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 clarifiedShow More ResponsesNumber 2 is wrong, number 1 is right. Just because revenues equal doesnt mean profits will equal - they sacrifice profits when they decide to give the saleDo they expect you to do this in your head, or will they give you pen/paper and a minute?July 9th Answer is the correct answer. It is not hard: Initial profit is = 50000 * 0.005 * 250 * 0.27 (No need for the calculator yet) After sale profit = 50000 * x * 250 * 0.01 * 0.27 (Still don't need the calc) The question asks for the conversion rate such that profit are the same before and after the sale, so... Initial profit = After Sale profit 50000 * 0.005 * 250 * 0.27 = 50000 * x * (250 - (250 * 0.01)) * 0.27 (divide through & cancel) 0.005 * 250 = x * 225 x = (0.005 * 250) / 225 x = 0.0056 or 0.56%You don't actually need to calculate anything other than the new conversion rate. Why? Look at the equation below: (customer sent = 50000) * (customer bought / customer sent = 0.005 conversion rate) * (revenue / customer bought = 250) * 0.27 (profit / revenue) gives (profit / customer sent). this should be equal to the one after discount. only (revenue / customer bought) changed -> it decreased 10%. therefore, conversion rate needs to increase by (1/0.9), which gives 5.56%.July 9 is correct. Nov 21 is incorrect.July 9 is wrong because the profit margin changes(As sale price changes, but the cost doesn't change)\$250 is the actual cost of the chair (profit not included) or the price listed？？

### Investment Banking Analyst at Cowen Group was asked...

Feb 4, 2010
 Could you walk me through the cash flows statement? What are some items that would be found under each heading?1 AnswerThe cash flows statement shows cash flows from operating, investing and financing activities. In the operating activities area, for example, you would add back depreciation expense to net income (since no cash has actually left your firm). Investing activities could include money from sales of land, and financing could include receiving cash from a loan, or giving out dividends to shareholders.

### QA Analyst at MarkMonitor was asked...

Apr 23, 2014
 Explain the difference between an inner join and outer join.1 Answerknow your SQL.

### Tier I Service Desk Analyst at Bell Techlogix was asked...

Nov 1, 2013
 We simulated a tech support call.1 AnswerI handled the issue, it was more about following a base troubleshooting scenario.

### Budget Management Analyst at TASC was asked...

Apr 27, 2015
 I was asked to explain Pivot tables and Vlookups...1 AnswerBy not laughing. I got asked this excel related in multiple interviews amazingly.

### Underwriting Analyst at MetLife was asked...

Mar 25, 2013
 Please describe a time when you had a conflict with a group member or superior and how could it have been avoided?1 AnswerI took responsibility for my role in the conflict and looked to find common ground with the other party.

### Marketing Analyst at Red Ventures was asked...

Mar 31, 2010
 Determine the maximum amount that we could afford to pay to have a potential customer reach one of our website.1 AnswerStep through a sales funnel's metrics (revenue on a product, all costs associated with the sale, ad click through rates, website call-in rates, conversion rates) to back out the maximum cost to acquire a website visitor.

### Technical Analyst/Project Manager at Sentry Data Systems was asked...

Apr 9, 2010
 How well can you come up to speed working with Ruby and in a custom non-relational database environment?1 AnswerI have a long career in IT necessitating the ability to learn languages and complex applications such as ERP and HRIS quickly. Confident that I can quickly come up to speed.
2130 of 50,056 Interview Questions