Create a report and accompanying graph

Assignment Help Term Paper
Reference no: EM13136818

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 analy sis 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) 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.

Reference no: EM13136818

Questions Cloud

Find weight of female using regression model output : The following output is the result of running a linear regression on WEIGHT (y) = average weight in pounds for American females. Based on this regression model output, what will be the weight of a Russian Female who is 71 inches tall?
Terrorist recruitment techniques-group dynamics : What are the benefits to a terrorist group of using suicide bombers to conduct terrorist acts? What, beyond the obvious (once a suicide bomber detonates him/herself that human weapon is no longer in the terrorist group's arsenal) are some of the d..
Should employee create a retirement portfolio : Should employee create a retirement portfolio consist of diversified investments as no-load mutual funds and exchange traded funds?
How many moles of n2 are produced : How many moles of N2 are produced by the decomposition of 1.40 of NaN3 ?
Create a report and accompanying graph : 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 p..
Poverty and market policies : How can a market still leave some people in a suboptimal economic situation? Is poverty a market failure or a negative externality? If poverty is a market failure,
How many moles of naf must be dissolved : How many moles of NaF must be dissolved in 1.00 liter of a saturated solution of PbF2 at 25 °C to reduce the Pb2+ to 1 x 10-6 molar?
Considering a new capital investment : Upper Darby Park Department is considering a new capital investment. The following information is available on the investment. The cost of the machine will be $200,000.
Calculate standard deviation of ages of uninsured : Calculate the standard deviation of the ages of the uninsured senior citizens correct to the nearest hundredth of a year.

Reviews

Write a Review

Term Paper Questions & Answers

  Generation and evaluation of alternative solutions

Write two pages for "Generation and Evaluation of Alternative Solutions" for Love Canal case. Total 2 Pages for "Generation and Evaluation of Alternative Solutions" for love canal case and including references.

  Paper on deming theory

Paper on Deming theory: Dr. W. Edwards Deming developed a method for the quality improvement process. He believed that the identification and correction of defects after production is not effective.

  Paper on what does autism play in savant syndrome

Write a Paper on Topic:   What does autism play in savant syndrome?

  Write a paper on italy and its democracy

Write a Paper on Topic:  Italy and Its Democracy,  Affecting the Event by “The Economist” and  Democracy Appear to Work with including references.

  Climate change and the north

The essay topic is: Climate Change and the North (with particular Focus on the Inuit).  The purpose of this research paper is to help you engage with current events and contemporary challenges concerning Aboriginal people in Canada.

  Should manitoba adopt a single transferable vote

Write a paper on Topic: Should Manitoba adopt a single transferable vote (STV) electoral system for provincial elections?

  In crisis and reform

In Crisis and Reform:  Current Issues in American Punishment (p. 126), Alexis Durham writes,Please write a reaction paper (4-6 pages in length) to the quote in which you explore global correctional objectives

  Role play as the corporate social responsibility officer

Your Corporate Social Responsibility Officer  Handout and Rubric, This paper gives you an opportunity to "role play" as the Corporate Social Responsibility Officer for an organization of your choice.

  Operationalize sustainability

This assignment is designed for you to analyze an organization and to help develop a plan for that organization to better Operationalize sustainability in the future.

  Gulliver''s view of science

Write on  Gullivers view of science or politics, Jonathan Swift’s view about science is explicitly portrayed in this novel Gulliver’s travel. Jonathan swift says the scientific researches and the experiments will be utter waste of time and it will be..

  Designing a computer interface with visual disability

The topic is about designing a computer interface to people with visual disability (blindness- colour blindness) also , how to apply decision support systems to such interfaces..

  Social issue

Answer the following questions as these general questions pertain to the specific issue selected.The questions that you will cover with respect to your choice of broad social issue in the paper are given.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd