Skip to contentSkip to footer

Bi Developer Interview Questions

Salaries
Interviews

4,381 bi developer interview questions shared by candidates

01. How to analyse the Execution Tree of a Query Plan. 02. What are the ideal performance conditions to be taken care with logical reads & physical reads. 03. What are filtered indexes. What are advantages & disadvantages associated with it. 04. What is the prominence of cross apply while using Scalar values and Table valued functions. 05. What are the disadvantages associated with Common Table Expressions. 06. What do you know about the column stored indexes.
avatar

BI Architect

Interviewed at HCLTech

3.5★
May 5, 2015

01. How to analyse the Execution Tree of a Query Plan. 02. What are the ideal performance conditions to be taken care with logical reads & physical reads. 03. What are filtered indexes. What are advantages & disadvantages associated with it. 04. What is the prominence of cross apply while using Scalar values and Table valued functions. 05. What are the disadvantages associated with Common Table Expressions. 06. What do you know about the column stored indexes.

1.How to identify Duplicate Rows in a table 2.how to identify a year from rows 3. About Date functions 4. sort the country column in a way that first two rows should be usa,Canada rest of the rows in alphabetical order(how to write in SQL ,and in power Bi) 5.write a query on how many employs are join in each year 6.In power Bi about filters and how many types of filters 7.About Drill through and Drill down filter 8.when we map visualisation 9.about refresh in power Bi (why we use refresh) 10.how to connect data into SQL 11power Query and Power pivot 12.what is power BI Dashboard 13.how we publish report in power Bi 14. what is Stored Procedures 15.what is VIEW 16. INDEXES why we use in sql
avatar

BI Developer

Interviewed at Accion Labs

4★
Dec 29, 2022

1.How to identify Duplicate Rows in a table 2.how to identify a year from rows 3. About Date functions 4. sort the country column in a way that first two rows should be usa,Canada rest of the rows in alphabetical order(how to write in SQL ,and in power Bi) 5.write a query on how many employs are join in each year 6.In power Bi about filters and how many types of filters 7.About Drill through and Drill down filter 8.when we map visualisation 9.about refresh in power Bi (why we use refresh) 10.how to connect data into SQL 11power Query and Power pivot 12.what is power BI Dashboard 13.how we publish report in power Bi 14. what is Stored Procedures 15.what is VIEW 16. INDEXES why we use in sql

Viewing 2211 - 2220 interview questions

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