Dashboard Mode - Forecasting
Business Question
How can we predict future sales for the next 6 months based on past sales data?
0
0
Forecasting in Tableau - Dashboard Guide
Sample Data
| Month | Sales |
|---|---|
| 2023-01 | 1200 |
| 2023-02 | 1350 |
| 2023-03 | 1500 |
| 2023-04 | 1600 |
| 2023-05 | 1700 |
| 2023-06 | 1800 |
| 2023-07 | 1900 |
| 2023-08 | 2000 |
| 2023-09 | 2100 |
| 2023-10 | 2200 |
| 2023-11 | 2300 |
| 2023-12 | 2400 |
Dashboard Components
- KPI Card: Total Sales This Year
Formula: SUM([Sales]) = 22,600 - Line Chart: Monthly Sales Trend
Shows sales from Jan to Dec 2023. - Forecast Chart: Sales Forecast Next 6 Months
Uses Tableau's built-in forecasting model to predict sales from Jan to Jun 2024 based on past data. - Table: Actual vs Forecast
Shows side-by-side sales and forecast values for the last 3 months and next 6 months.
Dashboard Layout
+----------------------+-----------------------------+ | KPI Card | Line Chart | | Total Sales 2023 | Monthly Sales Trend 2023 | +----------------------+-----------------------------+ | Forecast Chart (6 months) | | Sales Forecast Next 6 Months | +----------------------------------------------------------+ | Table: Actual vs Forecast | +----------------------------------------------------------+
Interactivity
A date range filter allows users to select months to view. When changed, the KPI card, line chart, forecast chart, and table update to reflect the selected months. The forecast automatically recalculates based on the filtered historical data.
Self Check
Add a filter to show only months from July 2023 onward. Which components update?
Answer: The KPI card will show total sales from July to December 2023. The line chart will display sales trend from July to December. The forecast chart will generate predictions based on sales from July to December. The table will update actual and forecast values accordingly.
Key Result
A sales dashboard showing total sales, monthly trends, and a 6-month forecast using Tableau's forecasting feature.