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

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 lab session in week 9. 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

Attachments:

NIT3171-Group....pdf

melbourne-dat....txt

melbourne-hou....csv