more-arw search

Q&A Forum

What Are Some Good Business Intelligence Interview Questions and Answers?

Business Intelligence Interview QuestionsI’m in HR at a medium-sized company and am tasked with conducting an initial phone screen of applicants, in this case for the position of BI Analyst.

What would be some good business intel questions to ask? Since it’s not my area, I would like some idea of about what better answers might be as well.

In the past, our organization has struggled with hiring analysts who can both deal with complex data and write reports that are clear, understandable and actionable by decision-makers. Not sure how to screen for this, or if that might be too much for an initial phone interview.

In the past we've asked questions like:

Q. Describe a report you created that led to an important decision by the report recipients?

Q. What BI tools are you proficient with?

Q. Is there anything about dashboards, reporting tools, scorecards, written communication or any other aspect of your work that you are eager to become more proficient with?

Any suggestions would be helpful. Thanks!

Answers

Anonymous
(Agent, JKS Solutions, Inc.) |

Has the hiring manager developed a solid BI job description? If not ask the hiring manager what their needs are, they are the best source of information of how they expect the new employee to blend within their team and what the expectations of the role are including the technology used.

Topic Expert
Malak Kazan
Title: VP, Special Projects
Company: ERI Economic Research Institute
(VP, Special Projects, ERI Economic Research Institute) |

Hope these help....

What is your QA approach to integrating 3rd party data providers? What are some data visualization techniques that have worked for you? How do you adapt a BI solution to keep current with fluid business requirements? Provide example demonstrating your ability to address a difficult or "unreasonable" customer request.

Topic Expert
Keith Perry
Title: Consulting CFO and Business Operations A..
Company: Growth Accelerator
(Consulting CFO and Business Operations Advisor, Growth Accelerator) |

Adding on:
-What statistical modelling tools are you familiar with?
-Please give an example of using statistics to determine a data correlation that was useful to you. How did you use it? What was the impact to the business?

Echoing Valerie:
There are probably some good specifics from the *needs* aspect. Data warehousing? Specific tools? Do they need expertise in gathering / normalizing the data? Determining how and what data to use? Both?

Phyllis Proffer
Title: Owner, Investor Relations Counselor
Company: The Heights Company, LLC
(Owner, Investor Relations Counselor, The Heights Company, LLC) |

In addition to all of the great feedback already provided, asking about the industry in which your company operates could be a good screening mechanisms. I would ask the candidates to describe the current trends compared with historical trends of your industry and evaluate the comprehensiveness of their answers and their ability to communicate what they know. I have used this approach to become familiar with brokerage analysts who are initiating coverage of my company and have gained great insight into how they think and process data.

Topic Expert
Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Did your job posting disclose what BI tools your company uses and the names of the related ERP/CRM systems that may feed data? How important is it that the candidates need to be proficient in those tools?
If you have not selected any BI tools, your filter on tool experience likely needs to be broader for now.

Anonymous
(Manager) |

I would also be interested in the organizational benefit derived from the applicants biz intel efforts.

Ergo, something like, "Please describe a couple of examples where your efforts led to insights and action that benefited your employer."

I believe you can have all of the BI tools available and there are those that pursue their work with great curiosity and those that don't. Maybe some roles don't require much insight, but I haven't seen any yet that weren't benefited by it.

Topic Expert
Keith Perry
Title: Consulting CFO and Business Operations A..
Company: Growth Accelerator
(Consulting CFO and Business Operations Advisor, Growth Accelerator) |

Piling on yet again;
I would tend to be careful to split the "I know Hyperion" from the "I have innate talent" metrics. Knowing a specific tool is nice, and can save hours or even days of training. However...having aptitude is dramatically more important. So, hire for aptitude. Anon's suggestion, "describe examples of influence", is great for getting the thought process of the interviewee. Similarly flip it around and ask:
-"Sales is 5% below forecast (or some other nonsense), describe how you would:
...investigate the root causes
...what tools would help you with that
...build an explanation to staff, execs, etc
...communicate the information?"

Cheers,

KP

Louise Schweitzer
Title: Executive Director
Company: North East Outreach and Support Services
(Executive Director, North East Outreach and Support Services) |

I am looking for excel examples of spreadsheets to use as a test for an interviewee. As well as questions to flush out their knowledge base specific to excel spreadsheets, financial and information based.

133737 views

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.