1686568368NTGR1716632#YS

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 24

BPP Business School

Coursework Cover Sheet

Module Name MSc Management

Student Reference
Number

(SRN)

Assessment Title Data Driven Decisions for Business

Please complete the yellow sections in the below declaration:

Declaration of Original Work:

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.

Student Reference Number: __________ Date: ______

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

Task 1: Project Planning............................................................................................................2

Purpose of report and Overall project Plan:...........................................................................2

COTS Data Analytics Framework:........................................................................................3

Coffee Shop KPI Analytics:...................................................................................................5

Task 2: Data quality issues and remedies..................................................................................7

(Source: Data Quality Issues, 2023)...........................................................................................8

Data Problems Identification and Solutions:..........................................................................9

Task 3: Data analysis and commentary....................................................................................10

Table A: Sales Trends Analysis........................................................................................10

Table B: Sales Performance Comparison........................................................................11

Table C: Sales Volume & Value Comparison.................................................................12

Task 4: Data charting and commentary...................................................................................13

Task 5: Conclusions and recommendations.............................................................................16

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).

Figure 1 Data-Driven Decision


(Source: Casey McGuigan, 2023)

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).

Task 1: Project Planning


Purpose of report and Overall project Plan:
The motivation behind the report is to dissect Café on the Sea's (COTS) current business
model and assess its ability to provide expansion and growth opportunities. The report
intends to give proof-based bits of knowledge and proposals to help the advancement of the
3-Year Masterful course of action for the organization. As a data analyst, your task is to
conduct a thorough analysis of the current business model and present your findings to the
Corporate Strategy Department (Berndtsson et. al. 2018).

The report structure and contents can be outlined as follows:

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

 Depict the examination technique utilized for the investigation.


 Make sense of the information assortment strategies, sources, and any apparatuses or
methods utilized in the examination.

Current Business Model Assessment

 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.

COTS Data Analytics Framework:


Project Plan: Data Analytics Framework for Café on the Sea (COTS)

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).

2. Data Storage and Management:

- 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).

3. Data Analysis and Modelling:

- Recognize core business questions: Collaborate with Bunks accomplices to


evidently portray the specific business questions and targets that should be tended to.
- Select reasonable examination strategies: Pick appropriate authentic, computer
based intelligence, or farsighted showing methods considering the possibility of the
business questions and available data (Jawed and Sajid, 2022).

4. Visualization and Reporting:

- Design interactive dashboards: Pick appropriate authentic, computer based


intelligence, or farsighted showing methods considering the possibility of the business
questions and available data.
- Enable self-service analytics: Connect with Beds accomplices to research data
independently and make altered reports using self-organization examination
instruments.

5. Insights and Significant Suggestions:

- 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.

Utilizing Café on the Sea (COTS) to Address Core Business Questions:

Café on the Sea (COTS) can leverage the data analytics framework outlined above to address
its core business questions effectively:

1. Expanding consumer loyalty:

- Dissect client input information to recognize normal issues or areas of progress.


- Use feeling investigation methods to grasp client opinions and inclinations.

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).

2. Improving functional effectiveness:

- Break down value-based information and functional measurements to distinguish


bottlenecks or failures.
- Streamline stock administration by examining deals information, request examples,
and anticipating future interest.
- Use information on staff booking and client traffic to advance asset designation and
further develop administration quality (Pham et. al. 2016).

Coffee Shop KPI Analytics:


Café on the Sea, a fictional coffee shop chain, may have several key performance indicators
(KPIs) to measure its success and monitor its performance (Strohbach et. al. 2015). While the
particular KPIs can change in light of the organization's objectives and procedures, here are
some normal KPIs for cafés and how improved examination can empower upgrades against
these KPIs:

Figure 2 Key Performance Indicators


(Source: Daan van Beek, 2023)

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).

Employee Performance: Engaged and high-performing employees contribute to a positive


customer experience. Analytics can give experiences into worker execution measurements,
for example, deals per staff part, client input on help quality, and representative booking
advancement. By utilizing investigation to distinguish regions for development and give
designated preparation, Café on the Sea can enhance employee performance and ultimately
deliver better customer service.

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).

Task 2: Data quality issues and remedies


Data Challenges & Solutions:

1. Generic Issues in Collecting, Integrating, and Cleaning Data:

a. Information Accessibility: One of the essential difficulties looked by information


investigators is the accessibility of applicable information. Information might be fragmented,
obsolete, or basically not exist for specific factors or time spans.

b. Data Quality: Guaranteeing information quality is significant for exact examination.


Issues like missing qualities, copy records, conflicting organizing, and anomalies can
influence the dependability of insightful outcomes. Data analysts need to employ techniques
such as data profiling and validation to identify and address these issues (Rahman et. al.
2016).

c. Data Coordination: Associations frequently have information put away in different


frameworks or configurations, making mix a perplexing undertaking. Data analysts must
reconcile differences in data structure, naming conventions, and data definitions to create a
unified and coherent dataset.

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).

2. Specific Issues with the Project Data and Proposed Solutions:

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).

b. Inconsistent Formats: Assuming that information factors have conflicting arrangements,


