235|POWERBI – Ad Analysis

Challenges
, , ,
1

BYU Student Author: @Jacob_Dutton
Reviewers: @James_Gerstner @Andrew_Wilson
Estimated Time to Solve: 20 Minutes

We provide the solution to this challenge using:

  • Power BI

Need a program? Click here.

Overview
You just landed your first job as a data analyst for Ace Marketing! Your team just ran a seven month add campaign for one of your clients, and needs you to help analyze which platform and add template was most successful. Your boss has tasked you with using PowerBI to calculate each of these metrics to compare between the online platforms:

  • Price per redirect
  • Price per lead
  • Price per close

He also wants to see which platform had the most redirects, and which platform/template combo lead to the most redirects. Perform all these calculations in PowerBI and display your findings with appropriate visuals.

Instructions

  1. Load all 3 tables into Power BI
  2. Ensure that each table has the appropriate relationships in the model view.
    a. There should be a 1-to-many relationship between TemplateInfo and PostInfo.
    b. There should be a 1-to-many relationship between SiteInfo and PostInfo.
  3. Create calculated columns and measures
    a. Use DAX to calculate the metrics requested.
  4. Create Visualizations
    a. Add appropriate visuals to the dashboard to show the metrics requested by your boss.

Data Files

Suggestions and Hints

If you get stuck, go look at the PowerBI Learning Path to learn how to create measures and calculated columns.

Solution

Challenge235_Solution.pbix
Solution Video: Challenge 235|POWERBI - Ad Analysis

2

Thanks for the challenge! Make sure to be consistent on ad versus add.

image
image1426×823 36.8 KB

Time to Complete: 40 minutes (much of that was formatting)
Difficulty: Intermediate