Assignment Sample on Data-Driven Decisions For Business

1. Introduction 

This data-driven decision-making process using to make the information and also helps to verify the decisions. This process is used to drive the growth of the business strategy. Using the KPIs tools, the company can reduce all discrimination and biases and make better managerial rules that will be aligned with the business strategies. According to the scenario, it has shown that the company COTS has high competitive advantages in the UK market over the other company. They have tried to develop the business strategy through the use of the KPI model and also they implemented modern technology and data-driven process, COTS has used the data analytics tool for monitoring the business strategy. That helps to make the strong decision-making process and data analytic tool apply to effectively improve the business strategy. COTS Coffee expanded its business in different cities in the UK such as Poole, Portsmouth, Plymouth, and so on.

Business intelligence software users have been empowered without deep-rooted technical expertise that can easily analyze and extract useful conclusions from the better information that has been taken after using the analytical tools (Cavalcante et al. 2019). Overall protection plans, included in these steps, regarding this project, plan the Actions of this study, its time, and its budgets are also discussed for knowing about the better criteria:

Stages Methods/ Tools Advantages
Web Scraping  Oxylabs Scraping API It helps to extract the data and reduces the cost by up to 90%
Data modeling  Object Oriented data model It helps to make the theoretical representation and analyze the various data
Preparing and cleaning data Combining the multiple data Through this relevant data has been collected for knowing the operational system
Deploying the software visualization Software applications, using heat maps for the data analysis It helps to understand the trends and knowing patterns of data
Evaluating the model Hold-out and Cross-validation Through this analyzing the performance during the training

Table 1: Project plan of COTS coffee shops

Get Assignment Help from Industry Expert Writers (1)

(Source: Self-created)

Through the analysis of the scenario, this company made their business 15 years ago to mitigate their vision which is depending on the relaxing environment in the UK. These cafes have been found in Italy and the France coasts areas from this place they have successfully run their business through the 15 chains of cafes. Data-based analysis and decision-making approach helps to optimize performance and predicted future results based on data (Ahn and Lin, 2019). This process uses for making the test that brings the success of the different strategies and generates information for taking the decision and growing sustainability. COTS coffee company has made a 6% of high profit according to the 4% of increasing productivity after the “data-driven approach”.

Data-Driven Decisions For Business Performance measurement model

Figure 1: Performance measurement model

(Source: Fu et al. 2020)

As become a future employer it is very necessary to know the corporate strategy and understand the numerical data for use in analytical tools. Through this approach, the working opportunity will be increased and helps to make employability and generate self-confidence through the improvement of working ability (Hamoud et al. 2021). These digital data-driven tools decide as per the connection of the marketing trends and focused on the whole industry. In case it is significant to understand the trending patterns and always be informed to decide to make the competitive advantages, and profits at all times.

Get Assignment Help from Industry Expert Writers (1)

Sales revenue, volume, customer satisfaction, and productivity are included in the KPIs for this coffee shop. According to consumer behavior productivity and employability improved against the KPIs model. Customer data has been analyzed for knowing about the trends, increase sales, and improved offering strategy. Performance-related data has been analyzed for identifying the issues of productivity, through this providing training for developing employability that helps to mitigate customer satisfaction and increase productivity.

2. Data quality issues and remedies 

Analyzing the data has shown that, in Poole City, they have not taken any data from a single professional person. The lack of sales volume and sales value is also 0 in this part. In Pooleham, the research only collected data based on young people, and single professional people otherwise; in 2021 other market segments have not been discussed. Analyzing the other segment, data is not available. In Poole City, in 2021 only 1-month data has been collected for this reason, the sales revenue and volume both has been decreased.

The single professional segment has described in 2021 for 2 months in Pooleham, and a lack of sales value and volume has been seen. According to the segment of retired people, the sales value is 100, based on the 4 months of data in 2021 (Kamble et al. 2020). A lack of 42, 65, and 34 sales volumes has been seen in Poole City under the segments of Single professionals, married couples, and children with families. These data have been taken from the 9 months analysis, the sales value also increasing averagely. In Pooleham professional segment of data is not enough to know the selling value and volume. For 5 months of the information under the Turistas, the sales value is only 18 (Czvetkó et al. 2022). 138 is the sales volume of Young people segments in Newquay and its sales value is negatively running this is a major issue to demonstrate the data quality. In Newquay, Retired people related to 3 months of data have not been found, and for this reason, the sales value and volume both is 0. In Plymouth, retired people and Married young couples related 4 to 5 months of sales value and volume both are negatively running.

