“Simple Pivot Table Analysis of Marketing Analytics Data”

Let’s now try to do a simplest pivoting of marketing analytics row data.
Please find here a raw data file:
PivotTableExerciseDataFile.xlsx.Download PivotTableExerciseDataFile.xlsx.
Then try to create Pivot Table report (remember that pivot tables are actually interactive reports in Excel and also in PowerBI) similar to this PDF solution:
PivotTable-Solution.pdf
Actions
My Additional Hints: you will need to use 2 demographics as your Rows and Amount Spent, Impressions and Clicks as your Columns.
Pivot table data formatting should be similar to Excel VLOOKUP assignment’s one: Currency for Sum of Amount Spent and Number with commas as thousand separator for Sum of Impressions and Sum of Clicks .
Feel free to review again all Excel resources previously mentioned.
Submit Excel file (no PDF)
View Rubric