Strategic Business Analytics Assignment Sample

Strategic Business Analytics Assignment Sample

 

 

1.0 Introduction

This examination depends on the impression of human conduct, their decisions, requests, and their necessities. The fundamental objective behind the particular exploration is to deal with the commercial and comprehend the sexual orientation design and their need. In this entire examination things were the center given in primary. They are different sorts of restorative items and magnificence items. Restorative items and excellent items comprise of different sorts of cleansers, fragrances, body showers, and so on In this entire interaction different sorts of things have been thought of. The fundamental target is to manage the notification plan of sexual direction plans with grandness thing or supportive thing advancing or publicizing, which joins numerous sorts of restorative things like a cleaning agent, chemical, antiperspirant, conditioner, fragrance, balm, beauty care products, cologne and substance hair tone, skin wellbeing the board, razors, salon organizations and other female thought, similarly as the recognized benefits of endorsement advancing. Different things are significant in this area. The review depends on different sorts of various exercises. There is a huge load of male who is losing their masculinity and there are a lot of females who are incorporating themselves with ladies’ freedom. Here the advancement of the thing by checking out the body plan and how they upkeep their masculinity power and to those females with the level of womanliness identified. The examinations are annexed to the human systems and how they are managing their everyday schedules using greatness things and the number of people is locked in with the thing using possible results.

1.1 Aim and objective

Get Assignment Help from Industry Expert Writers (1)

The main aim of the report is to derive the proper number and proper result from the EXCEL sheet and also derive the proper graph about the beauty and cosmetic products.

The objective of the projects is

To evaluate the transformation graph and result from the EXCEL data

To evaluate the graph and table for the education and the course of education from the EXCEL data

To evaluate the graph and the rate of income for every type of course

To evaluate the graph of gender stereotypes

Get Assignment Help from Industry Expert Writers (1)

To evaluate who uses the products most among them

2.0 Methodology

The methodology section mainly discusses the method and strategy taken for research and to analyze the data. In this report, there are many types of graphs and analyses taken to get the proper result. The method of doing the survey is also mentioned in this section (Aydiner et al. 2019). In this report, one survey and give us many results like gender, age of the people, their highest level of the education level of the people, name of the highest level of education, what is income monthly and annually of those people, average payment for hygiene product and also for the beauty product like deodorant, soap, shampoo, makeup, hire colored other snake care products (Boldosova and Luoto, 2019). This also derives the number of advertisement for hygiene and beauty products also in what platform is used to the advertisement of the product is also mentioned in that section. This survey also defines the prospective and the number of the gender used the subscription and also the stereotypes (Junior et al. 2019). This can also define the number and the survey about the empowerment advertisement. This survey also contains the average number of advertisement that is seen by one person every day. Jamie is the person who does the survey and gets those results, he mainly receives 105 results and from the result, he does a descriptive analysis over the number of the survey and the information which is given in the excel sheet. From the result of the EXCEL sheet, we generate the graph of that information and then describe the whole graph in the discussion section (Chen and Nath, 2018). The methodology section gives the process used to study those graph and also describe the result of the people using those product. The methodology also describes the result of the report and recommends something that can improve the research. The methodology section mainly describes the above information.

3.0 Findings and results

There are numerous things where the center has been given prior to beginning the review. There are numerous things that came as a result of this entire overview (Conboy et al. 2020). In the study, the presence of males and females both was there. There are numerous things that can be said in such a manner. Gender classifies unequivocally use refine impression of what tends to an engaging, alluring, and all people, much of the time exploiting visual sexual direction occupations, and here generally used in openings for care things. The findings which are made from the dataset resulted in giving useful information which seems to be interesting (Chiang et al. 2018). To be sure, even the logical investigation will find individuals who are using tidiness things consistently and how the overseeing organization they are offering every year with the association’s conditions. The value of money is in like manner huge when selling stock. Especially the express no keys that show all evidence with data. There are different things where the center is given prior to leading the review.

 This research paper consists of various types of findings and this research paper also contains specific questionnaires which are asked to the respective random individuals who helped in conducting the survey (Delgosha et al. 2020). The main questions which are been asked in the survey are as follows like asking the age to the respective individuals, individuals highest qualification, individuals annual income, average monthly spendings on the products like beauty and personal care and etc. these above questions have resulted in giving appropriate answers in successfully completing the survey which also helped in making analysis which is depicted below.

