Business Intelligence Consultant Interview Preparation Guide

Download PDF

Emotional intelligence, or EQ, has come into vogue as a good trait to hire for.

EQ is the ability to use emotional information to guide thinking and behavior, to recognize other people's emotions and your own, and to discriminate between different feelings and label them appropriately.

EQ is considered essential to help teams function well. Here are some of the top questions for help you get an idea of how candidates perceive their emotions and those of others.

1. If you started a company today, what would its top values be?

2. Who inspires you? Why?

3. How could you create more balance in your life?

4. What makes you angry?

5. How do you have fun?

6. How good are you at asking for help?

7. How did you deal with a bad day?

8. What's something you're really proud of? Why?

9. Tell me about a time when your mood altered your performance (positively or negatively).

10. Has there ever been a time when you felt you needed to change your behavior at work? How did you do it?

11. Did you create friendships that lasted while working at a previous job?

This question typically follows on from the previous one. Here is where your research will come in handy. You may want to say that you want to work for a company that is Global Guideline, (market leader, innovator, provides a vital service, whatever it may be). Put some thought into this beforehand, be specific, and link the company’s values and mission statement to your own goals and career plans.

This is another opportunity to show the interviewer what you're capable of so make sure to be prepared for this type of question. Have an example ready and make sure its an example of a suggestion you've made that was accepted and that have positive influence. If you can come up with an example that relates to the position you're applying for that would be even better.

Try to talk about a book related to the industry, for example, if you're applying for a role related to business, cite a business book.

Nothing says “hire me” better than a track record of achieving amazing results in past jobs As Business Intelligence Consultant, so don't be shy when answering this interview question! A great way to do so is by using the S-T-A-R method: Set up the situation and the task that you were required to complete to provide the interviewer with background context (e.g., “In my last job as a Business Intelligence Consultant, it was my role to manage the invoicing process”), but spend the bulk of your time describing what you actually did (the action) and what you achieved (the result). For example, “In one month, I streamlined the process, which saved my group 10 man-hours each month and reduced errors on invoices by 25%.”

First of all, be honest (remember, if you get this job, the hiring manager will be calling your former bosses and co-workers!). Then, try to pull out strengths and traits you haven't discussed in other aspects of the interview As Business Intelligence Consultant, such as your strong work ethic or your willingness to pitch in on other projects when needed.

For most jobs, communication skills As Business Intelligence Consultant are important. It's hard to work as a team if people aren't communicating well.

At some jobs, like customer service or sales, communication skills are an absolute essential.

These questions are meant to help gauge a candidate's ability to communicate.

1. How do you prefer to build rapport with others?

2. How would you go about simplifying a complex issue in order to explain it to a client or colleague?

3. How would you go about persuading someone to see things your way at work?

4. How would you go about explaining a complex idea/problem to a client who was already frustrated?

5. What would you do if you there was a breakdown in communication at work?

6. Talk about a successful presentation you gave and why you think it did well.

7. How would you explain a complicated technical problem to a colleague with less technical understanding?

8. Do you prefer written or verbal communication As Business Intelligence Consultant?

9. Describe a time when you had to be careful talking about sensitive information. How did you do it?

10. What would you do if you misunderstood an important communication on the job?

11. Talk about a time when you made a point that you knew your colleagues would be resistant to.

12. Is it more important to be a good listener or a good communicator As Business Intelligence Consultant?

13. Tell me about a time you had to relay bad news to a client or colleague.

14. Rate your communication skills on a scale of 1 to 10. Give examples of experiences that demonstrate the rating is accurate.

15. How have you handled working under someone you felt was not good at communicating?

Bad Answer: Going negative - if the candidate starts trash talking other candidates, it's a sure sign of a bad attitude. Also, if they can't provide a solid answer, it may show that they lack thorough knowledge of the skills the job requires, and an understanding of where they fit in.

Good answer: The candidate can name specific skills, abilities or understandings they have that apply directly to the job that other candidates are unlikely to have, or are in short supply.

Be completely honest and thoughtful with this one. You don't want to wake up one to find out that you're moving to a new city or state and it may be a major factor in your eligibility for employment. But again, if you don't want to move then the job probably isn't for you.

There may be several good answers. Some include: you're able to set realistic, yet aggressive goals that push you and you're able to achieve them, you go the extra mile on all projects, client satisfaction is high, your boss is elated at your performance on all projects, etc.

This is a great question that provides you the opportunity to put your best foot forward, to tell the interviewer why he or she should consider hiring you for the job. Make sure you're well prepared for this question as you won't likely get a second chance to really shine.

