Your line manager is happy with your performance and because you have familiarity with
the Bangles data she has asked you to lead the next stage of the project. Bangles invested in
a marketing campaign in the UK in month 5 2020.
The business question that Bangles are trying to address are:
Did the marketing campaign have a positive impact on sales performance in the UK?
A new dataset is available to you (see separate file)
You have been asked to complete a report for the client. This should be written in Word and
then saved as a PDF and be no more than 2,500 words. Because this is your first client
report for WFTT your line manager has given you additional detail re the structure and
content that she expects to see
a) Context. Summarise the key changes and trends that are leading to the increased
importance of data analysis in companies such as Bangles, and how data analytics can add
value
b) Plan. Summarise and justify the analytical approach that you will take using business
analytics to answer the business question
c) Analysis
i. Data. Outline any steps you have taken to clean the data
ii. Analysis. Apply relevant analytical techniques that will support answering the
business question. Summarise your analysis in insightful tables and charts and
include an appropriate management commentary that highlights the key points that
can be drawn from your analysis
d) Conclusion and next steps
i. Concisely summarise your conclusions and recommendations in respect of the
business question. This should include how the analysis could be improved (for
example through using additional data) and highlight any concerns you have re
the analysis
ii. Next steps – critically evaluate the use Bangles could make of advanced
techniques such as econometric analysis in further analysing the effectiveness of
the UK marketing campaign
e) Board Summary
i. Bangles would like a 5 slide summary that they can use internally and present to
the Board. This should cover all of the key points in the report
Create and then cut and paste 5 Microsoft PowerPoint slides into your
document that summarizes your written report