1) For an e-commerce company, you need to show the percentage change in monthly website traffic compared to the previous month. Which DAX calculation is most suitable?
2) You are tasked with analyzing customer feedback data collected from surveys. The dataset includes customer ID, feedback score (1-5), and comments. How would you visualize the average feedback score by product category?**
3) Your sales team wants to track the performance of their campaigns over different time frames (monthly, quarterly, and annually). How would you set up your Power BI report to enable this flexibility?**
4) A client wants to understand the correlation between ad spend and sales revenue. You have two separate datasets: one for advertising expenses and another for sales revenue. What is the best approach to analyze this relationship?**
5) You are developing a report for a project management team to track project timelines. Each project has a start date, end date, and status (e.g., completed, in progress, delayed). How would you highlight delayed projects in your report?**
6) An HR department wants to analyze employee turnover rates. The dataset includes hire dates, termination dates, and employee IDs. What DAX measure would you create to calculate the turnover rate for a specific year?**
7) You need to create a financial dashboard for stakeholders that highlights monthly expenses versus revenue. What type of visual would best convey this comparison over time?**
8) You are tasked with reporting customer retention rates based on purchase history. The data includes customer ID, purchase dates, and total purchases. What measure would you use to define a retained customer?**
9) A manufacturing company wants to visualize defects in their products across different production lines. The dataset includes defect types, counts, and production line IDs. Which visualization would best help identify problem areas?**
10) A retailer wants to analyze sales trends across different seasons. The dataset includes sales data with timestamps. How would you best structure your report to show seasonal trends effectively?**
11) You are developing a customer segmentation report for a marketing team based on purchase behavior. The dataset includes customer demographics and purchase frequencies. What DAX measure would help categorize customers into segments like "frequent," "occasional," and "rare"?**
12) A logistics company wants to optimize delivery routes based on time and distance. The dataset includes delivery times and distances for various routes. How would you approach creating a visualization to analyze this?**
13) Your marketing team wants to evaluate the performance of their email campaigns. The dataset includes open rates, click-through rates, and conversion rates. What type of visualization would best summarize these metrics?**
14) An organization wants to analyze its supply chain data to identify potential bottlenecks. The dataset includes lead times, order quantities, and supplier performance metrics. What is the best way to visualize this information?**
15) A non-profit organization wants to visualize donations received over the years to track trends and growth. The dataset includes donation amounts and dates. What type of visual would best represent this data over time?**
16) You need to analyze the performance of various products in an e-commerce platform. The dataset includes product IDs, sales amounts, and return rates. What DAX measure would you create to identify products with high return rates?**
17) A customer service department wants to visualize the average response time for support tickets over the last year. The dataset includes ticket creation and resolution timestamps. What DAX measure would you use to calculate the average response time?**
18) A healthcare provider wants to analyze patient visits to different departments. The dataset includes patient IDs, visit dates, and department names. How would you visualize the number of visits by department?**
19) You are working on a sales report that needs to show sales performance by region. The dataset includes sales amounts and regions. What visual would effectively communicate this data to stakeholders?**
20) An educational institution wants to analyze student performance based on grades across different subjects. The dataset includes student IDs, subject names, and grades. What DAX measure would you use to calculate the average grade for each subject?**
