Junior Intelligence Analyst Interview Questions

5,627 junior intelligence analyst interview questions shared by candidates

There were 4 SQL questions that were explained using a sample data set if two tables (transaction table and dimension table) first two were easy aggregations and the last two required correlated subqueries: calculate average time pertaining to all calls made to leads and the last one was to find ratio of leads vs non lead calls. These were great to test the concepts pertinent to SQL querying.
avatar

Business Intelligence Analyst

Interviewed at Ultimate Medical Academy

3.8
Mar 17, 2022

There were 4 SQL questions that were explained using a sample data set if two tables (transaction table and dimension table) first two were easy aggregations and the last two required correlated subqueries: calculate average time pertaining to all calls made to leads and the last one was to find ratio of leads vs non lead calls. These were great to test the concepts pertinent to SQL querying.

Viewing 691 - 700 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 5,627 interview questions and reports from Junior intelligence analyst interviews. Prepare for your interview. Get hired. Love your job.