Description Marks out of Wtg(%) Word Count Due date
Assignment 2 Written Practical Report 100 marks 30% in total 3000 25/04/14
The key frameworks and concepts covered in modules 1–5 are particularly relevant for this assignment.
Assignment 2 relates to the specific course learning objectives 1, 2 and 4 and associated MBA program learning goals and skills: Global Content, Problem solving, Critical thinking, and Written Communication at level 3:
1. demonstrate applied knowledge of people, markets, finances, technology and management in a global context of business intelligence practice (data warehouse design, data mining process, data visualisation and performance management) and resulting organisational change and how these apply to implementation of business intelligence in organisation systems and business processes
2. identify and solve complex organisational problems creatively and practically through the use of business intelligence and critically reflect on how evidence based decision making and sustainable business performance management can effectively address real world problems
4. demonstrate the ability to communicate effectively in a clear and concise manner in written report style for senior management with correct and appropriate acknowledgment of main ideas presented and discussed.

Assignment 2 consists of two main tasks and a number of sub tasks

Task 1 (Worth 50 marks) consists of the following sub tasks

a) Assignment 2 requires that you research and critically evaluate literature surrounding the problem of effectively assessing loan applications for credit worthiness. Credit worthiness assessment reduces the risks associated with lending by determining which potential loan applications are considered to be good, or alternatively a poor, credit risk and should on that basis be approved or rejected. Good risk management of loan applications can significantly improve the bottom line of financial institutions such as banks, building societies and credit unions. This research will inform your assessment of the credit data set which is provided for Assignment 2 (About 700 words).

b) Conduct an exploratory analysis of the creditdata.csv data set which is provided on the course study desk to identify what you consider to be top five key variables which contribute to determining whether a potential loan applicant is a good credit risk or a bad credit risk. Note you should also refer to the data dictionary provided with the creditdata.csv file as this document defines each of the variables and their range of values. Discuss each of your five top variables in about 200 words in terms of the results of your exploratory data analysis using RapidMiner data mining tool and the relevant supporting literature on credit assessment. Your discussion should also include appropriate statistical analysis results including graphs and tables produced from an exploratory data analysis using RapidMiner data mining tool (about 800 words).
c)

Table 1 Credit data Data Dictionary
Attribute
Name Type of Attribute Range of attribute
1. Custno Customer Id Custno1 to Custno1000
2. Checking Status of existing checking account (qualitative)
Note: DM = German
Deutsche Marks A: = 0 DM
B: = 200 DM
C: = 200 DM / Salary assignments for one year
D: No checking account
3. duration Duration in months of loan (numeric)
4. history Credit history (qualitative) A: no credits taken/ all credits paid back duly
B: all credits at this bank paid back duly
C: existing credits paid back duly till now
D: delay in paying off in the past
E: critical account/other credits existing (not at this bank)
5. purpose Purpose of proposed loan (qualitative) A: car
B: car (used)
C: furniture/equipment
D: radio/television
E: domestic appliances
F: repairs
G: education
H: (vacation)
I: retraining
J: business
K: others
6. amount Credit amount (numeric)
7. savings Savings account/bonds (in
German currency)
(qualitative) A: 100 DM
B: 100 = ... 500 DM
C: 500 = ... 1000 DM
D: = 1000 DM
E: unknown/ no savings account
8. employed Present employment since (qualitative) A: unemployed
B: 1 year
C: 1 = ... 4 years
D: 4 = ... 7 years
E: = 7 years
9. instalp Instalment rate as percentage of disposal income (numeric)

10. marital Personal status and sex (qualitative) A: male: divorced/separated
B: female : divorced/separated/married
C: male : single
D: male : married/widowed
E: female : single
11. coapp Other debtors / guarantors (qualitative) A: none
B: co-applicant
C: guarantor
12. resident Present residence since
(numeric) in years

Attribute
Name Type of Attribute Range of attribute
13. property Property (qualitative) A: real estate
B: if not A: building society savings agreement/life insurance
C: if not A/B: car or other, not in attribute 6
D: unknown / no property
14. age Age in years (numeric)
15. other Other instalment plans A: bank
B: stores
C: none
16. housing Housing (qualitative) A: rent
B: own
C : for free
17. excred Number of existing credits at this bank (numeric)
18. job Job (qualitative) A: unemployed/ unskilled - non-resident
B: unskilled - resident
C: skilled employee / official D: management/ self-employed/ highly qualified employee/ officer
19. depends Number of people being liable to provide maintenance for (numeric)
20. telephone Telephone A: none
B: yes, registered under the customers name
21. foreign Foreign worker (qualitative) A: yes B: no
22. credit_rating Credit rating (qualitative) Good Bad

