1686568368NTGR1716632#YS
1686568368NTGR1716632#YS
1686568368NTGR1716632#YS
Student Reference
Number
(SRN)
I hereby declare that I have read and understood BPP’s regulations on plagiarism and that
this is my original work, researched, undertaken, completed and submitted in accordance
with the requirements of BPP School of Business and Technology.
The word count, excluding contents table, bibliography and appendices, is ______ words.
By submitting this coursework, you agree to all rules and regulations of BPP regarding
assessments and awards for programmes.
Please note that by submitting this assessment you are declaring that you are fit to sit this
assessment.
BPP University reserves the right to use all submitted work for educational purposes and may
request that work be published for a wider audience.
Table of Contents
Introduction:...............................................................................................................................1
Recommendations:...............................................................................................................16
Conclusion................................................................................................................................17
References:...............................................................................................................................19
Executive summary
This executive summary provides an overview of Café on the Sea (COTS), a beachfront café
chain founded by Sebastian Rodriguez. The report aims to analyze COTS' current business
model and assess its potential for expansion and growth. As an information expert, your job
is to direct a complete investigation and present discoveries and proposals to the Corporate
Methodology Division.
The report structure comprises of a few segments. The presentation gives a short foundation
of Bunks, featuring its set of experiences and vision as a chain of beach front bistros in the
UK. The context emphasizes the company's expansion plans and the need for data analysis in
strategic decision-making.
The approach section outlines the research methodology, including data collection methods,
sources, and tools used in the analysis. It emphasizes the importance of utilizing your
expertise in data analysis gained from your MSc in Administration degree.
The current business model assessment evaluates COTS' ongoing business model,
considering factors such as revenue streams, target market, competitive landscape, and value
proposition. Strengths, weaknesses, and potential limitationsor difficulties of the ongoing
model are distinguished, with an emphasis on extension and learning open doors.
The expansion and growth options section provides an overview of the various expansion
opportunities being considered by COTS, including international expansion, new product
development, and diversification into new business areas. Each option is examined in terms
of its potential benefits, risks, and alignment with COTS' vision and market positioning. The
appropriateness of the ongoing plan of action for accomplishing development goals is
resolved in light of the assessment of the ongoing model and extension choices.
Introduction:
Café on the Sea (COTS) is pretty much as charming as the beachfront breeze that motivated
its commencement. Established in 2005 by famous restaurateur and visionary, Sebastian
Rodriguez, Beds was conceived out of profound energy for both culinary greatness and the
hypnotizing charm of the sea (Bulger et. al. 2014).
Sebastian, a long-lasting admirer of the ocean, spent his young life investigating beachfront
towns and harbors, submerging himself in the energetic culture and flavors they brought to
the table. It was during these early stages that he fostered a significant appreciation for the
special concordance between seaside living and gastronomy (Power, 2008).
By directing a thorough examination, you will give experience in the exhibition of these
bistros and distinguish regions for development. Your discoveries will assist Bunks with
settling on educated choices regarding the future course of their business, whether it includes
growing to new areas, presenting new items, or expanding into new business regions (Carillo
et. al. 2019).
As an information examiner, your job is basic in supporting Beds' key dynamic cycle. By
utilizing your scholarly foundation and viable involvement with information examination,
you have the potential chance to add to the organization's development and achievement.
Your MSc in Administration degree from BPP College shows your aptitude for breaking
1
down complex informational indexes and making an interpretation of them into significant
experiences (Heilig et. al. 2020).
Presentation
Momentarily present the motivation behind the report and its importance for Beds.
Give an outline of Beds, its set of experiences, and its vision as a chain of coastline
bistros in the UK.
Make sense of the setting of the report, featuring the organization's extension plans
and the requirement for information examination in essential direction.
Approach
Assess the on-going plan of action of Beds, taking into account factors, for example,
income streams, target market, serious scene, and incentive.
Evaluate the qualities and shortcomings of the ongoing plan of action with regards to
extension and useful learning experiences.
Distinguish any impediments or difficulties that the ongoing plan of action might
posture for accomplishing the organization's essential goals.
2
Expansion and Growth Options
Give an outline of the different extension and development choices being considered
by Beds, including extending abroad, new item advancement, and expansion into new
business regions.
Examine every choice concerning its likely advantages, dangers, and arrangement
with Beds' vision and market situating.
Based on the assessment of the current business model and the expansion options,
determine the suitability of the current business model for achieving the desired
growth and expansion (Elgendy et. al. 2022).
Present findings and insights regarding the alignment between the current business
model and the expansion objectives.
Objective:
The goal of this venture plan is to lay out an informal investigation structure for Bistro on the
Ocean (Beds) to address the core business questions doled out to us. This system will
empower Bunks to use its information resources successfully and determine noteworthy
experiences to upgrade functional productivity, consumer loyalty, and by and large business
execution (Hupperz et. al. 2021).
1. Data Collection:
- Identify relevant data sources: This includes transactional data (sales, orders),
customer data (demographics, preferences), operational data (inventory, staff), and
external data (weather, events).
Implement data capture mechanisms: Deploy systems and processes to collect and store
data in a structured format, ensuring data integrity and security (Rokade et. al. 2022).
- Select an appropriate data storage solution: Evaluate and choose a database or data
warehouse system that can efficiently handle the volume, variety, and velocity of
COTS' data.
3
- Establish data governance policies: Define data ownership, access controls, and
data retention policies to ensure data quality and compliance with regulations (e.g.,
GDPR).
- Interpret and communicate insights: Analyze the results of the data analysis and
displaying stage, and make an interpretation of them into significant bits of
knowledge and noteworthy proposals.
- Collaborate with COTS management: Engage with key stakeholders to discuss and
implement the recommended actions, aligning them with COTS' strategic goals and
objectives.
Café on the Sea (COTS) can leverage the data analytics framework outlined above to address
its core business questions effectively:
4
- Produce bits of knowledge on client conduct, inclinations, and fulfilment levels to
customize contributions and further develop the general client experience (Vögler et.
al. 2017).
Sales Revenue: One of the essential KPIs for any business is income. An improved
examination can give experiences into deal patterns, client inclinations, and evaluating
methodologies. By breaking down deal information, Bistro on the Ocean can recognize high-
5
performing items, streamline valuing, and foster designated showcasing efforts to build deals
and income.
Customer Satisfaction: Estimating consumer loyalty is significant for holding clients and
driving recurrent business. Analytics can help Café on the Sea collect and analyze customer
feedback data from sources like surveys, online reviews, and social media. By distinguishing
examples and feelings in client criticism, the café can resolve issues immediately, further
develop administration quality, and upgrade general speaking consumer loyalty (Goforth et.
al. 2022).
Customer Acquisition and Retention: Tracking the number of new customers acquired and
the rate of customer retention is important for sustained growth. Improved analytics can
provide insights into customer acquisition channels, customer demographics, and customer
behavior patterns. Bistro on the Ocean can use this data to target advertising endeavors,
distinguish potential client portions, and foster dependability projects to hold existing
customers.
Average Transaction Value: Increasing the average transaction value can significantly
impact revenue. Analytics can help Café on the Sea analyze transaction data to identify
opportunities for upselling and cross-selling. By understanding client inclinations and buy
designs, the café can customize suggestions and upgrade its menu and estimating systems to
support higher spending per exchange.
Operational Efficiency: Effective activities are basic for benefit. An examination can help
Bistro on the Ocean screen and improve different functional perspectives, like stock
administration, staffing levels, and store network effectiveness. By utilizing information
investigation, the bistro can distinguish bottlenecks, smooth out processes, diminish costs,
and work on general functional productivity (Maschke et. al. 2022).
6
In summary, improved examination empowers Bistro on the Ocean to pursue information
driven choices and enhancements against these KPIs. By utilizing information and
experiences, the bistro can advance its tasks, upgrade consumer loyalty, increment deals, and
drive overall business growth (Kirsh and Joy, 2020).
d. Data Cleaning: Raw data often requires extensive cleaning to remove inconsistencies,
errors, and inaccuracies. This cycle includes errands like revising incorrect spellings,
normalizing designs, dealing with missing qualities, and settling information inconsistencies
across sources.
e. Data Privacy and Security: Data analysts must be mindful of privacy regulations and
ensure that sensitive information is protected. This may involve anonym vitality or
aggregating data to maintain confidentiality while still enabling meaningful analysis (Ahmed
et. al. 2017).
7
It is vital to take note of that without explicit insights concerning the undertaking
information, giving exact solutions is testing However, here are some common issues and
potential strategies to address them:
a. Missing Data: Assuming the venture data contains missing qualities, a few methodologies
can be utilized. One choice is to ascribe missing data utilizing methods like mean attribution,
relapse ascription, or prescient demonstrating. Another approach is to consider excluding
incomplete cases or variables if the missing ness is substantial and impacts the analysis
(Demchenko et. al. 2013).
d. Data Integrity: To guarantee information uprightness, information experts can carry out
approval checks and lead information compromise works out. This includes contrasting
information across various sources or cross-checking against outside benchmarks to
recognize and correct any irregularities or blunders.
e. Data Documentation: It is crucial to have clear documentation that describes the data
sources, data cleaning and transformation steps, and any assumptions made during the
process. This documentation guarantees straightforwardness, reproducibility, and simplicity
of coordinated effort among colleagues (Coates et. al. 2017).
8
Figure 3 6 Common Data Quality Issues
Missing data: This problem occurs when one or more data points are missing from the
dataset. To address this, you can consider imputation techniques such as mean, median, or
regression accusation or you can remove the rows or columns with missing data depending
on the significance of the missing values (Childs et. al. 2005).
Outliers: Outliers are data points that significantly deviate from the normal distribution of
the dataset. They can skew statistical analysis and modelling results. Identifying outliers can
be done using statistical methods like the Z-score or the interquartile range (IQR). Addressing
outliers may involve removing them if they are data entry errors or transforming them if they
are valid but extreme values.
Inconsistent or incorrect data: This issue refers to data that doesn't adhere to the expected
format or violates logical constraints. It can include misspellings, inconsistent date formats,
or contradictory information. To address this problem, you can use data cleaning techniques
such as regular expressions, fuzzy matching, or domain-specific validation rules.
9
Duplicates: Duplicates occur when there are multiple identical or very similar records in the
dataset. They can lead to biased analysis or model training. Detecting duplicates can be done
by comparing records based on specific attributes or using similarity measures. Eliminating
duplicates can involve removing them or merging them into a single representative record.
Inaccurate or out-dated data: Data can become inaccurate or out-dated over time,
especially if the dataset is not regularly updated. This problem can be identified by
comparing the data with reliable external sources or conducting periodic audits. To address
this, you can update the dataset with the most recent information or indicate the data's
validity period (Gichoya, 2005).
Incomplete or inconsistent data: This problem occurs when the dataset lacks certain
attributes or exhibits inconsistencies in attribute values. It can make analysis or modelling
challenging. Addressing this issue involves carefully examining the dataset structure,
validating the data against expected patterns, and making necessary corrections or
enhancements.
It's important to note that the specific data problems in the "Café on the Sea" dataset can only
be identified by examining the dataset itself. The proposed solutions may vary depending on
the nature of the data and the specific analysis or modelling goals (Assunção et. al. 2015).
Blackpoo
Subtype l Portsmouth Southampton Subtype Blackpool Portsmouth Southampton
Coffee 10336 6126 5336 Coffee 2584 1802 1334
Cold Drinks 4210 2921 2073 Cold Drinks 1684 1169 829
Hot Dirnks 2492 1830 1154 Hot Dirnks 1246 915 577
Cakes 3830 2843 1920 Cakes 766 569 384
Pastry 2744 2487 1736 Pastry 1543 1244 868
Sandwiches 2952 2277 1476 Sandwiches 492 380 246
Total 26564 18484 13695 Total 8315 6079 4238
Table A: Sales Trends Analysis
The table provided presents sales values and sales volume data for different subtypes in three
locations for the year 2020. The data is divided into two sections: Sales Values and Sales
Volume.
10
Subtype: This column lists the different subtypes of products sold, including Coffee, Cold
Drinks, Hot Drinks, Cakes, Pastry, and Sandwiches.
Blackpool, Portsmouth, and Southampton: These columns represent the sales values (in an
unspecified currency) for each subtype in the respective locations. For example, in
Blackpool, the sales values for Coffee, Cold Drinks, Hot Drinks, Cakes, Pastry, and
Sandwiches were 10,336, 4,210, 2,492, 3,830, 2,744, and 2,952, respectively.
Subtype: This column lists the same subtypes of products as in the Sales Values section.
Blackpool, Portsmouth, and Southampton: These columns represent the sales volume for
each subtype in the respective locations. For example, in Blackpool, the sales volume for
Coffee, Cold Drinks, Hot Drinks, Cakes, Pastry, and Sandwiches were 2,584, 1,684, 1,246,
766, 1,543, and 492, respectively.
The "Total" row at the bottom of each section provides the sum of sales values and sales
volume across all subtypes for each location. For example, the total sales value in Blackpool
is 26,564, while the total sales volume is 8,315.
It's worth noting that without additional context or information, it's difficult to interpret the
significance of these numbers. The table simply provides data on sales values and sales
volume for different product subtypes in different locations.
11
- The values in this section represent the total sales value (in currency units) for each subtype
in the specified locations.
- For example, in Blackpool, the sales values for Coffee, Cold Drinks, Hot Drinks, Cakes,
Pastry, and Sandwiches were 10,600, 3,865, 2,616, 4,050, 3,508, and 3,192, respectively.
- The corresponding sales values for each subtype in Portsmouth and Southampton are also
provided in the table.
- This section presents the sales volume (number of units sold) for each subtype in the
specified locations.
- For instance, in Blackpool, the sales volume for Coffee, Cold Drinks, Hot Drinks, Cakes,
Pastry, and Sandwiches were 2,650, 1,699, 1,308, 810, 1,754, and 532, respectively.
- The sales volume for each subtype in Portsmouth and Southampton is also included in the
table.
The table allows for comparisons between the sales performances of different subtypes within
each location, as well as comparisons across the entire year and analysis period. It provides
insights into the relative performance of each subtype in terms of both sales volume and
value, enabling further analysis and decision-making related to sales strategies, product focus,
and market trends.
Sales Values:
12
The sales values section shows the total sales value for different subtypes of products in three
markets: Blackpool, Portsmouth, and Southampton. The subtypes of products include Coffee,
Cold Drinks, Hot Drinks, Cakes, Pastry, Sandwiches, and a Total value. The values represent
the monetary worth of sales in each market for each subtype of product.
Similarly, the table provides the sales values for Portsmouth and Southampton for each
quarter of 2022.
Sales Volume:
The sales volume section shows the total sales volume for the same subtypes of products in
the three markets. It represents the number of units sold for each subtype of product in each
market.
Similarly, the table provides the sales volume for Portsmouth and Southampton for each
quarter of 2022.
The table also provides a total value for each subtype and total sales value for all subtypes
combined across the whole analysis period (presumably for the year 2022). Similarly, it
provides the total sales volume for each subtype and the total sales volume for all subtypes
combined across the whole analysis period.
This table allows for a comparison of sales volume and value between different markets by
quarter, by year (2022), and across the entire analysis period. It provides insights into the
performance of different subtypes of products in each market and allows for tracking trends
and making comparisons based on sales volume and value.
13
Sales Volumes 2020
20000
16000
12000
8000
4000
0
1 2 3 4 5 6 7
In year 2020 more sales volumes and values are generated from Blackpool in
comparisons to Portsmouth and Southampton.
This sales of coffee is higher than other products.
14
Sales Volumes 2021
10000
8000
6000
4000
2000
0
1 2 3 4 5 6 7
In year 2021 Sales volumes and sales values are increases for all the products
from previous year.
Here also more sales are coming from Blackpool then other areas.
15
Sales Volumes 2022
12000
10000
8000
6000
4000
2000
0
1 2 3 4 5 6 7
In year 2022 also Sales volumes and sales values are increases for all the
products from previous years.
Demand of coffee is increased in year 2022 from previous two years.
Compare sales values and volumes across subtypes and locations in 2020.
Identify top-performing subtypes in each location.
Look for significant differences and patterns in sales trends.
Investigate factors influencing sales performance (e.g., promotions, pricing, and
seasonality).
16
Compare Sales Performance:
Utilize sales performance comparison data for 2021 to assess subtype performance
across locations.
Identify subtypes with improved or declined sales values and volumes.
Analyze differences in sales performance between locations.
Consider external factors like market conditions, preferences, and competition.
Analyze sales volume and value data for 2022 across markets and quarters.
Identify seasonal patterns and fluctuations for each subtype and location.
Compare sales volume and value between markets and quarters.
Look for correlations and trends to understand pricing and customer behavior.
Provide recommendations for adjusting product focus, refining sales strategies, and exploring
new market opportunities.
Conclusion
In conclusion, Café on the Sea (COTS) is a beachfront eatery network in the UK that was
established with a profound enthusiasm for culinary greatness and the charm of the ocean.
The organization is presently hoping to extend and develop its business, and as an
information expert, your job is vital in giving experiences and proposals to help their
essential direction.
The project plan outlined the purpose of the report, which is to analyze COTS' current
business model and assess its potential for expansion and growth. The report structure
covered different viewpoints, including the evaluation of the ongoing plan of action, ID of
extension choices, and the improvement of an information investigation system to address
core business questions.
17
The data analytics framework provided a comprehensive plan for data collection, storage,
analysis, visualization, and reporting. It featured the significance of distinguishing applicable
information sources, carrying out information catch systems, choosing fitting information
stockpiling arrangements, and laying out information administration approaches.
Furthermore, it emphasized the need to recognize core business questions, select suitable
analysis methods, design interactive dashboards, and interpret insights for meaningful
recommendations.
18
References:
Ahmed, H., Jilani, T.A., Haider, W., Abbasi, M.A., Nand, S. and Kamran, S., (2017).
Establishing standard rules for choosing best KPIs for an e-commerce business based on
google analytics and machine learning technique. International Journal of Advanced
Computer Science and Applications, 8(5).
Assunção, M.D., Calheiros, R.N., Bianchi, S., Netto, M.A. and Buyya, R., (2015). Big Data
computing and clouds: Trends and future directions. Journal of parallel and distributed
computing, 79, pp.3-15.
Berndtsson, M., Forsberg, D., Stein, D. and Svahn, T., (2018). Becoming a data-driven
organisation. In 26th European Conference on Information Systems (ECIS2018), Portsmouth,
United Kingdom, June 23-28, 2018.
Bulger, M., Taylor, G. and Schroeder, R., (2014). Data-driven business models: challenges
and opportunities of big data. Oxford Internet Institute. Research Councils UK: NEMODE,
New Economic Models in the Digital Economy.
Carillo, K.D.A., Galy, N., Guthrie, C. and Vanhems, A., (2019). How to turn managers into
data-driven decision makers: Measuring attitudes towards business analytics. Business
Process Management Journal, 25(3), pp.553-578.
Childs, S., Blenkinsopp, E., Hall, A. and Walton, G., (2005). Effective e ‐learning for health
professionals and students—barriers and their solutions. A systematic review of the literature
—findings from the HeXL project. Health Information & Libraries Journal, 22, pp.20-32.
Coates, J.C., Colaiezzi, B.A., Bell, W., Charrondiere, U.R. and Leclercq, C., (2017).
Overcoming dietary assessment challenges in low-income countries: technological solutions
proposed by the International Dietary Data Expansion (INDDEX) Project. Nutrients, 9(3),
p.289.
Demchenko, Y., Grosso, P., De Laat, C. and Membrey, P., (2013), May. Addressing big data
issues in scientific data infrastructure. In 2013 International conference on collaboration
technologies and systems (CTS) (pp. 48-55). IEEE.
19
Elgendy, N., Elragal, A. and Päivärinta, T., (2022). DECAS: A modern data-driven decision
theory for big data and analytics. Journal of Decision Systems, 31(4), pp.337-373.
Gichoya, D., (2005). Factors affecting the successful implementation of ICT projects in
government. Electronic Journal of E-government, 3(4), pp.pp175-184.
Goforth, E., El-Dakhakhni, W. and Wiebe, L., (2022). Network analytics for infrastructure
asset management systemic risk assessment. Journal of Infrastructure Systems, 28(2),
p.04022006.
Heilig, L., Stahlbock, R. and Voß, S., (2020). From digitalization to data-driven decision
making in container terminals. Handbook of terminal planning, pp.125-154.
Hupperz, M.J., Gür, I., Möller, F. and Otto, B., (2021). What is a data-driven organization?.
In AMCIS.
Jawed, M.S. and Sajid, M., (2022), October. Cryptanalysis of Lightweight Block Ciphers
using Metaheuristic Algorithms in Cloud of Things (CoT). In 2022 International Conference
on Data Analytics for Business and Industry (ICDABI) (pp. 165-169). IEEE.
Jin, X., Wah, B.W., Cheng, X. and Wang, Y., (2015). Significance and challenges of big data
research. Big data research, 2(2), pp.59-64.
Kirsh, I. and Joy, M., (2020), June. Splitting the web analytics atom: from page metrics and
KPIs to sub-page metrics and KPIs. In Proceedings of the 10th International Conference on
Web Intelligence, Mining and Semantics (pp. 33-43).
Maschke, R.W., Pretzner, B., John, G.T., Herwig, C. and Eibl, D., (2022). Improved Time
Resolved KPI and Strain Characterization of Multiple Hosts in Shake Flasks Using Advanced
Online Analytics and Data Science. Bioengineering, 9(8), p.339.
Pham, L.M., El-Rheddane, A., Donsez, D. and De Palma, N., (2016). CIRUS: an elastic
cloud-based framework for Ubilytics. Annals of Telecommunications, 71, pp.133-140.
Rahman, Z., Kumaran Suberamanian, D., Zanuddin, H., Moghavvemi, S., Hairul, M. and
Nasir, N.B.M., (2016). Fanpage KPI analytics:“Determining the impact of KPI metrics on
20
growth rate and user base “. International Journal of Applied Engineering Research, 11(14),
pp.8098-8103.
Rokade, A., Singh, M., Malik, P.K., Singh, R. and Alsuwian, T., (2022). Intelligent Data
Analytics Framework for Precision Farming Using IoT and Regressor Machine Learning
Algorithms. Applied Sciences, 12(19), p.9992.
Sakr, S. and Elgammal, A., (2016). Towards a comprehensive data analytics framework for
smart healthcare services. Big Data Research, 4, pp.44-58.
Strohbach, M., Ziekow, H., Gazis, V. and Akiva, N., (2015). Towards a big data analytics
framework for IoT and smart city applications. Modeling and processing for next-generation
big-data technologies: with applications and case studies, pp.257-282.
Vögler, M., Schleicher, J.M., Inzinger, C. and Dustdar, S., (2017). Ahab: A cloud ‐based
distributed big data analytics framework for the Internet of Things. Software: Practice and
Experience, 47(3), pp.443-454.
Online Referenceing:
21