Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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.
Answered Same Day Jun 02, 2021

Solution

Payal answered on Jun 05 2021
146 Votes
BUSINESS CASE ANALYSIS
(VICTORIA’s SECRET)
Submitted By–
TABLE OF CONTENTS:
1. EXECUTIVE SUMMARY
2. INTRODUCTION
3. METHODOLOGY
3.1 DATA SOURCE
3.2 DATA VARIABLES
3.3 DATA PREPARATION
4. BUSINESS INSIGHTS & COMMUNICATION
4.1 SCOPE & CONCLUSION
5. RECOMMENDATION
1.EXECUTIVE SUMMARY:
Victoria’s Secret is an elite industry which deals into designing, manufacturing & marketing of intimate apparels & beauty products in International market. The company has started their operations in 1977. Their bold step of visualizing their products through annually telecasted fashion show with supermodels du
ed “angels” has taken the company to newer heights & expanded their presence in International market.
The whole business operates into 3 division –
· Victoria’s Secret Stores
· Victoria’s Secret Direct
· Victoria’s Secret Beauty
Since inception in 1977, the company has expanded exponentially in terms of Stores & International presence, but, it has been observed that market share has been declined up to 25% from last 5 to 6 years.
It is obvious that certain level of decline has happened due to Covid-19 pandemic, however, the whole fall cannot be categorized under this pandemic. There must be some hidden challenges which made Victoria’s Secret struggle to maintain their
and image among the loyal consumers. The worst has got added post Covid-19 which resulted into closure of few retails outlets.
Considering the above facts & my association with Victoria’s Secret as a senior business analyst, I have undertaken an activity to understand the overall situation of all business verticals of Victoria’s Secret. The details understanding would be including the analysis of all
ands across the segment & uncover the hidden opportunities which can further enhance the overall business operations of the Organization. The key focus areas of this study are –
· Pricing decision for Brand/Product ranges
· Customer preferences for Brands/Product ranges & customer group analysis
· Data driven predictive insights in relation to the above
The study here is supported with the facts & visual representation of facts which will help to identify the key opportunities along with the possible recommendation. This will primarily help the senior management at Victoria’s Secret to decide between the possible recommendations for future growth in business at Victoria’s Secret.
2.INTRODUCTION:
Data Analytics and Business Intelligence has become a buzzword in todays’ world. This can be attributed to the fact that it is applicable to almost all the fields i
espective of the nature of the business. Be it Sports, Healthcare, manufacturing, HR analytics, Financial analytics, etc, everyone is using Data Analytics and Business Intelligence to take data driven decisions, in order to be most effective and efficient.
In today’s world data driven decisions are not only limited to the business operation, but have also become an inseparable part of any business operations. With the use of advanced analytical tools available in the market, the management can quickly identify the loopholes in the business operations, and accordingly help them taking the better and efficient decisions.
In the cu
ent case, I am using Tableau to analyse the data for further insights. Tableau is a powerful data visualization tool used in Data Analytics and Business Intelligence Industry. It helps in simplifying raw data which in turn can be easily turned into an understandable format., to gain meaningful insights out of the data
The great thing about Tableau is its user-friendliness, which is offered to users for various analysis. By using Tableau, even a non-technical user can create a customized dashboard. The best feature Tableau are
· Data Blending
· Real time analysis
· Collaboration of data
Over the years the tool has attracted the attention of people from all sectors such as business, researchers, different industries, etc.
Moreover, to promote the product within educational institutions, students at college level, it offers a Tableau student version which is free for the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here