d) Discuss how and why it is important that information governance and information quality be incorporated into the design of a data warehouse architecture (1000 words approx).
Task 2 (Worth 40 marks) consists of the following sub tasks
With the following excel file bicycle-sales.xlsx provided on the course study desk use Tableau 8.0 or a pivot table to produce the four following reports with appropriate accompanying graphs and briefly comment on each report/graph in about 125 words in terms of what trends and patterns are apparent in each report.

The bicycle sales.xlsx file contains the following dimensions and information:
1. Region
2. Sub Region
3. Market
4. Customer
5. Business Segment
6. Category
7. Model
8. Colour
9. Sales Date
10. Sales Period
11. List Price
12. Unit Price
13. Order Quantity
14. Sales Amount

a) Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by sub region, business segment and model for all mountain bikes sold for the years 2002, 2003 and 2004 and comment on key trends and patterns in this report (125 words approx.)

b) Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by region, sub region, business segment, unit price and list price for all bicycle clothing for the years 2002, 2003 and 2004 and comment on key trends and patterns in this report (125 words approx.)

c) Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by region, sub region, business segment and model for all the road bicycles in order of the total sales for years 2002, 2003 and 2004 and comment on key trends and patterns in this report (125 words approx.)

d) Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by category, model, order quality and colour for all bicycles for the years 2002, 2003 and 2004 and comment on key trends and patterns in this report (125 words approx).

Report presentation, and quality of argument appropriately supported by relevant number of references (worth 10 marks)
Your assignment 2 report must be structured as follows, which is similar to the report structure detailed in Summers & Smith 2010:
1. Cover page for assignment 2 report
2. Table of contents
3. Body of report – main sections and subsections for assignment 2 task and sub tasks so Task 1 will be a main heading with appropriate sub headings etc....for each sub task etc..
4. Appendices
5. List of References

Harvard referencing resources
Install a reference tool (example Endnote) which integrates with your word processor. These tools are a great help for referencing and citing sources in your assignments. For more information on how to get Endnote you may visit the following webpage: http://www.usq.edu.au/library/services/staffresearch/endnote/.
Cautions
Originality of submission
• This assignment must be the expression of your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own. This also means that it is not sufficient to merely paraphrase the entire assignment content from a textbook or other source. Your assignment answers need be a reflection and synthesis of your research of the associated topics. This should be evident in your annotated bibliography.
• You need to demonstrate your understanding of associated topics for each assignment. You must not copy from anyone, including tutors and fellow students, nor provide copies of your work to others. Assignments that do not adhere to this requirement will be deemed as being the result of collusion or plagiarism. This may lead to severe academic penalties as outlined in Academic Regulation 5.10 of the USQ Handbook. It is your own responsibility to ensure the integrity of your work. Refer to the Faculty of Business policy for further details.
• An indiscriminate overuse of incorrectly referenced or cited web pages in your assignment will result in poor marks.

Late submission of assignment work
Late assignments will be penalised unless permission has been granted by the course leader BEFORE the assignment due date. Late assignments may be penalised by reducing the allocated mark by 5% per day late.

Submission requirements
1) Formatting
a) Page size should be A4. Allow for TOP MARGIN – 2.5 cm; BOTTOM MARGIN –
2.5 cm; SIDE MARGINS – 2.5 cm
b) Major headings should be in upper case, 14 point Times New Roman Bold
c) Minor headings should be in lower case, 12 point Times New Roman Bold
d) Body text should be formatted to 12 point, Times New Roman
e) Use single or one and half line spacing
f) Assignments should be in one of the following formats:
(1) Microsoft Word (2003)
(2) Microsoft Word (2007)
(3) Rich Text Format (RTF)
(4) Portable Document Format (PDF)

2) The file naming guidelines are as follows:
a) It is important that you use this convention to ensure that assignments can be tracked:
Familyname_studentnumber_CIS8008_A1
b) Replace ‘familyname’ with YOUR family or surname
c) Replace ‘studentnumber’ with YOUR student number (which starts with ‘00’)

3) BEFORE submitting your FINAL version of the assignment to the online submission system (EASE) you must upload your draft copies to the online TURNITIN system (see the course Study Desk for details on accessing and using the TURNITIN system).
a) TURNITIN produces an Originality Report that shows your overall similarity index. If the index is less than 25 percent, your assignment is considered to be plagiarism free. If not, you will have to rework your assignment, using the feedback in the
Originality Report as a guide, and then resubmit it to TURNITIN for another round of checks.

4) Once you have obtained a plagiarism-free assignment you should upload your
Originality Report along with the FINAL version of your assignment through the online assignment submission system (EASE). No hardcopy submissions will be accepted. See the course Study Desk for instructions on uploading your assignment.