Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

BPP data analytics

1

Table of Contents
Task 1:
...
6
Task 3:
...
11
Task 5:
...
15

2

Task 1:
Introduction and Project Plan:
The report will shed light on whether the marketing campaign of Bangles International
Jewellery (BIJ) had any positive impact on sales within the U
...
In order to evaluate the
performance, a thorough analysis of the data set will be performed, which is given to the
researcher by the company
...

The report will include various tables and charts to help the reader understand the bigger
picture
...
This will guide the researcher to perform practical analysis based
on the data
...
The researcher will explain how data analytics can help the company improve such
vital metrics
...
The following few tasks will
include various tables and charts that have been presented with the help of the given data
...
This will also
include the given data's descriptive statistics and even shed light on whether the marketing
strategy impacted the sales performance
...

Project Plan:
In order to tackle a problem in a structured and definite manner, a data analytics framework
has been utilised
...
Such type of framework gives the team the ability to be focused on the data
provided and identify the noise within the dataset
...

Multiple data analysis frameworks can be used in research
...
Various frameworks have been developed to get
different insights from the data set provided
...


3

The researcher has decided to use a descriptive-analytical framework in this case
...
Furthermore, various
solutions can be developed to tackle the problems being faced by the company within its
internal process
...

Key Performance Indicators of BIJ:
Key Performance Indicators (KPIs) are nothing but specific metrics that help evaluate the
company's performance on targeted domains (Parmenter, 2015)
...
However, a company must choose a suitable KPI as it can
determine whether the company will be successful or not
...

The revenue growth can be calculated based on quarter to quarter or year to year
...
However, the most significant limitation of such
a metric is that the growth varies depending upon the maturity stage of the company
...
Based on the data, this KPI can
further help create strategies to increase visits
...
So, it would be advised
to understand the core problem of why visitors are not buying things from that particular
location (Žižek et al
...

Customer Satisfaction: Customer satisfaction is one of the metrics that help the company
understand how happy their customers are based on their interaction with the brand
...


4

Importance of data analytics and its impact on the business:
Data analytics is a field in which the raw data is analysed to identify patterns and trends
...
Following are the benefits of data analytics
and its positive impact on the business:
Improved decision making: Since the company can work on petabytes of data, it can benefit
BIJ to identify various trends that have been identified in the past resulting in better decisions
regarding their marketing and targeting strategy (Evans, 2017)
...

Understanding what the customer wants: This is something which every company wants to
achieve, and that is to understand their customers better
...
, 2020)
...


5

Task 2:
Data quality issues and remedies:
Data quality is one of the measures which help the company to understand whether the data
will benefit in making future projections
...
Various metrics like consistency
and accuracy can help understand data quality
...
, 2016)
...
Humans tend to make errors, and data is not
immune to that
...
Thereby improving the quality of the data
...
Too much data can make the data analysts lose and
make it deviate from the company's goals (Gärtner and Hiebl, 2017)
...

Various machine learning algorithms can be employed initially to help collect the correct data
and prevent too much data collection
...
, 2016)
...

In order to overcome such a problem, the data can be collected through digital means
...

Based on the data cleaning of the given dataset, various problems have been seen and rectified
...
For instance: Ring
had multiple wrong spellings
...


•

Some spellings were inconsistent even though they were right
...


7

Task 3:
Table A: Sales volume and value by month by year of the U
...


Descriptive Statistics:
•

October has the least amount of both volume and value as compared to other months
...


•

On the other hand, June has been the best month across all the periods in terms of sales
value and volume
...


•

The average sales value is seen to be close to 498904, and 50972 was seen to be the
standard deviation of the sales value in the U
...


•

The average sales volume is seen to be close to 594, and 57
...
K
...


8

Table B: Sales value and volume performance of different categories across the period of
the U
...


Descriptive statistics:
•

All the categories saw a decline in sales value in the last quarter, which is 10-12
...
On the other hand,
"Accessories" is deemed as the worst performing asset for the company
...


•

3rd quarter is the best performing time for both ring and hairband
...


9

Table C: Comparison of sales value and volume within markets by a quarter by year
across the period

Descriptive statistics:
•

Every market performed their best in the 2 nd quarter regarding sales value and volume
...


•

In terms of sales value, Japan outperformed both USA and U
...
Conversely, the U
...

performed the worst
...


•

Also, USA and U
...
have a similar trajectory regarding sales value
...

Descriptive statistics:
•

The USA finally got ahead of Japan in 2020 in sales value
...


•

U
...
and USA have a similar trend
...


•

2020 saw increased sales for USA and U
...
However, Japan witnessed the most
significant fall in terms of sales value
...


11

Chart B: Category performance across markets

This chart depicts the sales value across categories within different markets
...


•

On the other hand, the U
...
sold merely 2
...


•

Accessories and rings have performed the worst in all of the markets
...


•

The U
...
performed the best in the bracelet domain and surpassed Japan within this
subcategory
...
K
...

12

Descriptive statistics:
•

All the years saw a decline from the start by the end, regardless of the market
...
However, the later months saw an even
more significant decline
...
K
...


•

Japan has been the most volatile market in terms of sales value
...
K
...


Since the dataset has been provided for 2018-2020, the researcher has created a hypothesis that
the market campaign was implemented in the last quarter of 2019, which is 10-12 months
...
After that, there was a sudden decline resulting
from various lockdowns initiated by the government within the U
...
(Blundell et al
...

However, there could be multiple other factors that might have resulted in the decline in sales
...


13

Task 5:
Recommendations:
Based on the analysis, various problems were identified within the BIJ
...
K
...
However, the marketing
campaign at the end of 2019 positively impacted the market's sales value, but the same is true
for other markets as well, which did not have any marketing campaign
...

Various other factors could accelerate the sales of the company in such markets
...
K
...
K
...
, 2017)
...
This will help the
company to save money and get a better return on investment
...

Conclusion:
The report talked about the performance of BIJ based on the given dataset
...
The
researcher selected a descriptive framework as it helps in understanding the core problem,
which is to analyse the impact of the company's marketing strategy
...
The benefits of data analytics for a business were improved
decision-making and understanding of the customers' needs
...
Various problems like inconsistent format and
unrealistic values were identified and resolved using the filter option in Excel
...
K
...

Recommendations, including removing categories like hairbands and accessories, were
discussed for the U
...
market
...


14

References:
Ardagna, C
...
, Ceravolo, P
...
(2016) December
...
In 2016 IEEE international conference on big data (big
data) (pp
...
IEEE
...
S
...
Procedia
Manufacturing, 22, pp
...

Blundell, R
...
C
...
, Joyce, R
...
, Wernham, T
...
(2022)
Inequality and the COVID-19 Crisis in the United Kingdom
...

Camm, J
...
, Cochran, J
...
, Fry, M
...
and Ohlmann, J
...
(2020) Business analytics
...

Chu, X
...
F
...
and Wang, J
...
Data cleaning: Overview and
emerging challenges
...
2201-2206)
...
and Ram, S
...

Journal of Business Analytics, 1(1), pp
...

Evans, J
...
(2017) Business analytics (p
...
England: Pearson
...
and Hiebl, M
...
(2017) Issues with big data
...
161-172)
...

Parmenter, D
...
John Wiley & Sons
...
, Philpott, E
...
and Cao, G
...
Production Planning & Control,
28(11-12), pp
...

Runkler, T
...
(2020) Data analytics
...

Žižek, S
...
, Mulej, M
...
V
...
0–A socially responsible perspective
...
22-35

---