Transform Count of Transform
Agree 30
Disagree 1
Neutral 6
Somewhat Agree 35
Somewhat Disagree 1
Strongly Agree 32
Grand Total 105

Table 1: Transformation.

(Source: MS EXCEL)

Strategic Business Analytics Assignment Sample

Figure 1: Transformation.

(Source: MS EXCEL)

Education Frequency
Associate Degree 6
Bachelor Degree 44
Doctorate Degree 10
High school diploma 3
J.D. 1
M.D 1
Master Degree 16
Some undergraduate courses 24
Grand Total 105

Table 2: Education.

(Source: MS EXCEL)

The above figure which has been depicted shows that the majority of the respondents somewhat agree with the transformation which has been made by the 35 respondents, 32 respondents strongly agree, 30 respondents agree, 6 respondents are neutral and 1 respondent each made a decision that they somewhat disagree and completely disagree (Esswein and Chamoni, 2018). Out of the 105 respondents, 97 respondents agreed to the transformation and 8 respondents gave their responses on neutral and disagree. This helped to determine the uniqueness in the responses which are been made by the respondents in determining the cultural gender stereotypes. Thus these responses will support the advertisement team in an organization.

Strategic Business Analytics Assignment Sample

Figure 2: Education.

The above figure which has been depicted shows that the majority of the respondents are belonging to the bachelor degree which consists of 44 respondents, 24 respondents are from some undergraduate courses, 16 respondents are from undergraduate courses, 10 respondents are from doctorate degrees, 6 respondents are from the associative degree, 3 respondents are from high school diploma, and 1 each respondent are from J.D and M.D (Grover et al. 2018). That shows that each individual respondent is educated in different fields and they are capable of making an appropriate decision which will endeavor their choices? This dataset will help the advertisement team in making an effective advertisement that will be easily understandable by the people and these will support the advertisement team in an organization.

Income Frequency
$0 to <  $10,000 24
$10,000 to <  $20,000 21
$110,000 to <  $130,000 3
$150,000 or more 1
$20,000 to <  $30,000 15
$30,000 to <  $40,000 14
$40,000 to <  $50,000 3
$50,000 to <  $60,000 9
$60,000 to <  $70,000 5
$70,000 to <  $80,000 4
$80,000 to <  $90,000 1
$90,000 to <  $110,000 5
Grand Total 105

Table 3: Income.

From the above figure which has been depicted shows that the majority of the respondents are belonging from the income range of $0 to < $10,000 consists of 24 respondents, $10,000  to <  $20,000 consists of 21 respondents, $110,000 to <  $130,000 consists of 3 respondents, $150,000 or more consists of 1 respondents, $20,000 to <  $30,000 consists of 15 respondents, $30,000 to <  $40,000 consists of 14 respondents, $40,000 to <  $50,000 consists of 3 respondents, $50,000 to <  $60,000 consists of 9 respondents, $60,000 to <  $70,000 consists of 5 respondents, $70,000 to <  $80,000 consists of 4 respondents, $80,000 to <  $90,000 consists of 1 respondents and $90,000 to <  $110,000 consists of 5 respondents (Hindle and Vidgen, 2018). This above data will help in determining the product pricing which will be widely accepted by the people so that they can afford to purchase those products.

Gender Count of Stereotype
Female 86
Male 19
Grand Total 105

Table 4: Gender.

(Source: MS EXCEL)

