Use the data from the attached file (Exercise 7) to replicate the dashboard shown in the in-class demo.
Upload a screenshot of the dashboard AND your Tableau workbook (.twbx) here.
(INSTRUCTIONS) DEMO HAS BEEN ATTACHED AS SLIDES FOR REFERENCE
Sheet1
| DATA TO GRAPH | |||||||||
| UNITS SOLD | PROJECTED | ||||||||
| 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | |
| Retail | 13,490 | 13,350 | 10,463 | 13,910 | 14,360 | 14,630 | 11,490 | 10,200 | 9,500 |
| Ecommerce | 5,010 | 5,560 | 4,249 | 6,040 | 6,690 | 7,110 | 7,380 | 7,932 | 8,000 |
| Partner | 3,500 | 3,780 | 2,946 | 3,520 | 3,770 | 4,540 | 5,230 | 7,893 | 9,500 |
| Direct Marketing | 460 | 447 | 424 | 410 | 411 | 483 | 532 | 509 | 500 |
,
Dashboard and Story Demo
ISM 6404: Business Data Visualization and Reporting Week 7 | Part II
How to Improve?
Starting Data
Data Source in Tableau • Run Interpreter • Pivot Years • Rename Pivoted
fields • Change Year to date
field
Remake Beginning Graph in Tableau
Create Field for Actual and Projected
Create Combined Field
Create New Stacked Bar
Edit Stacked Bar to Show only Actual
Edit Stacked Bar to Show only Actual
Create Time Series Chart
Create Time Series Chart
Add Filter to Time Series
Add Reference Band
Time Series Chart with Projection
Recreate Dashboard
Recreate Figure 7.2 Dashboard
Recreate Dashboard
Add Action to Dashboard
Dashboard with Highlight Action
Exercise 7.2 Story Point Introduction
Story Point Introduction
Story Point Introduction
• Assignment: • Lab #5: Replicating Dashboard • Discussion #6: Draft Peer Review
• Next Week: • Final Exam • Project Final Version