Business Data, Analytics & IT Elizabeth Broughton
Contents
Introduction
Limitations, My Findings
Recommendations
Justification of Forms
Explanation of ERD
Developments to Database
Limitations of the website ď ľ
I am going to Explain the data gathered from the website and why it may not be performing successfully
Graph 1 Total Visitors to Website per Month
1800 1600 1400 1200 1000 800 600 400 200 0
Feb
Mar
Apr
May
Graph 2
Mean Visitors to Website per Month
80 70 60 50 40 30 20 10 0
Feb
Mar
Apr
May
Graph 3
Number of Visits by Source 4,000 3,500 3,000 2,500 2,000 1,500 1,000 500 0
o G
le og
S
rc ea
h
ne gi n E
ire D
W
ct
o
e pr rd
s
rg s.o
W
e sit b e ng Bi
c ar e S
h
ne gi n E
Tw
e itt
oo G
r
e gl
A
ds
se en
A
e dv
rt
e ub t u Yo
o ho a Y
S
rc ea
h
d ke iL n
In c Fa
oo eb
k
Bounce Rate
what it is
why its needed
how to lower it
what industry says it should be
Overall Avg Bounce Rate
88.08%
Recommendations for Improving Performance of Website
Data Collection:
-Collect more data -Use demographics -Limited sales in first month of collection
Visitors by source:
-Does not need to be varied -Current customers may visit through a referral
The actual website:
-Make sure the site works on all devices -General site improvements -Could use eye tracking software to see why bounce rate is high
Justification of my Database Forms
Explanation of my Entity Relationship Diagram
Possible Further Developments to my Database
Systems Development Life Cycle
Testing of Database
Ensure ease of use in comparison to old database to ensure smooth transition
References ď ľ
ERD definition: https://searchdatamanagement.techtarget.com/definition/entity-relation ship-diagram-ERD (4th March 2019)
ď ľ
Bounce rate by industry diagram: https://www.truconversion.com/blog/traffic/6-simple-ways-to-kill-bounce-r ate/ (4th March 2019)