SQL Questions–
1.Write a query to find the top 3 departments with the highest total salaries from an Employees table.
2.Write a query to find customers who have placed orders totaling more than ₹50,000 in the last 60 days.
3.Write a query to retrieve the first and most recent transaction date for each customer in the Transactions table.
4.Write a query to fetch all orders placed during public holidays from the Orders table.
5.Write a query to calculate total revenue generated per product category in the Sales table.
6.Write a query to find the third highest salary in the Employees table without using LIMIT, TOP, or OFFSET.
7.Write a query to find customers who have never placed an order using a LEFT JOIN between the Customers and Orders tables.
8.Write a query to identify the best-selling product in each region based on order quantity.
9.Write a query to calculate the discount percentage for each order and rank them within their category.
10.Write a query to find orders where the total order value is greater than the 75th percentile of all order values.
Power BI Questions–
1.How would you design a Power BI dashboard to visualize customer churn trends?
2.Write a DAX measure to calculate year-over-year revenue growth.
3.Create a DAX measure to compute running total sales for a selected time period.
4.Explain how to implement dynamic filtering in Power BI using slicers and parameters.
5.Write a DAX formula to categorize customers into High, Medium, and Low spenders based on their total purchase value.
6.How would you restrict data access in Power BI using Row-Level Security (RLS) based on a user’s department?
7.How do you highlight low-performing products dynamically in a Power BI report?
8.Explain the process of creating a Power BI Dataflow for consolidating sales data from multiple sources.
9.What are some best practices for improving Power BI report performance and refresh speed?
10.Demonstrate how you would use Power Query to:
11.Remove duplicate records from a dataset.
12.Split a single column into multiple columns based on a delimiter.
13.Merge two datasets with different primary keys.
Behavioral & Scenario-Based Questions–
1.Describe a time when you built a data pipeline that improved reporting accuracy.
2.Share an experience where your data analysis led to a major business decision.
3.How do you handle conflicting priorities when managing multiple analytics projects?
4.Have you encountered inconsistent data across multiple sources? How did you resolve the issue?5.How do you communicate technical insights to non-technical stakeholders?
