Dashboard creation for marketing KPIs in Digital Marketing - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the best chart type for monthly website visits

You have monthly website visits data for the past year. Which chart type best shows trends over time clearly?

A Pie chart showing percentage of visits per month

B Scatter plot with visits on both axes

C Bar chart with months on the Y-axis and visits on the X-axis

D Line chart showing visits on the Y-axis and months on the X-axis

💡 Hint

Think about which chart type best shows changes over time.

A line chart is best for showing trends over time because it connects data points in order, making it easy to see increases or decreases month to month.

❓ dax_lod_result

intermediate

Calculate total conversions for a specific campaign

Given a table 'CampaignData' with columns 'CampaignName', 'Date', and 'Conversions', what is the total conversions for the campaign named 'Spring Sale'?

Use DAX to create a measure that returns this total.

Digital Marketing

TotalConversionsSpringSale = CALCULATE(SUM(CampaignData[Conversions]), CampaignData[CampaignName] = "Spring Sale")

A TotalConversionsSpringSale = SUM(CampaignData[Conversions])

B TotalConversionsSpringSale = CALCULATE(SUM(CampaignData[Conversions]), CampaignData[CampaignName] = "Spring Sale")

C TotalConversionsSpringSale = CALCULATE(SUM(CampaignData[Conversions]), CampaignData[Date] = "Spring Sale")

D TotalConversionsSpringSale = SUMX(FILTER(CampaignData, CampaignData[CampaignName] = "Spring Sale"), CampaignData[Conversions])

💡 Hint

Use CALCULATE to filter the table by campaign name before summing conversions.

Option B correctly filters the 'CampaignData' table to only rows where 'CampaignName' is 'Spring Sale' and sums the 'Conversions' column. Option B also works but is less efficient. Option B sums all conversions without filtering. Option B filters by date incorrectly.

❓ data_modeling

advanced

Design a data model for multi-channel marketing analysis

You want to analyze marketing performance across channels like Email, Social Media, and Paid Ads. Which data model design is best to support flexible reporting?

A Multiple unrelated tables for metrics, channels, and dates without keys

B Separate tables for each channel with no relationships between them

C A star schema with a fact table for marketing metrics and dimension tables for Channel, Date, and Campaign

D One flat table with all marketing data combined, including channel, date, and metrics columns

💡 Hint

Think about how to organize data for easy filtering and aggregation.

A star schema with a fact table and dimension tables allows flexible slicing and dicing of data by channel, date, and campaign. Flat tables or unrelated tables make reporting harder and less efficient.

🎯 Scenario

advanced

Optimize dashboard performance with large marketing datasets

Your marketing dashboard is slow because it uses a large dataset with daily data for multiple years. What is the best approach to improve performance without losing important insights?

A Aggregate data to monthly level and keep detailed daily data only for the last 3 months

B Keep all data at daily level and add more visuals to spread the load

C Remove all historical data older than one month

D Use only raw data tables without any pre-aggregation or indexing

💡 Hint

Consider balancing detail and performance by summarizing older data.

Option A balances performance and detail by aggregating older data monthly while keeping recent data detailed. Removing all old data loses insights. Keeping all data detailed slows performance. Using raw tables without optimization is inefficient.

🔍 Analysis

expert

Find the error in this DAX measure for calculating ROI

Given the measure below, what error will it cause when used in a report?

ROI = DIVIDE(SUM(Marketing[Revenue]) - SUM(Marketing[Cost]), SUM(Marketing[Cost]))

Digital Marketing

ROI = DIVIDE(SUM(Marketing[Revenue]) - SUM(Marketing[Cost]), SUM(Marketing[Cost]))

A Division by zero error if SUM(Marketing[Cost]) is zero

B No error; the measure calculates ROI correctly

C Syntax error due to missing parentheses

D Type error because SUM cannot be used inside DIVIDE

💡 Hint

Think about what happens if the denominator is zero.

DIVIDE function in DAX handles division safely, but if the denominator SUM(Marketing[Cost]) is zero, it returns blank or error depending on context. The formula itself is syntactically correct. SUM can be used inside DIVIDE. So the main issue is potential division by zero.