Analyste Bi Senior Interview Questions

114 analyste bi senior interview questions shared by candidates

1. Difference between SRS and BRS. 2. If the static report is needed to send to 200 customers, how you will send it. 3. Which connection would you prefer if we have 90 GB of Data? 4. If you have data in MS SQL Server, Oracle and in excel sheet. Tell me the exact process from beginning till the end of the visualization. - I told him that first, we will extract the required information, he said - Where? I told, for example, Informatica - He said it is worth a crore tool - !! So the question is real, that where? 5. Consider a scenario, if we have 90 or more GB of data, and in the table there is no data or time field and there has been some modification in the data, like in terms of sales a week back a salesman said he sold 200 pieces and later he recognise that there was a typo error. How would you deal with such a scenario? Would you run the whole extract again or what would you do? 6. Tell me your approach of working when you first meet a client. 7. How would you make it a surety that the dashboard you provided to the client is 100% as per their requirement? 8. He also asked some question regarding the tableau prep. 9. During extract how much is the compression ratio?
avatar

Senior BI Analyst

Interviewed at Corporate Renaissance Group

3
Jul 18, 2018

1. Difference between SRS and BRS. 2. If the static report is needed to send to 200 customers, how you will send it. 3. Which connection would you prefer if we have 90 GB of Data? 4. If you have data in MS SQL Server, Oracle and in excel sheet. Tell me the exact process from beginning till the end of the visualization. - I told him that first, we will extract the required information, he said - Where? I told, for example, Informatica - He said it is worth a crore tool - !! So the question is real, that where? 5. Consider a scenario, if we have 90 or more GB of data, and in the table there is no data or time field and there has been some modification in the data, like in terms of sales a week back a salesman said he sold 200 pieces and later he recognise that there was a typo error. How would you deal with such a scenario? Would you run the whole extract again or what would you do? 6. Tell me your approach of working when you first meet a client. 7. How would you make it a surety that the dashboard you provided to the client is 100% as per their requirement? 8. He also asked some question regarding the tableau prep. 9. During extract how much is the compression ratio?

Viewing 21 - 30 interview questions

Glassdoor has 114 interview questions and reports from Analyste bi senior interviews. Prepare for your interview. Get hired. Love your job.