From the above figure which consists of the pie chart of male and female distribution. The male is depicted by a blue color whereas the female is depicted by green color (Junior et al. 2019). Therefore the male respondents are 19 and the female respondents consist of 86 numbers. This pie chart will help the high officials of the company in introducing new products for the people which will be widely accepted by the majority of the people i.e. females.

Count of Transform Column Labels            
Transformation Agree Disagree Neutral Somewhat Agree Somewhat Disagree Strongly Agree Grand Total
0% 11 1 2 14 1 7 36
1% 2     2   6 10
2% 2     2   2 6
3%           1 1
5% 3     4   6 13
7%           1 1
8%     1 1     2
10% 10   2 7   8 27
15%       2   1 3
20% 2     2     4
25%       1     1
30%     1       1
Grand Total 30 1 6 35 1 32 105

Table 5: Count on transformation with percentages.

(Source: MS EXCEL)

Strategic Business Analytics Assignment Sample

Figure 5: Frequency distribution graph of count on transform.

(Source: MS EXCEL)

From the above figure which consists of a frequency distribution graph of count on transform with respective of the percentages of the respondents which strongly agrees by the 10% of the respondents which consists of 8 respondents, 0% of the respondents strongly agrees which consists of 7 respondents, 5% and 1% of the respondents which consists of 12 respondents strongly agrees, 2% of the respondents which consists of 2 respondents strongly agree and 1 respondents each from 3,5 and 15 % strongly agrees (Krishnamoorthi and Mathew, 2018). This frequency distribution will help the company’s officials in determining the eagerness of the people in the transformation changes which will help to make concise decisions in introducing new products or new concepts in the advertisements.

Count of Empowerment% Column Labels    
Empowerment Female Male Grand Total
0% 32 4 36
1% 7 3 10
2% 4 2 6
3% 1   1
5% 11 2 13
7% 1   1
8% 1 1 2
10% 24 3 27
15% 3   3
20% 2 2 4
25%   1 1
30%   1 1
Grand Total 86 19 105

Table 6: Empowerment versus Gender.

hich consists of a bar graph that depicts the empowerment with respect to the gender shows 1 respondent i.e. male in 30%, 1 respondent i.e. male in 25%, 2 respondent each consists of male and female in 20%, 15% consists of 3 female respondents that are empowered, 10% consists of 24 female and 3 male respondents that are empowered, 8% consists of 1 each respondents which are female and male that are empowered, 7% consists of 1 female respondents that are empowered, 5% consists of 11 female and 2 male respondents that are empowered, 3% consists of 1 female respondents that are empowered, 2% consists of 4 female and 2 male respondents that are empowered, 1% consists of 7 female and 3 male respondents that are empowered and 0% consists of 32 female and 4 male respondents that are unemployed and are dependent on others (Liu et al. 2018). This bar graph will help the officials of a company in determining the size and quantity of the products so as the customers will have sufficient amount of money in purchasing those products (Maté et al. 2017). There are 105 respondents from which the analysis has been made.

Count of Stereotype Column Labels        
Ad Frequency Drastic Influential Limited Trivial Grand Total
0   1     1
1   1     1
2 3 3     6
3 1 4 1   6
4   2     2
5 4 5 1 1 11
6 1 3     4
7   1     1
9 1       1
10 3 14 2   19
12   1     1
15 2 3 1   6
20 5 9     14
25 2 2     4
30 1       1
35 1 2     3
37   1     1
40 1       1
45 1       1
50 4 3   1 8
55   1     1
65 1     1 2
75   1     1
100 2       2
150   3     3
300 1       1
400   1     1
600 1       1
1100   1     1
Grand Total 35 62 5 3 105

Table 7:  Ad frequency versus reinforcing and stereotypes.

