👉SQL Questions–
1. Write a query to fetch the top 5 customers with the highest purchase amounts from a Sales table.
2. How would you identify and count duplicate orders in a table based on multiple columns, such as customer_id and order_date?
3. Write a query to retrieve employee details along with their respective department names and manager names using joins on the Employees and Departments tables.
4. Write a query to calculate the total revenue generated by each product category from an Orders table.
5. Write a query to find the number of days between the order_date and delivery_date for all completed orders.
6. Write a query to find all products whose total sales quantity exceeds 1,000 units, grouped by product ID.
7. Write a query to retrieve all rows where the email column is NULL in a Customers table.
8. Write a query to find gaps in a sequence of numbers in a table.
9. Write a query to find the maximum difference between two consecutive values in a column.
10. How would you identify the median value of a column in a table?
11. Write a query to find overlapping date ranges in a table.
12. Write a query to pivot a table’s data from rows to columns.
13. Write a query to find rows where data in a specific column repeats after a certain number of rows.
👉Power BI Questions–
1. Create a dynamic visual to display the total sales by product category and allow users to filter by region.
2. Write a DAX measure to calculate the year-over-year growth in revenue for each month.
3. Explain the difference between calculated columns and measures with examples related to sales analysis.
4. Explain how to implement Row-Level Security (RLS) to ensure that regional sales managers can only view data for their assigned regions.
5. Write a DAX formula to calculate cumulative sales for each product across the entire sales period.
6. Create a KPI visual to show quarterly revenue growth and flag whether the target has been achieved.
7. Design a custom fiscal date table in Power BI where the fiscal year starts in July.
8. Write a DAX formula to display the top 10 customers by total purchase value in a card visual.
9. Write a DAX formula to calculate the total revenue from repeat customers who placed orders in more than one month.
10. Explain the process to clean data, remove duplicate records, and split a full name column into first and last names.
