|Marks out of Wtg(%)||Word
|Assignment 4 Written and Practical Report||100 (50%)||4500||18/05/12|
Note: Assignment 4 can be done in a team of two students or as an individual assignment.
This assignment consists of four tasks 1, 2, 3 and 4 and builds on the research and analysis you conducted in Assignment 2 and presented in the form of a report that addresses the following issues: financial customer segments, customer behaviours, propensity to default on a loan and the key issues associated with the implementation and utilisation of business intelligence system needed to analyse and make decisions on these variables of interest. Task 3 provides you with the opportunity to design and build a performance dashboard using an excel spread sheet and pivot tables. Task 4 requires you to complete a journal for each team member or as an individual.
b)Which (variables) attributes can be omitted from your data mining model and why (Hint: highly correlated variables may indicate some redundant variables)?
c)Identify interesting subgroups of records based on your previous analyses (Hint: what variables will allow you to split the data set into subgroups). Obviously credit rating of good and bad will provide you with two subgroups in the data set. Comment on what other interesting subgroups in the data set creditdata.csv show about the propensity of particular groups to default on a loan?
Task 2 (Worth 15 marks)
For the deployment phase of the CRISP DM process discuss the key opportunities and challenges including socio-technical change management associated with the implementation and utilisation of a business intelligence system which supports improved decision making in financial institutions relation to the assessment of loan application and improved risk management of loan defaults. (1500 words approx.)
GBI partners with only the highest quality suppliers of accessories which will help enhance
riders’ performance and comfort while riding GBI bikes. The Figure below displays the GBI range of products.
Rules have been kept simple:
GBI’s headquarters are located in Dallas and the European subsidiary company (GBI Europe) is based in Heidelberg, Germany. In regards to the GBI sales process there are two sales organisations for America (Eastern US and Western US) and two for Germany (Northern Germany and Southern Germany). All sales organisations have a wholesale distribution channel responsible for delivering the products to the customers. However only one sales organisation is required in each country to support internet sales. The diagram below displays the GBI organisation to support the sales process.
GBI management require a sales dashboard to be created to provide greater insight to their sales data to understand the trends and sales performance. They want the flexibility to visualize sales data in a number of different ways. They want to be able to get a quick overview of the data and then be able to zoom and filter on particular aspects and then get further details as required. The specific information they are concerned with is the following four sales performance reports.
Your task is create
(a) dashboard to satisfy the GBI management requirements for the four specified sales performance reports:
1.Sales Revenue and Sales Gross Profit by Week, Month, and Year
2.Sales Revenue and Sales Gross Profit by Product/Product Category
3.Sales Revenue and Sales Gross Profit by sales organisation
4.Sales Revenue and Sales Gross Profit by country
(b) provide a rationale for the graphic design and functionality that is provided in your dashboard for GBI in terms of how it meets GBI management requirements (1000 words approx). You will need to submit your excel spread sheet which contains your dashboard as a separate document to your main report for Assignment 4.
4.Body of report – main sections and subsections for each Task and sub task such as Task 1 sub task a) etc…
5.List of References
6.Appendices to accompany Task 1 data mining analyses and journal for each student involved in the Assignment 4
Harvard referencing resources
Your assignment will be assessed on content and style. Content refers to the way in which your assignment reflects breadth and depth of understanding of the topics and knowledge of business intelligence systems as covered in the course so far and relevant other researched
If you are not familiar with the requirements of a formal report
format, refer to the
Communication sACS Academic Learning Support web-site useful: <>.