Tableau Assignment Help Needed

1

Assessment Brief

Module Title: Data Visualization

Module Code: B9DA106

Assessment Title: Continuous Assessment One – Tableau

Assessment Number: 1

Assessment Type: Tableau Practical Assignment

Individual/Group: Individual

Assessment Weighting: 40%

Issue Date: 23/06/2020

Due Date/Time: Deadline – 11:55 pm on Tuesday 14/07/2020

Mode of Submission: MOODLE

Learning Outcomes to be assessed

1. Ability to visualize and analyse datasets using Tableau.

Tableau Practical Assignment (100 Marks)

Context

The given Retail.xlsx dataset contains anonymized weekly sales data for 45 stores of a retail

corporation that operates a chain of hypermarkets, discount stores, and neighborhood stores.

Data is available from the week of 11/11/2011 to the week of 26/10/2012. Stores offered five

types of markdowns (discounts) throughout this one-year period, during which there were

four holiday weeks – 25/11/2011, 30/12/2011, 10/02/2012, 07/09/2012.

Additional information about this dataset is given in Appendix 1.

2

Task

Create a dashboard that can help analyze the sales patterns across stores and their

departments.

Dashboard should contain:

Two Controls:

1. A (Month, Year) filter.

2. A user control to select either one of the five markdowns or total markdown.

These controls should work across the entire dashboard. [10]

Visualization 1

A dual-axis visualization showing sales & markdowns by week. It should be divided into three

parts, showing results by three store types – hypermarkets, discount stores, and

neighborhood stores. Sales during holiday weeks should be colored differently from sales

during non-holiday weeks. [20]

Visualization 2

A dual-axis visualization showing sales & markdowns by store. It should be divided into three

parts, showing results by three store types – hypermarkets, discount stores, and

neighborhood stores. [15]

Visualization 3

A visualization showing top 5 departments by sales within each store, within the three store

types. User should be able to see ‘Store Type’, ‘Store’, ‘Department’, ‘Store Sales’, and

‘Department Sales’ within the tooltip for each department. [30]

Two Action Filters:

1. Source: Visualization 1, Target: Visualization 2, Visualization 3.

2. Source: Visualization 2, Target: Visualization 3 [5]

Finally, create a story providing any three interesting insights drawn from visualizations in the

dashboard, while focusing your analysis around the four holiday weeks. [20]

3

Students must submit: -

Tableau Workbook File (.twb) within a zipped folder

Follow the naming convention:

Tableau file should be named as –

CA1_Firstname_Surname.twb

Zipped Folder should be named as –

CA1_Firstname_Surname.zip

Assessment Criteria

Dashboard will be graded according to the following criteria:

1. Data quality (visualizations displaying correct data) [Weightage – 50%]

2. Ease-of-understanding (Choice of visualization, formatting (titles, labels, colors, etc.),

presence of filter/parameter controls) [Weightage – 50%]

Story will be graded on the quality of derived insights.

4

General Assessment Submission Requirements for Students:

1. Online assignments must be submitted no later than the stated deadline.

2. All relevant provisions of the Assessment Regulations must be complied with. Students are required to refer to the assessment regulations in their Student Guides and on the DBS Quality Assurance Handbook Guide.

3. Extensions to assignment submission deadlines will be not be granted, other than in exceptional circumstances. To apply for an extension please contact the course administrator.

4. Students are required to retain a copy of each assignment submitted.

5. Assignments that exceed the word count will be penalised.

6. Dublin Business School penalises students who engage in academic impropriety (i.e.

plagiarism, collusion and/or copying). Please refer to the referencing guidelines on Moodle for information on correct referencing.

Late Submission

• Assignments submitted after the deadline published in the assessment specification, including any revised deadline in case of approved extension, are deemed to be ‘late’ and are penalized as follows:

• Where an assignment is submitted between 1 and 14 days late, a penalty of 2 marks per day is applied per day or part thereof.

• Where an assignment is more than 14 days late, it is annotated at the discretion of the lecturer, but no marks can be awarded.

• Where the assessment is undertaken in a group, the piece of work should be submitted in its complete entirety, and any penalty for late submission incurred applies to all group members.

5

Appendix 1 There are three tabs in the Retail.xlsx excel file – Stores, Sales, and MarkDowns. Relevant

information about the columns in these tabs is given below:

Stores

o Store - the store number

o Type - the type of store (A - hypermarket, B – discount store, C – neighbourhood store)

o Size - the size of store (in square feet)

Sales

o Store - the store number

o Dept - the department number

o Date - the week

o Weekly_Sales - net weekly sales for the given department in the given store

o IsHoliday - whether the week is a holiday week

MarkDowns

o Store - the store number

o Date - the week

o MarkDown1-5 - five different promotional markdown types. Data in these columns correspond to absolute markdown values. Markdown rates (discount percentages) are not given. Additionally, these markdown values are not available for all stores all the time. Any missing value is marked with a 0

o IsHoliday - whether the week is a holiday week