Skip to contentSkip to footer

Bi Interview Questions

Salaries
Interviews

4,381 bi interview questions shared by candidates

Why did you apply, why do you think you are a good fit for the role? If you have a table with two columns customer_id and product. The table consists of 300k rows including many duplicates. Which SQL query would remove the duplicates? What aspect of BI do you like the most and least? Describe how a report you built impacted the business? Describe how was (how you managed) your communication with (many) stakeholders? How would you insure data quality before creating a report? How would you insure data quality for a report already in production? How would you implement self serve reporting solutions? How would you insure a company say with 600 people would get the knowledge needed to work independently with each report? Imagine a table or a view that is used by multiple reports, How would you insure the quality of a given table at the warehouse? Do you have questions about the role or the company?
avatar

BI Analyst

Interviewed at LeanIX

4.4★
Feb 2, 2024

Why did you apply, why do you think you are a good fit for the role? If you have a table with two columns customer_id and product. The table consists of 300k rows including many duplicates. Which SQL query would remove the duplicates? What aspect of BI do you like the most and least? Describe how a report you built impacted the business? Describe how was (how you managed) your communication with (many) stakeholders? How would you insure data quality before creating a report? How would you insure data quality for a report already in production? How would you implement self serve reporting solutions? How would you insure a company say with 600 people would get the knowledge needed to work independently with each report? Imagine a table or a view that is used by multiple reports, How would you insure the quality of a given table at the warehouse? Do you have questions about the role or the company?

Viewing 1231 - 1240 interview questions

Glassdoor has 4,381 interview questions and reports from Bi interviews. Prepare for your interview. Get hired. Love your job.