information examiners can apply information change methods to normalize them. For
instance, changing over dates into a predictable configuration or guaranteeing steady units of
estimation across factors.

c. Copies and Irregularities: Information deduplication procedures can be utilized to


recognize and eliminate copy records from the dataset. Furthermore, information profiling
and approval can assist with revealing irregularities in information section or errors between
various sources (Jin et. al. 2015).

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

(Source: Data Quality Issues, 2023)


Overall, the particular issues with the venture information will decide the proper
arrangements. Information experts ought to completely evaluate the information, team up
with the Corporate System group to explain necessities, and apply fitting information
cleaning and joining methods to guarantee the dependability and convenience of the
information for investigation (Badke-Schau and Frankenberger, 1999).

Data Problems Identification and Solutions:


"Café on the Sea" dataset or its specific data problems. However, I can provide you with a list
of common data problems that may occur in datasets in general.

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).

Task 3: Data analysis and commentary

Sales Values 2020 Sales Volume 2020

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.

Sales Values 2020:

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.

Sales Volume 2020:

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.

Sales Values 2021 Sales Volume 2021

Subtype Blackpool Portsmouth Southampton Subtype Blackpool Portsmouth Southampton


Coffee 10600 7854 5728 Coffee 2650 1964 1432
Cold Drinks 3865 2764 2148 Cold Drinks 1699 1319 859
Hot Dirnks 2616 2040 1226 Hot Dirnks 1308 1020 613
Cakes 4050 2880 1945 Cakes 810 576 389
Pastry 3508 2457 1760 Pastry 1754 1229 880
Sandwiches 3192 2304 1566 Sandwiches 532 384 261
Total 27831 20299 14373 Total 8753 6492 4434
Table B: Sales Performance Comparison
The table provides benchmark comparisons of category performance for sales volume and
value for different subtypes across various locations (Blackpool, Portsmouth, and
Southampton) for the year 2021.

Sales Values 2021:

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.

Sales Volume 2021:

- 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 2022 Sales Volume 2022

Subtype Blackpool Portsmouth Southampton Subtype Blackpool Portsmouth Southampton


Coffee 12349 8166 5476 Coffee 3087 2042 1369
Cold Drinks 5260 3439 2433 Cold Drinks 2104 1376 973
Hot Dirnks 3082 1992 1312 Hot Dirnks 1541 996 656
Cakes 4735 2955 2095 Cakes 947 591 419
Pastry 4314 2904 1962 Pastry 2157 1452 981
Sandwiches 3646 2421 1608 Sandwiches 608 404 268
Total 33386 21877 14886 Total 10444 6861 4666
Table C: Sales Volume & Value Comparison
The table provides benchmark comparisons of sales volume and value between markets by
quarter, by year, and across the whole analysis period. It includes data for the year 2022.

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.

Across the Whole Analysis Period:

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.

Task 4: Data charting and commentary

13
Sales Volumes 2020
20000
16000
12000
8000
4000
0
1 2 3 4 5 6 7

Blackpool Portsmouth Southampton

Sales Values 2020


30000
25000
20000
15000
10000
5000
0
1 2 3 4 5 6 7

Blackpool Portsmouth Southampton

Chart A: Sale volumes and sales values in 2020

 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

Blackpool Portsmouth Southampton

Sales Values 2021


30000
25000
20000
15000
10000
5000
0
1 2 3 4 5 6 7

Blackpool Portsmouth Southampton

Chart B: Sale volumes and sales values in 2021

 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

Blackpool Portsmouth Southampton

Sales Values 2022


40000
35000
30000
25000
20000
15000
10000
5000
0
1 2 3 4 5 6 7

Blackpool Portsmouth Southampton

Chart C: Sale volumes and sales values in 2022

 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.

Task 5: Conclusions and recommendations


Recommendations:
Based on the data and tables provided, here are some recommendations for data analysis and
commentary:

Analyze Sales Trends:

 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.

Evaluate Sales Volume and Value:

 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.

Identify Key Insights and Recommendations:

 Determine top-performing subtypes based on sales volume and value.


 Evaluate market potential and growth prospects for subtypes in different locations.
 Address consistently underperforming subtypes with improvement strategies.
 Consider marketing campaigns, product quality, pricing, and customer preferences.

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.

Badke-Schaub, P. and Frankenberger, E., (1999). Analysis of design projects. Design


Studies, 20(5), pp.465-480.

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.

Power, D.J., (2008). Understanding data-driven decision support systems. Information


Systems Management, 25(2), pp.149-154.

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:

Data-Driven Decision, (2023). [Online], (Accessed Through):


https://www.revealbi.io/blog/reveal-data-driven-decision-making (Accessed on 11th May
2023).

Key Performance Indicators, (2023). [Online], (Accessed Through):


https://www.passionned.com/strategy/pm/kpi/ (Accessed on 11th May 2023).

6 Common Data Quality Issues, (2023). [Online], (Accessed Through):


https://www.amurta.com/blogs/top-6-common-data-quality-issues/ (Accessed on 11th May
2023).

21

You might also like