From the above figure which consists of a bar graph that depicts the AD frequency versus reinforcing and stereotypes, where the highest frequency is being selected as 1100 and the lowest frequency is selected as 0. It has been observed that 14 respondents are highly influential when the AD frequency is set at 10, which will help in delivering the maximum output in knowledge and strategic plans which will help in the development of the growth of the products among the people (Nalchigar and Yu, 2017). There are 5 respondents which are drastic when the AD frequency is set at 20 which will bring maximum change in the organization in implementing as well as arranging all the necessary things which are required in the drastic development of the products. There are 2 respondents which are limited when the AD frequency is set at 10 which will bring limited changes or things of limited changes which are to be brought for the development and there are 1 each respondent in the 5, 50 and 65 AD frequency which are never think of the change which will be beneficial for the changes (Nam et al. 2019). This bar graph will help in the determination of the person’s capability in bringing change in the product from the results which have been gained from the 105 respondents.

Count of Transform Transform            
Education Agree Disagree Neutral Somewhat Agree Somewhat Disagree Strongly Agree Grand Total
Associate Degree 1     1   4 6
Bachelor Degree 15 1 2 19   7 44
Doctorate Degree 2   1 6   1 10
High school diploma       2   1 3
J.D.         1   1
M.D 1           1
Master Degree 4   2 6   4 16
Some undergraduate courses 7   1 1   15 24
Grand Total 30 1 6 35 1 32 105

Table 8: Education versus Transformation.

From the above figure which consists of a bar graph depicting Education versus Transformation, which critically illustrates the transformation which has been gained from the levels of education which has been achieved from the education levels (Lee et al. 2019). 15 respondents from some undergraduate courses strongly agreed on the transformation changes, 4 respondents from master degree strongly agreed on the transformation changes, 7 respondents from bachelor degree strongly agreed and 4, 1, 1 from the associate degree, doctorate degree, and high school degree strongly agreed with the transformation.

Count of Transform Gender    
Transform Female Male Grand Total
Agree 25 5 30
Disagree   1 1
Neutral 5 1 6
Somewhat Agree 26 9 35
Somewhat Disagree 1   1
Strongly Agree 29 3 32
Grand Total 86 19 105

Table 9: Transformation versus gender.

Ad Frequency  
   
Mean 45.45714
Standard Error 12.65691
Median 12
Mode 10
Standard Deviation 129.6948
Sample Variance 16820.73
Kurtosis 45.57855
Skewness 6.310269
Range 1100
Minimum 0
Maximum 1100
Sum 4773
Count 105
Largest(1) 1100
Smallest(1) 0
Confidence Level(95.0%) 25.09913

Table 10: AD frequency.

(Source: MS EXCEL)

Age  
   
Mean 29.26667
Standard Error 1.152658
Median 24
Mode 23
Standard Deviation 11.81123
Sample Variance 139.5051
Kurtosis 2.180954
Skewness 1.796609
Range 49
Minimum 19
Maximum 68
Sum 3073
Count 105
Largest(1) 68
Smallest(1) 19
Confidence Level (95.0%) 2.285764

Table 11: Spending’s.

(Source: MS EXCEL)

Stereotype  
   
Mean 43.38095
Standard Error 12.18002
Median 10
Mode 10
Standard Deviation 124.808
Sample Variance 15577.05
Kurtosis 44.4728
Skewness 6.236635
Range 1050
Minimum 0
Maximum 1050
Sum 4555
Count 105
Largest(1) 1050
Smallest(1) 0
Confidence Level (95.0%) 24.15343

Table 12: Stereotype.

(Source: MS EXCEL)

4.0 Discussion

Humans in this modern world have been more concerned about their beauty and physic, which leads to using of products and necessary supplementary drinks which will help to reduce the excess weight they have gained by consuming unhealthy foods and cold drinks which adversely affects their health and mental conditions in executing their daily tasks as well as the humans have also been concerned about their personal beauty which have drastically changed the personal care beauty products companies to introduce different types of products which are also categorized according to the skin types which enabled the persons to enhance their beauty by using those products (Nielsen, 2018). This helped the companies to raise different advertisements which show eye-catching advertisements in influencing the humans to use those products so as to enhance their personal beauty (Power et al. 2018). But from the above results which have been depicted in the findings and result section which has been conducted from the dataset of 105 individuals where 86 persons consist of females and 19 pupils consist of males. The results show that females are more concerned about their physical and personal beauty and consume huge amounts of beauty products than men as well as they also maintains their clothes by regularly washing. The companies mainly prefer online medium as well as the offline medium in advertising their products through different sources which critically includes FM radios, Televisions, Newspapers, Billboards, Magazines, Mails, etc. they also attract huge customers by providing offers like buy one get one free, special festive discounts and coupon codes on a monthly basis (Pröllochs and Feuerriegel, 2020).  In comparison to male products, there is a huge variety as well as a huge range of products for the females, as females mainly tend to care the most in comparison to men which has been found in the above analysis which has been made from the dataset of the surveys. Gender stereotypes have been used in the advertisements of the products which have been made by the company which critically differentiate the products. Female products show their beauty in a calm manner as the male product advertisements are shown in a rough and tough masculine manner, so as to entice the consumers into opting for those products (Ratia et al. 2019). Sometimes companies also intently use vulgar advertisements to make a good name and fame in providing the necessary requirements of the customers through their products and which are offended mainly by a minority of the peoples which does not affect the reputation of the company. The management of the companies plays a vital role in the promotion of the new products or the bestselling products by enhancing their customer feedbacks and users experiences which are been used as a key role in increasing the profitability of the company (Shi and Wang, 2018). The fundamental target is to manage the notification plan of sexual direction plans with grandness thing or supportive thing advancing or publicizing, which joins numerous sorts of restorative things like a cleaning agent, chemical, antiperspirant, conditioner, fragrance, balm, beauty care products, cologne and substance hair tone, skin wellbeing the board, razors, salon organizations and other female thought, similarly as the recognized benefits of endorsement advancing. There are many companies that need to manage and everything to increase their sales but there are many things that can reduce the rate of sales. The rate of sales are reduced by the price of the product, place of the product in the market, rivels of the product in the market, and negligence to select the target audience (Smys and Joe, 2019). That factor can control by the proper strategy and proper formation of the business. The factors are mainly depends on the survey and some information collected by those type of company.  In this report, an EXCEL sheet is given and also described from the given information we can find many type of information and graph to analysis. The above analysis gives a perfect number that agree and dis agree for the transformation. 35 respondents agree, 32 respondents strongly agree, 30 respondents agree, 6 respondents are neutral and 1 respondent somewhat disagree per 105 people. Son number of target in transformation is greater than any of the others. The other graphs, it confirms that female is more stereotyped than men (Stransky et al. 2019). And the most targeted audience of this type of business is the bachelor degree people and the female.

5.0 Recommendation

There are mainly 105 people who are involved in the survey, so from this survey, we did not do any huge recommendations or any type of suggestions (Sun et al. 2017). The recommendation section mainly recommends something or suggests something that can change the rate of sales and also the rate of income. The EXCEL sheet mainly contains some of the results like the number of males and females in the survey, their income, income of the people as their degree, and also other information. By analyzing that information we get the graph and data about the using of the beauty product, who use the most, whom can use the product most, and also targeted audience and who have to target. From the above analysis, we can get data and a graph of the income vs education level graph (Wang et al. 2019). This graph, confirms that those who have a bachelor’s degree of education has more income than the others and also have a greater number of people who completed bachelor’s degree. From that graph, we can confirm that the bachelor degree people are more efficient to buy those type of beauty and hygiene products. So from that, it can be recommended that this business is mainly focused on the bachelor degree people, and also the company has to ship the targeted audience to normal people to the bachelor degree people. There is also a graph of stereotypes; from the above graph it confirms that the females are more stereotyped than the male so that’s why it confirms that the business is growing in the base of the female customers because they are more interested in this type of product. Females are the main targeted audience in this type of business. The recommendation section mainly describes what is needed to increase the business and also what is the strategy and targeted audience among all types of people. There is a huge load of males who are losing their masculinity and there are a lot of females who are incorporating themselves with ladies’ freedom. Here the advancement of the thing by checking out the body plan and how they upkeep their masculinity power and to those females with the level of womanliness identified. From the education qualification graph it counted that number of people who complete bachelor degree is 44 respondents, 24 respondents are from some undergraduate courses, 16 respondents are from undergraduate courses, 10 respondents are from doctorate degrees, 6 respondents are from the associative degree, 3 respondents are from high school diploma, and 1 each respondent are from J.D and M.D (Su et al. 2020). From that, it confirms that the bachelor degree people are more than the other education level. From the income graph, it confirms that the income of the bachelor degree people is better than the other education level. The income graph shows the income level of the bachelor degree people is better than the other people.

 6.0 Conclusion