Candidates without specific examples often do not seem credible. However, the example shared should be fairly inconsequential, unintentional, and a learned lesson should be gleaned from it. Moving ahead without group assistance while assigned to a group project meant to be collaborative is a good example.

Be completely honest. You don't want to lie to get the job if you're not going to work the hours required.

Before you answer, consider how you best contribute to a team:

☛ Do you get along easily with people?
☛ Are you an effective collaborator?
☛ Can you communicate with people from various backgrounds and with different personalities?
☛ Can you motivate people?
☛ Do you know how to push back tactfully?
☛ Can you mediate conflicts?
☛ Can you deal with difficult personalities?

We all have difficult decisions in our lives. Show how you were able to arrive at it and then how you decisively acted.

Try to avoid specific classifications, whatever it may be. Organizations usually prefer managers who can adapt their skills to different situations.

This is a great opportunity for you to discuss how you've given back to the community, how you've achieved in a competitive extracurricular activity (think sports or clubs), how you've mentored others, and so forth.

I would explain and show to him or her best way possible and if they have a better way then I will encourage him or her to let me know then we can see if it works or not As Business Intelligence Consultant.

If you were unemployed for a period of time, be direct and to the point about what you’ve been up to (and hopefully, that’s a litany of impressive volunteer and other mind-enriching activities, like blogging or taking classes). Then, steer the conversation toward how you will do the job and contribute to the organization: “I decided to take a break at the time, but today I’m ready to contribute to this organization in the following ways.”

Brainteaser questions As Business Intelligence Consultant have become popular for interviews in recent years, as word has gotten out that top tech companies such as Apple, Google, Microsoft and IBM have used this type of question at one time or another.

Companies like Google aren't using these questions so much any more, but many companies, are, and it may be good to prepare for them As Business Intelligence Consultant. The key to these isn't so much getting the exact answer, as it is showing how you would come up with an answer.

Here's a sample of 12 of the best and most difficult.

1. How many street lights are there in New York City?

2. How many gas stations are there in the United States?

3. How many golf balls can fit in a school bus?

4. How much should you charge to wash all the windows in Seattle?

5. Why are manhole covers round?

6. How many times a day does a clock's hands overlap?

7. How would you test a calculator?

8. Describe the internet to someone who just woke up from a 30-year coma.

9. How much does the Starbucks in Times Square bring in, in annual revenue?

10. You are shrunk to the height of a nickel and thrown into a blender. Your mass is reduced so that your density is the same as usual. The blades start moving in 60 seconds. What do you do?

11. What is the air speed velocity of an unladen swallow? ;)

12. How many golf balls are there in Florida?

This would be the first question asked in any interview. Therefore, it is important that you give a proper reply to the question regarding your education. You should have all the documents and certificates pertaining to your education and/or training, although time may not allow the interviewer to review all of them.

Provide several reasons including skills, experience and interest. If you can show how you've been successful in a similar career field or job position that will go along way to helping the interviewer believe you'll also be successful at this new job.

There should be many times where you've assisted others As Business Intelligence Consultant. If you haven't, think of how you would in the future. You can discuss charitable causes, how you mentored someone, and so on.

Think back to the classes that either resonated with your passion or truly helped you to develop skills that you believe will help you in your career. Talk about those.

Without a doubt, social media is becoming more and more pervasive in our jobs. You should stress that social media is not appropriate for personal use at work. However, if the company embraces social media in certain departments (for example marketing), then you may want to discuss how you could use it for work (as long as it applies to your role).

Answer this as positively as possible and try to avoid disparaging the company you had previously worked for. The key is to accept the fact that yes, you were fired, but you've learned from the mistakes that got you there and you're better now because of it. If you haven't been fired, well, then this question's a piece of cake isn't it?

When I was in college, I took an art class to supplement my curriculum. I didn't take it very seriously, and assumed that, compared to my Engineering classes, it would be a walk in the park. My failing grades at midterm showed me otherwise. I'd even jeopardized my scholarship status. I knew I had to get my act together. I spent the rest of the semester making up for it, ended up getting a decent grade in the class. I learned that no matter what I'm doing, I should strive to do it to the best of my ability. Otherwise, it's not worth doing at all.

Show how you were able to over the "overwhelmed" feeling - by delegating tasks, getting people on your team to help you out, or by prioritizing your work and focusing on the most important issues first As Business Intelligence Consultant.

This depends on the job role. Make sure you break it down into

Think of which personalities you work best with (do you like outgoing, collaborative, personable working relationships and so forth?)