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
(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”.
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.
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
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 Management, 49, pp.86-97.
Cooper, M., 2022. Longer Males Determined with Positive Skew and Kurtosis in Centrobolus (Diplopoda: Spirobolida: Pachybolidae). New Visions in Biological Science Vol, 8, 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 Nutrition, 22(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 technology, 36, 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 Sciences, 7(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 research, 2(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 Engineering, 11(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 Economics, 219, pp.179-194.
Ma, C., Rogers, J.H. and Zhou, S., 2020. Global economic and financial effects of 21st century pandemics and epidemics. Covid Economics, 5, 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 Trends, 1(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. bmj, 369.
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 Physics, 423, p.109772.
Know more about UniqueSubmission’s other writing services:
