Using Data Analytics to Identify Target Consumers for Organic Products in a Supermarket Chain

ACCOUNTING AND INFO
SYS

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
Identifying the target consumers and preparing report...............................................................3
Visual presentation of the data....................................................................................................5
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
For any business to get successful it is essential that all the work is being done effectively
and efficiently. The reason behind this fact is that when the decisions are not taken effectively
then it will affect the quality of working. The present study is based on supermarket chain that
has recently started offering organic products. The current study will outline the use of data in
order to ensure that which target will be most suitable for the company to get successful. The
study will include the use of analysis of data with help of Excel and various formulas.
MAIN BODY
Identifying the target consumers and preparing report
For the organic product to be successful the most essential aspect for the company is to
analyse its target consumer (Hariri, Fredericks and Bowers, 2019). The reason behind this fact is
that in case started consumer will not be selected properly then it will affect the working and
efficiency of the company.
Total amount spent on basis of gender
Count of Prom
Spend
Dem
Gender
Prom Time Blank F M U Grand
Total
0 7 27 12 3 49
1 173 946 474 129 1722
2 183 868 386 143 1580
3 122 587 281 87 1077
4 276 1460 718 211 2665
5 477 2384 1140 313 4314
6 132 665 264 79 1140
7 158 775 352 111 1396
8 416 1749 863 255 3283
9 207 925 408 118 1658
10 59 299 151 50 559
11 66 366 176 56 664
12 45 207 116 37 405
13 22 107 54 10 193
14 13 69 39 17 138
15 12 59 41 12 124