"Employers are looking for business intelligence managers with advanced problem-solving and analytical skills, in-depth knowledge of industry practices, and sufficient leadership experience to utilize data to provide solutions for business strategies to the company. When interviewing for this position, you may be asked about your experience with prior leadership positions, understanding of data management software, and knowledge of the industry you will be working in."
The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?".
It's a great question but analogous to asking, "What's the best house or the best car?". The answer depends on several factors. I'd start with requirements and budget and discuss what is possible within those parameters. If you watch "Property Virgins" on HGTV, the educational process is similar, as are the "buyers" perceptions.