Business Analytics Report (Predictive and Prescriptive)

Business Report:

A recipe box company in the UK aims to:

a) improve their brand recognition by optimising the impact of their social media posts

To help the company improve their brand recognition, the company would like to know which characteristics of the post impacts the social media activity as this would help the manager to decide on whether to publish a post.

To optimise the impact of their social media post, the company had gathered data on their social media activity and the characteristics of each posts to conduct analyses (Social Media Dataset: Social Media Metrics).

The characteristics of the posts include:

1. Type of content (e.g. video, photo, link, status)

2. Post category (e.g. promotion, product, tutorial)

3. Date of the post

4. Total number of likes in the page

5. Paid or not paid advertising

Task 1: Predictive Analytics

1.1 Develop a regression model for each of the social media metric of your choice (minimum 3). Justify the social media metrics chosen for the task

1.2 Identify the post characteristics that are relevant in predicting the performance of the social media metrics

1.3 Provide further analysis to show how each relevant feature influenced the performance of the social media metrics

b) attract more customers by advertising their products in different advertisement media

They would like to know how many to use from each type of media so that the number of audience reach is maximised.

To attract more customers, the recipe box company had identified four advertisement media to advertise their products (Social Media Dataset: Advertising Media).

The advertisement media includes:

1. Flyer

2. Online advertising in other platforms (e.g. Twitter, Instagram etc)

3. TV

4. Radio

To ensure a balance use of advertisement media, TV advertisement must not exceed 50% of the total number of advertisements, flyer and radio must not exceed 10% of the total number of advertisements. In addition, there should be at least 10 online advertisements. The advertising budget is £190,000.

Task 2: Prescriptive Analytics

2.1 Apply prescriptive analytics to recommend the best possible option. State any assumptions that you have made. 2.2

2.2 Develop and solve an optimisation model to determine the number of each type of media to use such that the number of audiences reached is maximised

2.3 Perform what-if analysis for the optimisation model.

2.4 Explain the best option and trade-offs that must be made to increase the numbers of audience reached. Use the Sensitivity Report to facilitate your analysis.



Powered by WordPress