Power BI Dashboard Creation for Marketing Data

We are a digital marketing agency seeking a data analyst to create a Power BI dashboard to track the performance of our email and social media campaigns over the past six months. Our goal is to evaluate which campaigns drive the most customer purchases and analyze channel performance over time to fine tune our strategy for the second half of the year.

We want visuals focusing on four key areas: Return on Investment (ROI), Conversion Rates, Audience Engagement, and Channel Performance.
We need someone skilled in structuring data, creating dynamic and insightful Power BI dashboards, and providing clear documentation.

Deliverables:
- A PowerBI desktop file (.pbix) with a professional looking dashboard (ideally 1 page) with:
1. ROI by campaign
2. Conversion rates by channel
3. Audience engagement metrics by campaign
4. Channel performance comparison
- A dashboard creation guide (PDF) with explanations on how the dashboard was created in case we want to replicate something similar in the future.

Ideal Skills:
Proficiency in Power BI
Experience with marketing or campaign data analysis
Strong DAX knowledge for KPIs and calculations
Ability to create clear, engaging, and actionable visuals


Downloadable dataset:
https://github.com/taloc/marketing_campaign_2025/blob/main/marketing_campaign_dataset.csv

To download the file from GitHub:
You may see: “Sorry about that, but we can’t show files that are this big right now.” but don’t worry the data is there.
Click the download raw file button in the upper-right corner of the file preview.
Choose a save location on your device and click "Save."

Compensation: $50