Different way of Query Optimization and performance tuning
Business Intelligence Analyst Interviews
Business Intelligence Analyst Interview Questions
"Business intelligence analysts use their analysis of market trends and internal data to recommend where a business can improve profits and reduce expenses. Prepare for your interview by brushing up on your financial math and SQL skills, as well as your knowledge of the company's competitive space. A few years of experience and a degree in business, finance, or computer science is required for this position."
6,924 business intelligence analyst interview questions shared by candidates
Behavioral questions include like how tough things are handled in a project, any deadlines that have been missed, things like that.
How do you price the prime?
Find Top 10 best performing Airline routes based on an scenario.
If we want to know whether people like a product, is there any statistical problems you can see when the analysis is based on their behaviors on the websites? How do you combine text information into our recommendation system? How do you compare models by data visualization?
Questions on the case were technical and required exact answers about the data I would need and the methods I would use.
LeetCode SQL questions
Instance on Quality and standard, Projects from resume, Types of schemas, difference between star and snowflakes schema, What is slowly changing dimension, A real-time schema design, how do you rate yourself in SAS, R, Python and SQL, SaS and R comparison, Which tool should Amazon use, A sql query calcualting rolling average kind of question
1)overfitting ,underfitting etc 2)spss in details 3)sql leet code medium and hard level whiteboard
Describe the system architecture for a recommendation engine based on a customer's previous shopping history.
Viewing 251 - 260 interview questions