There are mainly 105 people who responded to the survey about the product. This survey is mainly about many things like the number of people who used the hygiene product and beauty products, the number of males who use that product, and also the number of females who use that product. The introduction section mainly describe the case study. In this introduction section information about the product and the number of people who used the hygiene and beauty products.  The methodology section mainly describes the process of the survey and also the process of the analysis which is used in this report. The descriptive analysis is done in this project and for the analysis; we get the final result of the EXCEL sheet. The given excel sheet mainly gives the information about the people’s age, qualification, gender, the product used, advertisement view per day and also other stuff like the income and the information about the stereotype and also state the other information about the products and advertisements. The finding and result section mainly creates the graph and also the table that is done by the EXCEL sheet. The result section gives the proper information about the main result of the survey and also gives some graphs related to the given result and information. The discussion section mainly describes the result and the graph which is mentioned in the finding and result section. The recommendation section is recommended some process or strategy to improve the sales of beauty and hygiene products. This report is based on the proper study and proper information about the fact.

 

Reference

Aydiner, A.S., Tatoglu, E., Bayraktar, E., Zaim, S. and Delen, D., 2019. Business analytics and firm performance: The mediating role of business process performance. Journal of business research96, pp.228-237.

Boldosova, V. and Luoto, S., 2019. Storytelling, business analytics and big data interpretation: Literature review and theoretical propositions. Management Research Review.

Chen, L. and Nath, R., 2018. Business analytics maturity of firms: an examination of the relationships between managerial perception of IT, business analytics maturity and success. Information Systems Management35(1), pp.62-77.

Chiang, R.H., Grover, V., Liang, T.P. and Zhang, D., 2018. Strategic value of big data and business analytics.

Conboy, K., Mikalef, P., Dennehy, D. and Krogstie, J., 2020. Using business analytics to enhance dynamic capabilities in operations research: A case analysis and research agenda. European Journal of Operational Research281(3), pp.656-672.

Delgosha, M.S., Hajiheydari, N. and Saadeatmantesh, H., 2020. Semantic structures of business analytics research: applying text mining methods. Information Research25(2).

Esswein, M. and Chamoni, P., 2018. Business Analytics in Finance Department–A Literature Review. Muticonferenz Wirtschaftsinformatik, Luneburg.

Grover, V., Chiang, R.H., Liang, T.P. and Zhang, D., 2018. Creating strategic business value from big data analytics: A research framework. Journal of Management Information Systems35(2), pp.388-423.

Hindle, G.A. and Vidgen, R., 2018. Developing a business analytics methodology: A case study in the foodbank sector. European Journal of Operational Research268(3), pp.836-851.

Junior, C.H., Oliveira, T. and Yanaze, M., 2019. The adoption stages (Evaluation, Adoption, and Routinisation) of ERP systems with business analytics functionality in the context of farms. Computers and electronics in agriculture156, pp.334-348.

………………………………………………………………………………………………………………………..

Know more about UniqueSubmission’s other writing services:

Assignment Writing Help

Essay Writing Help

Dissertation Writing Help

Case Studies Writing Help

MYOB Perdisco Assignment Help

Presentation Assignment Help

Proofreading & Editing Help

 

 

Leave a Comment