𝐃𝐢𝐬𝐜𝐮𝐬𝐬𝐢𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐬𝐜𝐞𝐧𝐚𝐫𝐢𝐨 𝐛𝐚𝐬𝐞𝐝 𝐪𝐮𝐞𝐬𝐭𝐢𝐨𝐧 💡

𝑺𝒄𝒆𝒏𝒂𝒓𝒊𝒐 👇
You are a data analyst for a global e-commerce company. You need to analyze the performance of your marketing campaigns across different regions and identify which campaigns have the highest return on investment (ROI). Additionally, you want to see how customer acquisition costs (CAC) vary by region and campaign.

𝑸𝒖𝒆𝒔𝒕𝒊𝒐𝒏 👇
How would you use Power BI to create a comprehensive report on marketing campaign performance and ROI analysis?

𝑨𝒏𝒔𝒘𝒆𝒓:
For this we are provided with three datasets:

𝐂𝐚𝐦𝐩𝐚𝐢𝐠𝐧𝐬: CampaignID, CampaignName, Region, StartDate, EndDate, Budget
𝐒𝐚𝐥𝐞𝐬: SaleID, CampaignID, SaleAmount, SaleDate
𝐄𝐱𝐩𝐞𝐧𝐬𝐞𝐬: ExpenseID, CampaignID, ExpenseAmount, ExpenseDate

▶ 𝑺𝒕𝒆𝒑 1: Analyze the dataset thoroughly and perform some data cleaning and transformation steps 📈

▶ 𝑺𝒕𝒆𝒑 2: Create Measures that are required in accordance with scenario given.

Total Sales = SUM(Sales[SaleAmount])
Total Expenses = SUM(Expenses[ExpenseAmount])
ROI = DIVIDE([Total Sales] - [Total Expenses], [Total Expenses])
Customer Acquisition Cost (CAC): CAC = DIVIDE([Total Expenses], DISTINCTCOUNT(Sales[SaleID]))

▶ 𝑺𝒕𝒆𝒑 3: Use appropriate filters and visuals according to your requirements. You may use clustered column chart for CAC by region, line chart for sales and expense trends, can add slicers for region, campaign name, and date range, etc.

▶ 𝑺𝒕𝒆𝒑 4: Analyze the project for some informative insights and trends.

I have curated the best interview resources to crack Power BI Interviews 👇👇
https://topmate.io/analyst/866125

Like this post if you need more resources like this 👍❤️