Advisory Board Business Analyst, Interview Questions

Updated Jun 3, 2015
46 Interview Reviews

Interview Experience

Interview Experience

41%
33%
25%

Getting an Interview

Getting an Interview

85%
7%
4%

Interview Difficulty

2.9
Average

Interview Difficulty

Hard

Average

Easy

46 Candidate Interview Reviews Back to all Interviews

Sort: Popular Date Difficulty

Helpful (1)  

Business Analyst Interview

Anonymous Interview Candidate in Austin, TX
Accepted Offer
Positive Experience
Difficult Interview

Application

I applied online. The process took 4+ weeksinterviewed at Advisory Board (Austin, TX) in May 2015.

Interview

HR round-preliminary SQL question, technical round- resume and SQL again. Onsite interview - 4 panels.. 3:1 and 3 1:1. SQL, brainteasers, project management and client management related questions. Joins, group by, schema creation, normalization, all basic queries. SQL everything !, How do you negotiate? how can you improve process?. board and a marker and you have to write everything, They are very casual and conversational. Overall positive and a well conducted interview. The management is very organized.

Interview Questions

Other Interview Reviews for Advisory Board

  1. Helpful (2)  

    Business Analyst Interview

    Anonymous Employee
    No Offer
    Neutral Experience
    Average Interview

    Application

    I applied through college or university. The process took a weekinterviewed at Advisory Board.

    Interview

    I was contacted for a phone interview and was scheduled within a week. The phone interview was quick lasted 15 minutes the interviewer seemed disinterested throughout the entire process. The questions were straight forward.

    Interview Questions

    • What would you change about your school administration? Describe why you picked your university/college?   Answer Question
  2.  

    Business Analyst Interview

    Anonymous Employee
    No Offer

    Interview

    Email notification requesting interview. Initial phone screening then if you pass you will be invited to interview on location including a case interview. The company usually takes about two weeks between steps to respond back and inform you of your status. Process is fairly straight forward and simple.

    Interview Questions

    • Recruiter will ask questions about your work history so be prepared to answer.   Answer Question
  3. Helpful (5)  

    Business Analyst Interview

    Anonymous Employee in Austin, TX
    No Offer
    Negative Experience
    Average Interview

    Application

    I applied online. The process took 2+ monthsinterviewed at Advisory Board (Austin, TX) in October 2014.

    Interview

    The whole process took 2 months. I got the first HR phone screening after submit my application through LinkedIn. Easy, basic question. After 1 months, I received another 45min technical interview. High-level SQL questions and some behavioral questions. After 1 week, I got the on-site interview invitation. The final day is 4 rounds, back to back, which is similar, and quite exhausting. I have to know how to write SQL query. I'm nervous so made some mistakes. They will judge you from PM/ Client Management/ Technical. But I'm pretty sure they do not hire anyone without SQL experience.

    Interview Questions

    • What's wrong with this table? How to decide which are the top 3 fastest horses.   Answer Question
  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


  5. Helpful (1)  

    Business Analyst Interview

    Anonymous Employee in Austin, TX
    No Offer
    Easy Interview

    Application

    I applied through a recruiter – interviewed at Advisory Board (Austin, TX) in August 2014.

    Interview

    For the first interview, I was asked standard questions (script-like, if you will) in an effort to allow me to market my skill set and work experience as best I could. It lasted just under 20 mins and the interviewer took notes the whole time, but didn't really deviate from the likely prepared set of questions. No off-the-wall queries.

    Interview Questions

    • Why do you want to leave your current industry to join health care?   Answer Question
    • How would you deliver bad news to someone?   Answer Question
    • How do you keep track of everything that's on your plate to ensure you remember to do them?   Answer Question
  6.  

    Business Analyst Interview

    Anonymous Employee
    No Offer
    Neutral Experience
    Easy Interview

    Application

    I applied online. The process took 4 weeksinterviewed at Advisory Board in July 2014.

    Interview

    This was a phone interview. They were focused on my SQL skills and if I would be a good fit for the social good aspects of the company. The phone interview was pleasant enough. There were high level technical questions but nothing too deep, leaving that for the second round interview. The other items on my resume didn't seem to be of key interest. I got the feeling that they were looking for data mappers more than anything else.

    Interview Questions

  7. Helpful (12)  

    Business Analyst Interview

    Anonymous Interview Candidate in Austin, TX
    Accepted Offer
    Neutral Experience
    Average Interview

    Application

    I applied through an employee referral. The process took 4+ weeksinterviewed at Advisory Board (Austin, TX).

    Interview

    I had my personal friend submit my resume. I got a call 2 weeks later from the recruiter. They then to a 1 hour phone screening interview. They have targeted questions to determine experience level and pre-qualify you for the next round. If the recruiter liked your answers then within the next 2 weeks you will get a call from a Sr. Director, Director or a Manager and they will repeat the process again but be more specific. This will be another 1 hour screening call. Then if you have passed the 2 screening calls within 1 week after the last call they will schedule you for a 3 hour block of physical interviews in the office. Each hour you will meet with either 1 person or a team and they will put you through the interview process of similar questions. After the 3 hours you will be exhausted. Some interviewer might ask you to demonstrate your SQL knowledge by writing out a script.or ask you to do coding. The 1st key...they must like you.. I have seen people who were too confident come across as arrogant and the team did not like the person so he was rejected. The 2nd key...you must know what you what you claim you can do. They will call you out on subjects and ask you to prove it. The final key...ask questions and then ask more questions and then ask even more questions. They want you to be hungry for the position. Make sure the questions are relevant. People that ask zero questions do not get hired! Don't talk about salary or benefits (wait for the offer to discuss/finalize it).

    Interview Questions

    • They like to through people off the track by asking "vague" questions in the middle of an interview to make sure the person is being real and not robotic. Examples - 1. What do you do during your time away from work? 2. What hobbies do you do? 3. What is your driving motivation to do something? 4. What is the greatest accomplishment you have done in your life (outside of graduating from school)?   2 Answers

    Negotiation

    During the offer phase is when you negotiate. What ever salary you agree to...your annual bump in salary will only be 3% to 4% most of the time. So negotiate the best salary for you.

  8.  

    Business Analyst Interview

    Anonymous Employee
    No Offer

    Interview

    HR made an appointment for a phone interview and started going down the list of questions automatically. The person had no interest, or maybe lacked experience in actually interviewing a person. Not sure they even took any notes along the interview. After 20 minutes she ended the conversation abruptly.

    Interview Questions

  9.  

    Business Analyst Interview

    Anonymous Employee
    No Offer
    Neutral Experience

    Application

    I applied online. The process took 2+ monthsinterviewed at Advisory Board.

    Interview

    I had submitted my resume online a couple months ago. About 2 months later I was contacted and asked to set up an interview with the recruiter. Phone interview with the recruiter lasted for 20-30 min. General questions about experience, reviewed resume and why I would like to work at Advisory Board.

    Interview Questions

    • How have you used large amounts of data to make an informed decision?   Answer Question
  10. Helpful (1)  

    Business Analyst Interview

    Anonymous Employee in Washington, DC
    No Offer
    Positive Experience
    Easy Interview

    Application

    I applied online. The process took 1 dayinterviewed at Advisory Board (Washington, DC).

    Interview

    I got a call for the interview of a business analyst position after applying via LinkedIn. Fairly simple interview strictly behavioural. It was hard to understand what they expected out of a candidate as the position seemed rather vague. Overall the interview was quite easy and stuck to situation questions.

    Interview Questions

    • Many questions were being repeated, the interviewer kept asking certain facts on my resume which was a little confusing. As far as technical skills were concerned, they did not mention what was required to be a good fit for the position.   Answer Question
Don't Miss Out On a Job You Love
Upload a resume to easily apply to jobs from anywhere. It's simple to set up.

The difficulty rating is the average interview difficulty rating across all interview candidates.

The interview experience is the percentage of all interview candidates that said their interview experience was positive, neutral, or negative.

Your response will be removed from the review – this cannot be undone.