What variables would you consider for using Multidim vs Tabular mode on SSAS and why?
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,937 business intelligence analyst interview questions shared by candidates
Can I add a tableau group within group for access?
What's your most impactful work you've done?
What is the difference between right and left joins in SQL
Where do you see yourself in 5 years?
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.
Name as many probability distributions as you can.
The most difficult questions (for me) were about how to use the data Facebook has access to to determine when a particular nation state actor was using the platform to influence another population.
Identify the relationship between two variable.
Some questions to test complex joins of tables and data modelling.
Viewing 701 - 710 interview questions