SuperStore Data Analysis Project
Learning objectives
1. Load a dataset into the Tableau platform
2. Create a worksheet for each question in the assignment
3. Apply filters to analyze specific aspects of the data
4. Sort the data by sum, count, or average values
5. Create different visualizations to illustrate how to approach a question in different ways
6. Illustrate how colors and size can be used to enhance visualizations.
Data set background
The data set for your assignment is a modified version of the Super Store demonstration dataset
provided by Tableau. The dataset contains sales transaction data for four years. Note that this dataset
is used for demonstration purposes only and is not intended to depict data from a real-world company.
Data dictionary
• Category: This field indicates product category for the sale.
• City: This field contains the name of the city where the SuperStore is located.
• Country: This field contains the name of the country where the SuperStore is located.
• Customer Name: This field is the name of the customer who made the purchase.
• Manufacturer: This field is name of the manufacturer for the product sold.
• Order Date: This field contains the date the customer placed the order.
• Order ID: This field is order ID number.
• Product Name: This field provides the name of the product purchased by the customer.
• Invoice Number: This field is the invoice number.
• Segment: This field contains the segment within SuperStore responsible for the sale.
• Ship Date: This field contains the date the items were shipped to the customer.
• Ship Mode: This field contains the mailing terms for the sale.
• Sub-Category: This field indicates a more specific description of the item sold.
• Discount: This field indicates any discounts applied to the sale.
• Profit: This field indicates the profit recognized on the sale.
• Credit Sales: This field indicates the revenue recognized on the sale.
,Instructions
[Insert Video]
[Insert Dataset Attachment]
After watching the video above, download the “Super Store” excel dataset. Load the dataset into
Tableau to complete the questions in this assignment. You will notice the excel workbook has 3 sheets,
(i) Example Data Set; (ii) Student Data Set; (iii) Inventory Detail. You will use the Student Data Set and
Inventory Detail to complete the following 5 questions:
1. Which Super Store customer accounts for the most credit sales?
William Brown
2. In what year and month did the Company have the highest credit sales?
December 2017
3. Which country has the highest credit sales of “3-ring staple pack” product?
Russia
4. Products shipped “first class” (ship mode) create how much profit on average?
31.834
5. Which city has the highest credit sales?
Moscow
,SOLUTIONS TO ANALYZE, THINK, COMMUNICATE – CHAPTER 1
ATC 1 – 1 (All dollar amounts are in millions.)
a. $ 2,937
b. Net income increased by $23
STOCKHOLDERS’
c. ASSETS = LIABILITIES + EQUITY
$41,290 = $29,993* + $11,297
* Liabilities must be computed by subtracting equity from assets.
d. Sales increased by 3.7% from 2017 to 2018.
($74,443- $71,786) ÷ $71,786 = 3.7%
Cost of sales increased by 4.3% from 2017 to 2018.
($53,299- $51,125) ÷ $51,125 = 4.3%
Selling, general and administrative expenses increased by 3.9% from
2017 to 2018. ($15,723- $ 15,140) ÷ $ 15,140 = 3.9%
The largest percentage increase was for cost of sales expenses.
1-64
, ATC 1-2
a.
Income Statements (amounts given are in millions)
Year 6 Year 5 Year 4 Year 3
Revenue $ 860 $1,520 (a) $2,720 $1,200
Cost and Expenses (a) (840) (a) (1,070) (2,400) (860)
Income from Cont. Op. (b) 20 450 320 (a) 340
Unusual Items -0- 175 (b) (145) (b) ( 40)
Net Income $ 20 (b) $ 625 $ 175 $ 300
Balance Sheets
Cash and Marketable Sec. $ 350 $1,720 (c) $ 750 $ 940
Other Assets 1,900 (c) 1,180 2,500 (c) 2,560
Total Assets $2,250 $2,900 (d) $3,250 $3,500
Liabilities (c) $ 730 (d) $1,555 $1,001 (d) $1,300
Stockholders’ Equity
Common Stock $ 880 $ 720 (e) $1,449 $ 800
Retained Earnings (d) 640 (e) 625 800 (e) 1,400
Total Stockholders’ Equity 1,520 1,345 (f) 2,249 2,200
Total Liab. and Stk. Equity $2,250 (f) $2,900 $3,250 $3,500
1-65