3. Data analysis and commentary

This section has aimed to provide an overview of the assessment of the recent market position of COTS coffee and the additional dimensions of the values that have been strategic for the assessment of the sales volume and sales value of the organization by month for 3 periods. Sánchez-Romero et al. (2020), opined that additional dimensions of the inclusive statistical analysis will be relevant in monitoring the sales volume and sales data of the organization.

Sales volume and value by month, by year, and across the 3 years

The following table is found to be relevant in terms of determining the sales standards of the organization with the inclusion of mean, median, mode, standard deviation, kurtosis, and skewness management. Additionally, Ma et al. (2020), opined that inclusion of the statistical data analysis is effective in monitoring the primary sales data of the organization.

Year Month Sales Volume Sales Value
Mean 2019.064257 Mean 6.512048193 Mean 59.42771084 Mean 69500.24327
Standard Error 0.042731618 Standard Error 0.155599621 Standard Error 3.380744835 Standard Error 4619.29279
Median 2019 Median 7 Median 27 Median 32721.26
Mode 2020 Mode 1 Mode 1 Mode 0
Standard Deviation 0.953595098 Standard Deviation 3.472347709 Standard Deviation 75.44440966 Standard Deviation 103083.7388
Sample Variance 0.909343612 Sample Variance 12.05719861 Sample Variance 5691.858949 Sample Variance 10626257210
Kurtosis 33.03170178 Kurtosis -1.220505589 Kurtosis 9.346613464 Kurtosis 20.05450741
Skewness 2.946474074 Skewness -0.015879706 Skewness 2.560278279 Skewness 3.636690272
Range 12 Range 11 Range 611 Range 1179176.77
Minimum 2018 Minimum 1 Minimum -1 Minimum -167971.71
Maximum 2030 Maximum 12 Maximum 610 Maximum 1011205.06
Sum 1005494 Sum 3243 Sum 29595 Sum 34611121.15
Count 498 Count 498 Count 498 Count 498
Confidence Level (95.0%) 0.083956884 Confidence Level (95.0%) 0.305714128 Confidence Level (95.0%) 6.642313445 Confidence Level (95.0%) 9075.74872

Table 2: Sales Volume and Sales Data

(Source: MS-Excel)

The analysis has reflected that depending upon the month and sales volume the value of the STD error is considered to be 0.15 and 3.38 additionally the value of the median has been 27 and the mode is considered to be 1. Further, the dimensions of the STD deviation have been 75.44 along with the sample variance has been 5691.85. Moving further, the value for Kurtosis is considered to be 9.34 and Skewness reflects a value of 2.56 further the maximum and minimum values along with the sum and count reflected a value of 610 for a count of 498. Cooper (2020), opened that for any value of skewness, more than 2 reflects a value of Kurtosis of more than 1 and hence can be considered to be strategic for reflecting a standard measure in terms of sales volume and sales data.

Benchmark comparisons of market segments’ performance

Zhang et al. (2020), opined that benchmark comparison is considered to be the primary approach in terms of monitoring the dimensions of the market segmentation, and the performance of the data is based on the market segmentation. Further, the following table reflects the strategic dimension of the market segmentation.

Sales Volume Sales Value Benchmark Volume Benchmark Value
Mean 59.40763 Mean 69540.81 Mean 71.73293 Mean 158580.4
Standard Error 3.381429 Standard Error 4620.247 Standard Error 5.233263 Standard Error 11236.39
Median 27 Median 32721.26 Median 27 Median 45697
Mode 1 Mode 0 Mode 6 Mode 45697
Standard Deviation 75.45967 Standard Deviation 103105 Standard Deviation 116.785 Standard Deviation 250750.2
Sample Variance 5694.161 Sample Variance 1.06E+10 Sample Variance 13638.75 Sample Variance 6.29E+10
Kurtosis 9.339806 Kurtosis 20.03035 Kurtosis 38.22215 Kurtosis 32.7771
Skewness 2.559075 Skewness 3.633836 Skewness 5.059945 Skewness 4.355079
Range 611 Range 1179177 Range 1116 Range 2545981
Minimum -1 Minimum -167972 Minimum 3 Minimum 336
Maximum 610 Maximum 1011205 Maximum 1119 Maximum 2546317
Sum 29585 Sum 34631325 Sum 35723 Sum 78973032
Count 498 Count 498 Count 498 Count 498

Table 3: Benchmark Value

(Source: MS-Excel)

