Harness the full potential of your advertising campaigns with the Advertising KPI Dashboard in Power BI. This comprehensive dashboard is meticulously designed to consolidate and visualize your advertising data through an intuitive Power BI interface, directly linked with Microsoft Excel. Make informed decisions swiftly and enhance your advertising strategies with real-time insights that drive performance.

Key Features of the Advertising KPI Dashboard

Three Interactive Pages:

Navigate through a Summary Page, KPI Trend Page, and a hidden KPI Definition page, each offering unique insights and functionality.

Summary Page:

Features month and KPI group slicers, performance cards for KPI counts, and a detailed table displaying metrics like KPI Number, Name, Group, Unit, Type, current and previous metrics, and visually impactful icons indicating performance status.

KPI Trend Page:

Visualize trends with combo charts comparing Actual Numbers, Targets for both MTD and YTD, and previous year data. A slicer allows selection by KPI name for focused analysis.

KPI Definition Page:

Accessible through drill-through, this page remains hidden to maintain dashboard cleanliness while providing detailed formulas and definitions as needed.

Excel Integration:

The dashboard pulls data from a structured Excel file comprising three tabs:

Input Actual Sheet:

Where you input actual numbers by KPI, including monthly and yearly data.

Input Target Sheet:

For entering target numbers mirroring the actual sheet structure.

KPI Definition:

Define KPIs by number, group, name, unit, formula, and type, ensuring all stakeholders have a clear understanding of measurement standards and definitions.