ANALYTIC REPORT
This is a business analytics project aimed at generating innovative
analytics solutions for a Company. The objective is to analyze the given
datasets from a relevant firm’s perspective in terms of implications and
strategies which the chosen company could adopt to improve its functions,
resources and processes efficiently and effectively.
Project
You are expected to work in groups to find a dataset with minimum of
10,000 rows from publicly available sources. You also need to
hypothetically identify a company (chosen company) who could get
benefits from the analysis of the dataset. You are expected to discuss the
selected dataset with your tutor in labs by Week 7. Please click on the sources
below to access some option to obtain open data:
- World Bank Open Data
- WHO (World Health Organization) — Open data repository
- Google Public Data Explorer
- Registry of Open Data on AWS (RODA)
- European Union Open Data Portal
- FiveThirtyEight
- U.S. Census Bureau
- Data.gov
- UNICEF Dataset
- DBpedia
- freeCodeCamp Open Data
- Australian Govt Data
Your task is to complete the following tasks:
Task 1- Background information
Write a description of the selected dataset and project, and its importance
for your chosen company. Information must be appropriately referenced.
[1 Page]
Task 2- Create Data View/Cube - Data Modelling and Provisioning
Upon selecting the dataset, convert the dataset into HANA data cube/view
by following the SAP HANA data modeling and provisioning technique
Page 2 of 5
using SAP HANA Web-based development workbench. The name of the
cube/view should be the student ID of one of the group members.
Task 3 – Perform Data Mining on data view
For your project, perform the relevant data analysis tasks on data
view/cube (created in Task 2) using data mining techniques such as
classification/association/time series/clustering and identify the BI
reporting solution and/or dashboards you need to develop for the
operational manager of the chosen company. [2-3 Pages]
Task 4 – Research
Justify why you chose thee BI reporting solution/dashboards/data mining
technique in Task 3 and why those data sets attributes are present and laid
out in the fashion you proposed (feel free to include all other relevant
justifications).
Note: To ensure that you discuss this task properly, you must include visual
samples of the reports you produce (i.e. the screenshots of the BI
report/dashboard must be presented and explained in the written report;
use ‘Snipping tool’), and also include any assumptions that you may have
made about the analysis from Task 3. [1-2 Pages]
Task 5 – Recommendations for CEO
The CEO of the chosen company would like to improve their operations. Based
on your BI analysis and the insights gained from your “Dataset” in the lights of
analysis performed in previous tasks, make some logical recommendations to
the CEO, and justify why/how your proposal could assist in achieving
operational/strategic objectives with the help of appropriate references from
peer-reviewed sources. [2-3 Pages].
Task 6 – Cover letter
Write a cover letter to the CEO of the chosen firm with the important data
insights and recommendations to achieve operational/strategic objectives [1
page]
Other Tasks –
Please refer to the marking scheme at the end of the assignment for other tasks
and expectations.
Report Submission:
• A maximum of 3 people in a group.
• Check your assignment for plagiarism in turnitin software. Please attach a
turnitin report along with your assignment. An assignment without a turnitin
report will not be accepted.
Page 3 of 5
• Submit a hard-copy to tutors/lecturers assignment box in week 10. Double-sided
printing for the hard-copy is encouraged in order to save paper.
• You will also submit a 9-10 pages report (about 3000 words) not counting
cover page, references and Appendix) of this project. At least 5 references in
your report must be from peer-reviewed sources. Include any and all sources of
information including any person(s) you interviewed for this project.
• Please note that all references must adhere to APA style. See
http://owl.english.purdue.edu/owl/resource/560/01 and http://www.apastyle.org/ for
details on how to format a report and how to cite references. Make sure your follow
a formal report structure with cover page, introduction, use of headings, subheadings,
conclusion sand reference section.
Page 4 of 5
ITECH7407- Real-Time Analytics
Assignment 1- Data Analysis- Marking Scheme
Percentage 20%
Due Week 11 (Friday 5pm) – Hard and Soft Copies
Tasks Max
Marks
Marks
Awarded
Comments
1- Background of the Project: Description of
Project, Datasets and firm. The important of
project for the firm [1+1+1+2]
5
2- Create Data View/Cube - Data Modelling and
Provision – List the various steps with the
help of screenshots, necessary in your
modelling and provisioning process of the
selected dataset to create data cube/view.
The data view/cube should be named with a
studentID
25
3- Perform Data Mining Technique/s : Perform
various analysis using SAP expert analysis on
your created data view cube - [Quality and
complexity of the analysis –
association/classification/clustering/time
series models, dashboard designing and
relevance for the project]
25
4- Research - Justify why these BI reporting
solution/dashboards are chosen and why
those attributes are present and laid out in the
fashion you proposed (feel free to include all
other relevant justifications).
Note: To ensure that you discuss this task
properly, you must include visual samples
of the reports you produce (i.e. the
screenshots of the BI report/dashboard
must be presented and explained in the
written report; use ‘Snipping tool’), and
also include any assumptions that you may
have made about the analysis in your
assignment report (i.e. the report to the
operational team of the company).
[Each analysis/dashboard and report explanation
with relevant research papers, complexity and indepth of the justification, use of peer-reviewed
sources] (20 for basic and 5 for advanced)
15
5- Recommendations - The CEO of the chosen
firm would like to improve the operations.
Based on your BI analysis and the insights
10
Page 5 of 5
gained from “Data Set” in the lights of analysis
performed in previous tasks, make some
logical recommendations to the CEO, and
justify why/how your proposal could enhance
company operations and could assist in
achieving operational/strategic objectives.
[Key data insights, recommendations to
achieve organisational objectives with
theoretical justifications with proper
references. [2+3+5]
6- Cover letter (Format, key findings and
recommendation ) [1+1+3]
5
7- Other Tasks Report is well-written and
presented professionally, containing:
• Title page
• Table of Contents
• Introduction
• Appropriate use of headings within report
• Appropriate use of figures (i.e. graphs,
summary tables) and reference to calculations
and summaries to justify all observations and
recommendations
• Overall structure, presentation and formatting.
Note that the report has to be presented
formally. It must include discussion of
calculations, observations and recommendations
with graphs and/or tables.
1
2
2
1
2
2
5
Total Marks 100
Total Marks out of 20 20%
You MUST produce the actual visuals in SAP Tools i.e Lumira & Expert Analysis
If you think the best presentation above is to use, say, only a pie chart, then discuss using
a pie chart and indicate what the pie chart would show, why you picked the pie chart,
and so on.
It may be useful to try with various BI reporting/dashboards/presentations before
rushing to conclusion.