Assessment Event 2 - Simulation: Coffee Huse

You will complete number of tasks with compiling a business report based on a series of quantitative

statistical analyses you will apply on various data sets. These tasks will be based on your role as a Business

Intelligence Officer for a coffeehouse chain called Coffee Huse.

To complete the Simulation, you will need to refer to the following resources:

Time series

Data. xlsx

Provides you with the historical business performance for each store. You will use this data set throughout Task 1 to conduct a time series analysis and in Task 3 to develop a decision support tool.

Survey Data. xlsx

Holds customer satisfaction records for baristas. It also provides figures about price for each coffee type and time to wait for serving a cup of coffee. You will use this data set in Task 1 to conduct statistical analysis

Training Data.xlsx

Holds training records for baristas. It also provides figures about speed of serving, taste of coffee and customer satisfaction. You will use this data set in Task 1 apply quantitative data analysis techniques.

Update Database.txt

Update on store performances including rent, sales, cogs, and EBITDA figures. You will use these records to update the organisation's database.

Organisational

Policy and

Procedures

Sets out the standards and practical instructions to conduct appropriate data analyses on corporate knowledge sources and document findings accordingly. Also, it provides mandatory requirements on the organisational decision-making process, company values, and dissemination of information. You will refer to these organisational standards throughout the simulation.

Please note that your responses for both assessment events

Assessment Event 2 - Simulation: Coffee Huse

You will complete number of tasks with compiling a business report based on a series of quantitative

statistical analyses you will apply on various data sets. These tasks will be based on your role as a Business

Intelligence Officer for a coffeehouse chain called Coffee Huse.

To complete the Simulation, you will need to refer to the following resources:

Assessment Event 2 - Coffee Huse

In this assessment, you will undertake a number of tasks associated with formulating

evidence-driven strategies to improve the business performance of a local coffeehouse chain,

Coffee Huse, utilising its corporate knowledge.

Task 1: Compile Business Report

In this task, you will compile a report to create business case in regard to the Coffee Huse's

business performance to be presented to the higher management in future (Task 2). To

achieve this, you will ensure the reliability of data collected, apply various statistical data

analysis techniques, and document your findings in line with organisational requirements.

1.1

Review and prepare data

Prepare the survey and timeseries data using your spreadsheet software. Ensure to save it for

future use. Make sure you comply with the organisational policy and procedures.

1.2 Set objective for analyses

insert your responses here:

1.3 Analyse store performances

insert your findings here including evidence of analyses, data visualisations, and

interpretations:

1.4 Undertake statistical root-cause analysis

insert your findings here including evidence of analyses, data visualisations, and

interpretations:

1.5 Analyse the conditional means

insert your findings here including evidence of analyses, data visualisations, and

interpretations:

1.6 Apply further analysis

insert your findings here including evidence of analyses, data visualisations, and

interpretations:

1.7 Undertake sensitivity analysis

insert the output of your sensitivity analysis and suggestions here:

Task 2: Take Decisions on Business Issues Identified

In this task, you will develop an action plan in consultation with the Area Manager. This will

involve you to present your evidence-driven solutions to the Area Manager and agree on

solutions that are in line with the organisation's values and decision-making procedures.

2.1 Manage risks for proposed actions

Insert your responses into the table:

Strategy

Rationale

Risk

Control Measure

2.2 Make decisions in consultation with the Area Manager

Your Assessor will observe you using the Observation Check Sheet in Appendix B.

Please refer to Task 2.2 in your Student Assessment Guide for instructions.

Note that you must amend your proposed actions in light of the Area Manager's input.

Task 3: Develop a System for Information and Knowledge Management

In this task, you will develop a spreadsheet-based decision support tool, create internal

communication plan, and implement a cloud-based knowledge repository system. You will

also apply updates to this system as required. Read the background information for these

tasks in Simulation Background Phase 3 in Appendix A given in your Student Assessment

Guide.

3.1 Develop the decision support tool for dissemination

Create decision support tool and save it to be uploaded to the Cloud Based Repository

You will create in Task 3.2.

Insert the screenshots of your decision support tool here:

Insert your communication plan here:

3.2 Develop the initial components of the system

Implement your cloud-based knowledge repository and upload all the assessment files.

insert the screenshots of your cloud-based management system here:

insert your updated communication plan here: