i was asked about my experience as analyst
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
1 Phyton question about lists
How to simplify a complex pipeline?
What is DDL, DML, DCL?
SQL question but pretty basic.
1. Leadership Principles (Behavioral) i. Describe a time when you had to dive deep to come up with a solution. – Follow-up questions included: Why did you choose that approach? What alternatives did you consider? What was the outcome? 2. Data Visualization i. You’re given a table with 3 columns. How would you visualize it? – What types of visualizations would you use and why? – What would go on the X and Y axes? – What filters would you apply? ii. Now, a fourth column is added to the table. How would your visualization strategy change? iii. Instead of using size for one of the variables in your viz, what if we used different symbols or shapes? Would that be better? Why or why not? iv. Given a sample visualization (image-based question), do you think it’s effective? – Do you notice any errors or misleading design choices? – Would you start the X-axis at 200 instead of 0? Why or why not? 3. SQL i. Write a query to return the top 10 and bottom 10 records based on certain conditions. – This involved CTEs, joins, RANK(), and handling NULLs. ii. Calculate year-over-year churn rate and attrition.
They asked me a question related to JOINs and GROUP BY, where I had to identify the correct type of join to use (in my case, a LEFT JOIN), then a question to perform pivot functionality using CASE statements, a question on self-joins, and a question using window functions. For the case study, they showed a dataset and asked me to identify the main metrics and KPIs, explain the reason behind choosing each, describe the visuals I would use on a dashboard, and explain how I would present them to different audiences, such as technical teams or executives.
How do yoou define a metric , example of a thing which you create
I was asked about try and catch , exception handling
I have given Two Tables, Dimensions, Warehouse Dimensions: ProductID, L,B,H in inches Warehouse:WarehouseID, ProductID, Units Products 1) Write a query to find overall volume of the each product? 2) Write a query to Find out max number of units in each warehouse? 3) Write a query to find the products which doesn’t have any dimensions and not present in Dimensions table?
Viewing 551 - 560 interview questions