Business Analytics (BA) system for E-Zone

Group Assignment: Business Analytics Case Study

In groups of 5, you are required to develop a Business Analytics (BA) system for E-Zone. You are
expected to design a high-level BA framework with a detailed dimensional model design. Additionally,
you will need to implement components of your BA framework, generate insights from data and suggest
ways for managerial action.
Case Description
Please see: E-Zone Consumer Goods Case Study
This assignment is worth 30% of your assessment for the subject.
Case Study – Report Requirements
The submission should be about 3000 words in length and take the form of a report describing and
justifying the design of the star schema and predictive models. The length of 3000 words does not
include appendices. A suggested outline for the sections of the report is:
1. Executive Summary: An executive summary is a short summary of the key information in the
document and is written for a business person. It should contain a clear recommendation together
with evidence to help a business person to decide whether to go ahead with the BA project.
2. Business Analytics Framework: You should present a discussion of business analytics specific
to E-Zone, why it is necessary and the benefits they can bring to this organisation.
3. Design of a Dimensional Model: Your group is required to design a star schema for the case study.
Include a diagram of your star schema1

as well as justifications for the design choices that you have
made. The star schema must be documented with a diagram and a dictionary describing each of the
attributes within the fact and dimension tables. Within your data dictionary you should include
details about sourcing of the data in the star schema from data files in the operational systems. The
data dictionary needs to contain enough detail for your dimensional model design so that the model
can be clearly understood.
4. Implementation of the Dimensional Model: Your group is required to implement your
dimensional model. This involves two steps: (1) data integration and (2) data visualization.
4.1. data integration:
• Use the Pentaho Kettle Data Integration tool to create your fact and dimension tables.
• Add a screenshot of your Kettle transformations to the text and briefly explain your
transformations and steps.
• Attach and submit your Kettle transformations along with your report.
4.2. data visualization.
• Use Qlik Sense to build dashboard(s) to communicate key information to managers.
• The dashboard(s) should help managers with the key decision areas highlighted in case
• Add a screenshot of your dashboard(s) to the text
• Attach and submit your Qlik Sense app along with your report.


1 You can use Data model viewer on Qlik Sense for this. Other options are using ERDPlus
( ) online or drawing your design using MS Word.

Data Analytics and Information Management (BISM2202)
Group Assignment: Business Analytics Case Study
5. Development of a predictive model: Your group needs to build an analytical model that predicts
overall profits per month for each region
• You need to use RapidMiner to build your predictive model
• Add a screenshot of your RapidMiner process to the text
• Attach and submit your RapidMiner file along with your report.
6. Generate Business Insights and Strategise: Your group is required to do analysis of data. You
need to use the digital dashboards you have built to generate business insights for six problem areas
that the managers are facing. In addition to generating business insights, you need to propose action
that managers can take to grow their company.
7. Appendix 1 – Data Dictionary: Include a data dictionary for each of your fact and dimensions
tables. Include an entry for each data item including its name, a brief description of its meaning,
and describe how it will be sourced from the existing databases and include a description of any
necessary transformations.
8. Appendix 2 – Kettle transformations, Qlik visualisations and RapidMiner Process: You also
need to zip your Kettle, Qlik and RapidMiner files and submit along with your assignment.
Submissions without Kettle, Qlik, and RapidMiner attachments will not be marked. Late
submissions of these files will incur penalties as discussed in subject eCP.
9. Appendix 3 – SQL (optional): If you prefer to use SQL for implementing your dimensional model,
include all of the SQL statements that you used including Create statements, Key creation and any
indexing you deem necessary.
10. Appendix 4 – Work Breakdown: – Detail the breakdown of work of the team members for this
assignment. This should be a detailed account of what each team member accomplished as part of
the assignment. Submissions without work breakdown will not be marked.
Assessment Criteria
Aspect of review Comprehensive Proficient Basic Below Basic Poor
Executive Summary 5%
Business Analytics Discussion
Dimensional Model Design 20%
Dimensional Model
Implementation 25%
Building Predictive Model 10%
Generating business insights and
strategising 25%
Data Dictionary 5%
Kettle transformations, Qlik
visualizations and RapidMiner
Process (HURDLE)
SQL (optional)
Work Breakdown (HURDLE)
This assignment is due at 14:00 on 21 October 2019.
For late submissions, please refer to guidelines outlined on eCP:

Data Analytics and Information Management (BISM2202)
Group Assignment: Business Analytics Case Study
You are required to submit an electronic version of your work through the LMS (See the Assessment
Link on the LMS and look for the link labelled Assignment Submission. You will have two
opportunities to submit, in case you make a mistake on your first submission or wish to revise it. Please
ensure that you put your report through Turnitin BEFORE submitting it to Blackboard, to make sure
that your assignment is plagiarism free. By submitting your work in this manner plagiarism is checked
for you and you will be able to see if you have any issues with this in your work. Use Turnitin as many
times as you need to fix any similarity issues before the due date. Also, by submitting the Assignment
via the LMS you are agreeing that the Assignment is your own work.
Please compress your Kettle, Qlik and RapidMiner files as well as your Data Dictionary in a zip file.
Submit the Zip file along with your report on both Blackboard assignment and Turnitin.
Academic Honesty
Academic misconduct occurs when students portray someone else’s work as their own. There are many
ways in which Academic misconduct can occur. Some of these are:
• Sham Paraphrasing: Material copied verbatim from text and source acknowledged in-line but
represented as paraphrased.
• Illicit Paraphrasing: Material paraphrased from text without in-line acknowledgement of source.
• Other Plagiarism: Material copied from another student’s assignment with the knowledge of the
other student.
• Verbatim Copying: Material copied verbatim from text without in-line acknowledgement of the
• Recycling: Same assignment submitted more than once for different subjects.
• Ghost Writing: Assignment written by third party and represented as own work.
• Purloining: Assignment copied from another student’s assignment or other person’s papers without
that persons knowledge.
The university is committed to graduating students with “a profound respect for truth, and for the ethics
of scholarship… we want our graduates to be capable of independent thought, to be able to do their own
work, and to know how to acknowledge the work of others” (Prof. Peter McPhee). As such, the
university takes a dim view of students to are not able to correctly acknowledge the work of others, or
who try to pass this work off as their own. All students should be aware of the following web site:
conduct/academic-integrity-and-student-conduct which provides practical advice to students about how

not to be involved in academic misconduct. In particular look at the Quick Checklist section
(paraphrased below)
Quick checklist
To be certain to acknowledge sources fairly and avoid plagiarising, review this checklist before
beginning to write your essay and again after you have completed your first draft2

1. What type of source are you using: your own independent material, common knowledge, or
someone else’s independent material?
2. If you are quoting someone else’s material, is the quotation exact? Have you used quotation
marks for quotations embedded in your text? Have you set off block quotes with an extra space
before and after the quote, single spacing within the quote, and left indenting of all lines of the
block quote? Are omissions shown with ellipses and additions with square brackets?
2 Reproduced with permission of Dr Stephen Morgan, Faculty of Economics and Commerce, UniMelb

Data Analytics and Information Management (BISM2202)
Group Assignment: Business Analytics Case Study
3. If you are paraphrasing someone else’s material, have you rewritten it in your own words and
sentence structures? Does your paraphrase employ quotation marks when you resort to the
author’s exact language? Have you represented the author’s meaning without distortion?
4. Have you acknowledged each use of someone else’s material?
5. Do all references contain complete and accurate information on the sources you have cited?