NIT3171 Group Assignment

NIT3171 Group Assignment, Business Analysis Case Study – 35 Marks (35%)
Report Submission Date through the drop box: (10% will be deducted for each day of delay)
Presentation (up to 15 minutes per group):
In this assignment, a Melbourne housing dataset is given in melbourne_house_data_s1b3.csv to you
to apply data mining techniques to resolve a business problem. Assuming that you are taking a
business analyst role in a real estate consulting firm, and you are asked to leverage your business
analytical skills to make better use of the given housing dataset.
By finishing this assignment, you will achieve the following learning outcomes:
1. Review the current algorithms, methodologies and modelling for ICT business analytics;
2. Evaluate various ICT business analytic tools and techniques; and
3. Propose a business analytics report to solve practical problems identified in an ICT business
project.
The entire assignment has two stages. In this group assignment, you will finish the first stage with one
more group member.
Main tasks to do in group assignment:
1. Understand the dataset
2. Relationships discovery among features
3. Potential analysis tasks that you could do to provide business suggestions
4. Justify the reasons why you target those potential tasks and the potential benefits that the
expected results/finding/achievement could help to improve business
5. Present your work to the class
Task 1: Understand the dataset (5 Marks)
Read the attached txt file “melboune_data_description.txt” that contains detailed description of the
attributes in the given dataset. Use this file as dictionary to get the meaning of each attribute value.
In your report, you need to present your initial analysis results of the dataset, including at least but
not limited:
• the features (attributes) are included in this dataset, identifying the numeric features and
nominal ones respectively;
• simple statistics summary, such as frequency, data distribution, maximum, minimum, average
(mean), standard deviation, and etc.;
• any extra result(s) that you think can help to better understand the dataset; and
• any visualization diagram/chart/figure if necessary.
Task 2: Relationships discovery among features (7 marks)
We attempt to discover the relationships existed among all features (attributes). You have many
choices to work out the hidden relationships. Here are some suggestions:
• at object level, to convert the raw dataset into a well-structured one in relational data model
(hint: to apply normalization technique);
• at attribute level, to group attributes into smaller subsets with particular focuses based on
your understanding;
• to work out correlations among all or selected attributes; or
• by any other way, to build up your own results.
Task 3: List any potential business analysis tasks with your justification (8 Marks)
Based on your analysis and understanding so far to list a set of potential business analysis tasks that
you can work on using the given dataset. You should consider some tasks whose results may bring
business benefits, support strategy development, improve business process, and support decision
making. Your tasks can adopt any of the following data mining techniques:
• association rule mining;
• classification;
• prediction; and
• regression.
You need to provide strong reasons why you decide to do certain tasks, including the expected
results/findings/achievement. Why do you think that your analysis could bring the benefits to improve
business.
Task 4: Presentation (10 marks)
Your group needs to present your work before the other students in class. The presentation will be
arranged in Week 2 session 8. Both group members need to present the work. The content of your
talk should cover everything you have done in the above tasks. Each presentation takes for only 5
minutes. In real world, you will have very short time to present your idea to customers to win business
opportunity. You need to prepare PPT slides for our presentation.
Report to submit (5 Marks for the report and graphs quality)
You need to submit your report via dropbox on VU Collaborate, NIT3171 space. Each group has its own
submission dropbox, that is, one group only needs to submit one copy. You also needs to submit your
presentation PPT file. If you have any visualization file with large size, please submit the original image
file in .jpg, .gif, or other format that can be opened by windows photo viewer. Your report should be
saved in MS Word or PDF format.
A suggested report template could be:
Title page
Introduction
Task 1: understanding of the database
Analysis result 1
Analysis result 2
……
Task 2: relationships among the features
Normalization result
……
Task 3: potential business analysis tasks
BA task 1
BA task 2
……
Conclusion