The value of the mean is considered to be 71.73 and additionally, the STD error is found to be 5.23; further, the determinants of the sample variance are found to be 13638.74. Further, the value of the kurtosis reflects more than 9 values for a higher value than 2 for skewness. Verenich et al. (2019), opined that these values of benchmark and skewness are strategic in reflecting a positive dimension.

 Benchmark comparisons of sales volume and value

Maulud and Abdulazeez (2020), opined that the additional dimension of the Quarter-wise analysis of benchmark value is strategic in reflecting the dimensions of the growth as well as the fall of sales value and sales volume.

  Sales Value Benchmark Value Sales Volume Benchmark Volume
1st Quarter 8813658 17915666 7596 8941
2nd Quarter 9573560 17794036 8080 7986
3rd Quarter 9267934 18276127 7925 9450
4th Quarter 6976173 24987203 6006 9346

Table 4: Quarterlies Benchmark value

(Source: MS-Excel)

The above table reflects the fact that the 4th quarter reflects the highest benchmark value reflecting a standardized measure of 24987203 in terms of sales value; additionally, the benchmark value for the sales volume is considered to be highest in the 4th quarter. This hike can be considered to be reflecting the highest sales standards with the addition of complementary new products.

4. Data charting and commentary 

Czoli et al. (2019), opined that the analysis of the sales-related performance of the coffee shop industry is found to be relevant in terms of addressing the market segmentation of the organization.

Market segments performance comparisons between coffee shops

Dharmayanti and Darma (2020), have included that the comparative analysis can be considered to be one of the primary inclusive purposes in assessing the market performance of coffee shops. The following figure is considered to be relevant in reflecting the market performance of the Nerwquay coffee shop market.

This can be included that among these 3 years hot drinks experience the highest sales with the highest value of that of higher than 800 followed by the sales of cold drinks with a value of almost near to 1000 for current year assessment will elevate sales standards.

The following graph is found to be reflecting the market performance across the Poole Market.

This can be included that, initially the Poole market has been experiencing huge sales of cold drinks, coffee, cakes, and pastries are considered to be the highest preferred products across this market.

The following chart reflects the Plymouth market performance and reflects the preference for the products.

This market has experienced the highest sales of cakes in the mediator year and this is followed by the sales of cold drinks and hence this can be included that, later pastries have become one of the primary choices of customers reflecting near to 4000 value. Additionally, they have failed to retain their position across the market in the long run showing low sales across the market.

Impact of the addition of the two new product ranges to Plymouth’s menu and in comparison with the other two cities

This can be considered that the inclusion of a new breakfast menu across Plymouth’s market has elevated the sales standards across this region. Despite that, the other two sectors failed to incorporate this menu and might have reflected lower sales standards across the UK market.

In this graph, Poole’s sales value is high, because in this city the new products have been launched and the other cities’ sales value decreasing.

From this pie chart, it has been shown that the sales value of Poole is 42%, and the city of Plymouth and Newquay has only 26% and 32% of sales value has been assessed.

According to the bar graph sales volume is increasing in Newquay from the other city of Poole and Plymouth.

Figure 8 it has shown that the sales value is 11391 in Newquay and 7,133 in Poole and 11,061 in Plymouth.

5. Conclusion and Recommendations

The “Café on the Sea (COTS) Coffee Shop” is a UK-based cafe company. It can be concluded from the above information that employees are satisfied with the work-life provided. The environment in which the workers are working is soothing and pleasant. The company is achieving its goals in various aspects. It has successfully established fifteen cafes in fifteen years with amazing seaside locations in the UK. Regarding the hiring process in the management system of the business, the company is recruiting highly qualified candidates. The candidates in the management are highly skilled and knowledgeable to handle the role of data analytics in the company. Data analytics comes from reputed universities after acquiring a strong background in academics. People who are employed here, not only working but learning new skills daily, which are going to enhance their skills in the future. The company is searching for new options every day to increase its growth. They are also trying to have new locations for their branches both in the UK and abroad.

Regarding the sales performance of the company, the overall sales value is more as compared to the sales volume. During the third quarter, the sales value is more in the company. There are three best places in which they have their branch, from where they are facing the highest competition. The places are Poole, Plymouth, and Newquay. Among these three places, Poole is the one contributing to the highest amount of overall sales value of the company. But the sales volume is highest in the branch of Newquey. Thus the branch present in the city of Poole is collecting the highest amount of revenue for the firm. After analyzing the given facts there are much more investment is required in the branch of Plymouth. The healthy snacks requirement of the customers should be fulfilled otherwise the various food items are quite impressive in the Plymouth branch.

This business analytical tool is essential for the business because it helps to make continuous business growth and generate innovative knowledge that helps to improve employability. It has developed the communication strategy in the organization because through this the organization has made a positive environment and made revenue for developing the organizational goals. Through this approach, organizations can access unrivaled adaptability, and for better expansion, the organization has increased new business opportunities.

The recommendations for future enhancement of the “COTS Coffee shop” can be,

  • The cafes on the various coasts of the UK should be easily accessible to the customers, who are staying in inner cities.
  • While opening a new branch of the cafe the place should not be far away from the main cities of UK as well as the other branches opened in abroad.
  • Customer requirements should be the priority of the cafe. The issue raised by a customer regarding the need for a healthy snack on the menu should be fulfilled.
  • There should be a variety of food items present on the menu to attract customers coming from various regions of the world.
  • There should be food items from different cuisines of the world, for example, Indian cuisine breakfasts should be included.
  • In this world of connectivity, the cafe should provide a service of free Wi-Fi (Fauzi al 2019). This will draw more customers from the young generations and working professionals.
  • The cafe should have a feedback mechanism at the end of every service for better improvement.

References

Ahn, Y. and Lin, Y.R., 2019. Farsight: Visual analytics for fairness in decision making. IEEE transactions on visualization and computer graphics26(1), pp.1086-1095.

Cavalcante, I.M., Frazzon, E.M., Forcellini, F.A. and Ivanov, D., 2019. A supervised machine learning approach to data-driven simulation of resilient supplier selection in digital manufacturing. International Journal of Information Management49, pp.86-97.

Cooper, M., 2022. Longer Males Determined with Positive Skew and Kurtosis in Centrobolus (Diplopoda: Spirobolida: Pachybolidae). New Visions in Biological Science Vol8, pp.102-106.

Czoli, C.D., Jones, A.C. and Hammond, D., 2019. Trends in sugary drinks in Canada, 2004 to 2015: a comparison of market sales and dietary intake data. Public Health Nutrition22(15), pp.2723-2728.

Czvetkó, T., Kummer, A., Ruppert, T. and Abonyi, J., 2022. Data-driven business process management-based development of Industry 4.0 solutions. CIRP journal of manufacturing science and technology36, pp.117-132.

Dharmayanti, P.D. and Darma, G.S., 2020. The use of instagram in coffee shop. International Research Journal of Management, IT and Social Sciences7(4), pp.48-56.

Fauzi, R.U.A., 2019. The role of free wireless fidelity (Wi-Fi) service, food quality, and servicescape toward customer satisfaction. Asian journal of social science research2(2).

Fu, J., Kumar, A., Nachum, O., Tucker, G. and Levine, S., 2020. D4rl: Datasets for deep data-driven reinforcement learning. arXiv preprint arXiv:2004.07219.

Hamoud, A.K., Marwah, K.H., Alhilfi, Z. and Sabr, R.H., 2021. Implementing data-driven decision support system based on independent educational data mart. International Journal of Electrical and Computer Engineering11(6), p.5301.

Kamble, S.S., Gunasekaran, A. and Gawankar, S.A., 2020. Achieving sustainable performance in a data-driven agriculture supply chain: A review for research and applications. International Journal of Production Economics219, pp.179-194.

Ma, C., Rogers, J.H. and Zhou, S., 2020. Global economic and financial effects of 21st century pandemics and epidemics. Covid Economics5, pp.56-78.

Maulud, D. and Abdulazeez, A.M., 2020. A review on linear regression comprehensive in machine learning. Journal of Applied Science and Technology Trends1(4), pp.140-147.

Sánchez-Romero, L.M., Canto-Osorio, F., González-Morales, R., Colchero, M.A., Ng, S.W., Ramírez-Palacios, P., Salmerón, J. and Barrientos-Gutiérrez, T., 2020. Association between tax on sugar sweetened beverages and soft drink consumption in adults in Mexico: open cohort longitudinal analysis of Health Workers Cohort Study. bmj369.

Verenich, I., Dumas, M., Rosa, M.L., Maggi, F.M. and Teinemaa, I., 2019. Survey and cross-benchmark comparison of remaining time prediction methods in business process monitoring. ACM Transactions on Intelligent Systems and Technology (TIST)10(4), pp.1-34.

Zhang, C., Ouyang, J., Wang, C. and Wise, S.M., 2020. Numerical comparison of modified-energy stable SAV-type schemes and classical BDF methods on benchmark problems for the functionalized Cahn-Hilliard equation. Journal of Computational Physics423, p.109772.

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