CASE STUDY · TABLEAU

Australian Wine Company
Insights.

An interactive Tableau Business Intelligence dashboard designed to bring sales, product, customer and KPI performance into a single management-oriented analytical view.

TableauBusiness IntelligenceData VisualizationKPI Analysis
Australian Wine Company Tableau insights visual
BUSINESS PROBLEM

Turn business data into an interactive management view.

The objective was to create a Tableau-based BI solution that helps stakeholders understand sales performance, revenue trends, product contribution, customer performance and key business indicators.

How is overall sales performance changing?
How is revenue tracking against the business target?
Which products contribute to performance?
Which customers contribute most to the business?
How do performance patterns change over time?
Which KPIs require management attention?
How can users explore the data interactively?
How can visualization support faster business interpretation?
KPI SNAPSHOT

A dashboard built around measurable performance.

The dashboard consolidates business performance indicators into an interactive reporting experience. The portfolio snapshot below highlights the available project metrics.

$9.24MRevenue
$9.75MRevenue target
94.8%Revenue target achievement
$88Average unit price
129,284Order quantityDashboard KPI from the project analysis.
119,699FreightFreight metric represented in the dashboard.
DASHBOARD ANALYSIS

Four analytical lenses.

The dashboard combines multiple business perspectives so users can move between headline KPIs and detailed performance patterns.

Sales Performance

Monitor overall sales performance, revenue trends, period-wise movement and contribution patterns.

Product Analysis

Compare product contribution, product performance differences and product-level trends.

Customer Analysis

Explore customer-level performance, contribution and high-value customer groups.

KPI Monitoring

Bring important business indicators together for faster performance monitoring.

Trend Identification

Use interactive visualizations to identify changes and patterns requiring further investigation.

Interactive Exploration

Filters, charts and dynamic views allow users to explore the underlying business questions rather than rely on a static report.

BUSINESS PERFORMANCE

Revenue, targets and operating indicators.

The project provides a management-oriented view of performance. Revenue is shown against a target, while freight, order quantity and average unit price provide additional operating context.

REVENUE TARGET$9.24M revenue against a $9.75M target.

The dashboard indicates approximately 94.8% achievement against the stated revenue target, leaving a gap of roughly $0.51M.

4.96%Average discount
129,284Order quantity
372,420Quantity target
REGIONAL & PRODUCT VIEW

Compare contribution across markets and product groups.

The dashboard supports regional and product-level exploration rather than treating total revenue as the only performance measure.

514KNorthern Territory revenueRegional example from the dashboard analysis.
963KSouth Australia revenueRegional example from the dashboard analysis.
833KACT revenueRegional example from the dashboard analysis.
795KTasmania revenueRegional example from the dashboard analysis.
Product view
The dashboard compares product performance and contribution, while the underlying analysis includes Red, Rose/Sparkling and White wine categories and their trends over time.
CUSTOMER & TREND ANALYSIS

Performance is not only about the latest sales number.

The dashboard also explores customer contribution, retention patterns and category trends to add context to the headline KPIs.

Customer retention

Order quantity rises across the displayed cohort years from approximately 25K in 2010 to 42K in 2013.

Red wine

The project analysis describes Red as relatively consistent across the displayed trend period.

White wine

The analysis identifies a notable spike around 2012 in the White category.

Rose / Sparkling

The category is described as more volatile across the displayed trend period.

Customer contribution

Customer-level views help identify contribution differences and support further high-value customer analysis.

Freight

Cumulative freight contribution is visualized as part of the dashboard's business performance story.

ANALYTICAL FRAMEWORK

Business question → visualization → insight.

The project focuses on connecting business requirements with analytical outputs instead of creating charts in isolation.

Business Problem→Data Understanding→Data Analysis→KPI Development→Tableau→Dashboard→Business Insight
Core principle
Business Question → Data → Analysis → Visualization → Insight → Decision Support
TECH STACK

Tableau as a business intelligence layer.

The primary analytical deliverable is the interactive Tableau dashboard published through Tableau Public, with GitHub providing the project documentation and portfolio context.

TableauTableau PublicBusiness AnalyticsBusiness IntelligenceData VisualizationGitHub
LIMITATIONS

Keep the dashboard in context.

Dataset scope

The dashboard represents the data available in the project dataset and should be interpreted within that scope.

Patterns ≠ causation

Dashboard-level relationships and trends do not automatically establish causal explanations.

Customer data

Customer analysis reflects the available customer-level data and is not automatically a complete customer lifetime value calculation.

Decision validation

Business recommendations should be validated using current operational and financial data before implementation.

PROJECT RESOURCES

Explore the dashboard
interactively.