Which are the top 5 products being returned; which are the customer segments returning the most? What is the average time between order and ship dates by-product?

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

MIS 671 Tableau Practice Exercises

Tableau Exercises Note:

• You are permitted to work in groups but you must do the work for yourself and use your own words to answer the questions. So consult with each other freely but submit your own work.
• You are strongly encouraged to install the Tableau desktop on your own laptop and bring it to class.

 

Tableau Exercise 1

Step 1. Access a dataset with store records at SuperStoreUS_2015.xlsx and view in Excel.

Step 2. Describe the dataset in your own words.

Step 3. Come up with questions to answer using this dataset:

1. Profits by region (or manager); profits by customer segment; profits by product category and product?
2. Which are the top 5 products being returned; which are the customer segments returning the most?
3. What is the average time between order and ship dates by-product?

Step 4. Import the data into Tableau (see instructions at http://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_excel.html).

Step 5. Try and use filtering, built-in functions, and visualizations to answer the questions. Take screenshots and paste into this document below.  Add language to explain each screenshot as you answer the question.

 

Tableau Exercise 2 - Joining and Blending Data

Step 1. Access a dataset with store records at AmazingMartEU2.xlsx and view in Excel.

Step 2. Describe the dataset in your own words.

Step 3. Come up with questions to answer using this dataset:

1. Which products are sales leaders by quantity?
2. Which products are profit leaders by state and by country?
3. Which products are loss leaders by state and by country??
4. Sales target met by category by year?
5. Which customer segment is most profitable overall and by country?
6. Which products are trending high in profitability by season (3 month quarters, Jan-Mar, …, Oct-Dec)?

Step 4. Import the data into Tableau (see instructions at http://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_excel.html).

Step 5. Try and use filtering, built-in functions, and visualizations to answer the questions. Take screenshots and paste into this document below.  Add language to explain each screenshot as you answer the question.

 

 

Tableau Exercise 3 - Storytelling

Today's dataset is dummy data for an imaginary bank operating in the UK.

Step 1. Access a dataset with store records at UK Bank Customers.csv and view in Excel.

Step 2. Describe the dataset in your own words.

Step 3. Come up with questions to answer using this dataset’s four categories (Gender, Age, Region, and Job Classification). You may create 4 questions each based on a single category (kind of basic stuff), or challenge yourself to use a combination of categories (e.g. How does bank balance vary by age across regions?).

Step 4. Import the data into Tableau (see instructions at http://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_excel.html).

Step 5. Read the online help on how to create a ‘story’ (https://onlinehelp.tableau.com/current/pro/desktop/en-us/story_create.html)

and once done in Tableau use the https://onlinehelp.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.html link to learn how to export the story to Tableau Public and enter the link to the story below.  Do not need to submit anything else.

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of