Business Intelligence Consultant Interview Questions | Glassdoor

Business Intelligence Consultant Interview Questions

27

Business intelligence consultant interview questions shared by candidates

Top Interview Questions

Sort: Relevance Popular Date

A lot of simple (what SQL Server I worked in the past with) and complicated questions about Transact-SQL, SSIS, SSRS, SSAS, schemes, data types, Business Intelligence, ETL.

1 Answer

I was correct probably in 50% of my answers. The interview ended prematurely.

I was asked what the largest database I worked on was

1 Answer

What are the two types of database indexes? Describe the difference.

What's a cube partitioning strategy you've used in the past? Why?

What variables would you consider for using Multidim vs Tabular mode on SSAS and why?

What are the four steps in the dimensional modeling process?

1 Answer

On technical interview, he asked me what platforms I was working on to do my projects. They won't inform you if you are not selected to the next round, even if you email them to ask.

Tell me about your past project work. What roles did you have? How large were the teams?

Practice making PPT presentations with huge time constraints

110 of 27 Interview Questions