Course Overview

In this edition, you’ll create a Marketing KPI Scorecard tailored for a logistics company. You’ll work with marketing campaign data — including lead generation, conversion rates, cost per acquisition, and ROI — to design a Power BI scorecard that measures campaign effectiveness, tracks customer acquisition costs, and evaluates overall marketing performance in the logistics sector.

Pre-requisites

• Optional - Basic Excel knowledge (data entry, formatting, basic formulas).
• No prior Power BI experience required.
• Familiarity with basic marketing concepts (CTR, conversion rate, ROI) is helpful but not mandatory.

Who Is This For?

• Marketing managers in any company
• Analysts tracking campaign performance.
• Business owners wanting to understand marketing ROI.
• Beginners seeking a real-world marketing dashboard project.

Tools Used

• Microsoft Power BI Desktop (main tool).
• Microsoft Excel (for campaign and performance data).

Duration

• Total Learning Time: 6–8 hours

Key Outcomes

By the end of this course, you will:

• Have a completed Marketing KPI Scorecard designed.
• Understand how to measure and track key marketing performance indicators.
• Be able to visualize campaign performance and ROI.
• Gain hands-on Power BI experience with marketing datasets.

Part of the Dashboard Mastery Series

Other editions in the series:

1. HR Training KPI Dashboard (Edition 1)
2. Basic Profit & Loss Dashboard (Edition 2)
3. Cost Analysis Dashboard (Edition 3)
4. Marketing KPI Scorecard – Logistics Company (Edition 4)
5. Sales & Representatives Performance Dashboard (Edition 5)