Assignment - topic presentation
Total marks: 100 (30marks video +70 marks submission)
Weight: 35%= 15%+20%
Word count: 2,000.
Video presentation: 10 minutes
This assignment aims to practice your skills in IT, data management and data presentation
You are senior business analyst for one of the regional divisions of Victoria’s secrets, a US-based lingerie (pronounce: Lon-zhuh-ri) company with a wide network of stores, VictoriasSecret.com.
The company is a designer, manufacturer, and marketer of wide range of women's lingerie, womenswear, and beauty products. The company is widely known for their high visibility marketing including a catalogue and annual televised fashion show featuring "angels".
You are asked to develop a dashboard in Tableau/Tableau Prep that allows senior management to make decisions about allocation of resources between
ands and product ranges.
The provided dataset covers the following sites:
· Amazon
· Victoria's Secret
· Btemptd
· Calvin Klein
· Hanky Panky
· American Eagle
· Macy's
· Nordstrom
· Topshop USA
The management is interested to look at the following aspects:
· Pricing decisions for
ands/product ranges
· Customer preferences for
ands/product ranges and customer groups analysis
· Social media analysis
· Data driven predictive insights in relation to the above
How to submit:
Upload your files to the Dropbox in VU collaborate:
1. Data related:
- Tableau file(s) with dashboard
2. - Word document – a report with the summary of the data and data preparation (20% of the total)
3. Video presentation
The video presentation will be displayed at the time allocated for the assessment and you are expected to answer questions from your classmates.
Data to use:
1. Full dataset is available at https:
www.kaggle.com/PromptCloudHQ/innerwear-data-from-victorias-secret-and-others
The direct link is https:
www.kaggle.com/PromptCloudHQ/innerwear-data-from-victorias-secret-and-others/download
UQ4QpYMd66YV5R6V1fX%2Fversions%2FXnIQxebcUrpwUMbOu7TP%2Ffiles%2Fae_com.csv?datasetVersionNumber=1
Tasks:
See the definition of variables in a separate file “Data dictionary”
The structure of the report
· Executive summary
· Introduction
· Methodology: summary of the data sources, data variables and data preparation, diagrams and dot-points are encouraged
· Business insights and communication:
· Pricing decisions for
ands/product ranges
· Customer preferences for
ands/product ranges and customer groups analysis
· Social media analysis
· Data driven predictive insights in relation to the above
· Recommendations
Video presentation
· Your video presentation is your presentation of your dashboard and business insights to senior management.
· It is a communication piece that is not intended to explain the underlying technical details of project, but its use for business decision making and operational insights.
· It should include a walkthrough your dashboard with a short introduction to interface, but the emphasis on dataviz covered and example of insights.
· You are flexible in the format of your presentation file.