Categories: Power BI
Tags:

Power BI Tutorial: Global Advertising Spend Dashboard Explanation (2000–2024 + Forecast to 2034)

Advertising Spend worldwide from 2000 to 2024 in million USD- with Forecast to 2034 in Power BI

This Power BI dashboard provides a comprehensive view of advertising spending trends globally from the year 2000 to 2024, along with forecasted projections up to 2034. The dashboard is divided into two key visual components:

1️⃣ Bar Chart: Actual Advertising Spending (2000–2024)

Title: Sum of Ad Spending (in million USD) by Year
Visual Type: Clustered Bar Chart
Purpose:

  • Displays historical annual ad spending data.
  • Y-axis shows the ad spend (in million U.S. dollars).
  • X-axis shows each year from 2000 to 2024.
  • Values like 0.34M in 2000, 0.66M in 2016, and 0.94M in 2024 show a rising trend.

✅ Insight: There’s consistent growth in advertising investments, especially post-2015, indicating a strong shift towards digital and global marketing efforts.

Get the Dataset Here:

Download the Dataset

2️⃣ Line Chart: Forecast of Advertising Spend (2025–2034)

Title: Forecast Ad Spending (in million USD) by Year 2034
Visual Type: Line Chart with Forecast
Purpose:

  • Extends the current data to predict future trends in ad spending using Power BI’s forecasting tools.
  • The blue line shows actuals and forecasted values.
  • The shaded red area indicates the confidence interval — the possible range in which the values may fall.

📈 Insight:

  • From 2024’s peak of 0.94M, ad spending is expected to grow towards 1.5M+ by 2034, highlighting expanding budgets in digital and traditional advertising globally.

📌 Key Features Used in Power BI:

  • Data Transformation (Power Query): Raw data converted into time-series format.
  • Bar & Line Charts: For clear differentiation of actual vs forecasted values.
  • Forecasting Analytics: Enabled under the Analytics pane to predict future values.
  • Tooltips & Data Labels: Custom labels added for clarity.
  • Visual Styling: Font, color, and layout adjustments for professional presentation.

✅ Dashboard Use Case:

This dashboard is perfect for:

  • Marketing analysts monitoring global ad spend trends.
  • Strategic planners forecasting budgets.
  • Educators or trainers teaching Power BI basics and intermediate forecasting.

📘 Made by: Slidescope Data Analytics and Digital Marketing and Institute

This dashboard serves as both an informative visualization and a learning model for Power BI enthusiasts focusing on real-world business intelligence applications.