Why sharing enables organizational adoption in Tableau - Business Case Study

Scenario Mode

👤 Your Role: You are a business intelligence analyst at a retail company.

📋 Request: Your manager wants you to demonstrate how sharing dashboards and reports helps the whole organization adopt data-driven decisions.

📊 Data: You have data on dashboard views, number of users accessing reports, and business units using the dashboards over the last 6 months.

🎯 Deliverable: Create a Tableau dashboard that shows usage trends and highlights how sharing increases adoption across teams.

Sample Data

Month	Dashboard Views	Unique Users	Business Units Using Dashboards
January	120	15	3
February	150	20	4
March	180	25	5
April	220	30	6
May	260	35	7
June	300	40	8

1

Step 1: Connect Tableau to the data source containing monthly dashboard usage data.

Use 'Month' as the date dimension, and 'Dashboard Views', 'Unique Users', and 'Business Units Using Dashboards' as measures.

Expected Result

Data is loaded and ready for visualization.

2

Step 2: Create a line chart showing 'Dashboard Views' over 'Month'.

Rows: SUM([Dashboard Views]), Columns: [Month] (continuous), Show line marks.

Expected Result

Line chart displays increasing dashboard views from January to June.

3

Step 3: Create a second line chart showing 'Unique Users' over 'Month'.

Rows: SUM([Unique Users]), Columns: [Month] (continuous), Show line marks.

Expected Result

Line chart shows growth in unique users accessing dashboards over time.

4

Step 4: Create a third line chart showing 'Business Units Using Dashboards' over 'Month'.

Rows: SUM([Business Units Using Dashboards]), Columns: [Month] (continuous), Show line marks.

Expected Result

Line chart shows more business units adopting dashboards each month.

5

Step 5: Combine the three line charts into a single dashboard with clear titles and legends.

Arrange charts vertically, add dashboard title 'Dashboard Sharing Drives Adoption', and add explanatory text.

Expected Result

Dashboard clearly shows how sharing increases views, users, and units over time.

6

Step 6: Add filters or highlight actions to allow users to explore data by month or business unit.

Add filter for Month and highlight action between charts.

Expected Result

Users can interact with the dashboard to see detailed trends.

Final Result

Dashboard Sharing Drives Adoption

Month ->

Dashboard Views: 120 - 150 - 180 - 220 - 260 - 300
Unique Users:    15  - 20  - 25  - 30  - 35  - 40
Business Units:  3   - 4   - 5   - 6   - 7   - 8

(Three line charts stacked vertically showing steady growth)

✓Dashboard views steadily increase each month, showing growing interest.

✓Unique users accessing dashboards grow, indicating wider adoption.

✓More business units use dashboards over time, proving sharing helps spread usage.

✓Sharing dashboards encourages more teams to use data for decisions.

Bonus Challenge

Add a map visualization showing which business units (by location) are adopting dashboards the most.

Show Hint

Use business unit location data and color code by number of users or views.