ICT Business Analysis & Data Visualization Assignment
Group Assignment - Business Analysis Case Study (Stage I)
In this assignment, a frequently cited Boston 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
Read the attached txt file "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
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
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
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.
Individual Assignment - Business Analysis Case Study (Stage II)
In this assignment, a frequently cited Boston 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 individual assignment, you will finish the second stage by yourself alone.
Main tasks to do in individual assignment:
- Select one business analysis task* from Task 3 of your group assignment
- Select an appropriate data mining method for your analysis task
- Analyse and discuss your results/findings/achievement
- Provide your suggestions based on your results/findings/achievement to business management
- Present your work to the class
A suggested report template could be:
Title page
- Title of your report/task
- Your name & student ID
- Unit code, unit name & submission date
Introduction
- Introduce the background of your business analysis task ? Brief introduction of the problem/objective/goal/aim of your analysis task
- Overview of your report, the organization of your report, tell your readers what they will read from your report
Business Analysis problem/task
- Describe your business analysis problem in more details
- What specific task will you do in this report?
- What is expected to have by finishing this business analysis task?
- The benefit or contribution that your business analysis task will achieve
Methodology
- What data mining method/algorithm/model is used to solve your business analysis problem?
- Brief introduction of the method/algorithm/model?
- Why do you select this method to solve the problem?
- What data set do you use? Brief introduction of the data set?
- Pre-processing of your data set, what the ready-to-use data set will be? For example, after attribute selection or after data cleaning
Result & discussion
- Present your results and findings
- Discuss your results
- Provide any suggestion to business management
Conclusion
- Summarize your report, highlight your business analysis problem/task, method, and results
Presentation - Everyone has 5 minutes for presentation. PPT is required to support your presentation.
Attachment:- Assignment Files.rar