Design a data warehouse architecture

Assignment Help Business Management
Reference no: EM131034570 , Length: word count:1500

This is my bussiness intelligence assignment.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.

Task 1 Exploratory Data Analysis and Decision Tree Analysis

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 and identification of the key variables in the credit data set which is provided for Assignment 2. Note you should also refer to the data dictionary provided in Appendix A of this document and with the creditdata.csv file as this document defines each of the variables and their range of values. (About 250 words).

b) Using RapidMiner Studio data mining tool conduct an exploratory analysis of the creditdata.csv data set on the Assignment 2 folder on course study desk which is provided on the CIS8008 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 in Appendix A of this document and with the creditdata.csv file as this document defines each of the variables and their range of values.

Then using RapidMiner Studio data mining tool build a simple predictive model of Credit risk using a reduced creditdata.csv data set using a DecisionTree.

Discuss each of your five top variables in about 50 words in terms of the results of your exploratory data analysis and discuss the results of your decision tree analysis drawing on the key outputs from RapidMiner Studio data mining tool and the relevant supporting literature on credit assessment and relevant supporting literature on the interpretation of decision trees. Your discussion should also include appropriate statistical analysis results such as graphs and results tables from conducting an exploratory data analysis in the RapidMiner data mining tool with some supporting references on predictive model building and interpretation using Decision Trees in data mining.

Task 2 Data Warehousing and Big Data

A data warehouse is the foundation of any Business Intelligence or Business Analytics initiative. Consider the following scenario a large local government consisting of seven departments with many different data sets residing in each department. They want high level advice on the logical design of a data warehouse that would incorporate big data analytics.

(a) Discuss the possible approaches could be used for designing a data warehouse architecture using Kimball or Inmon's methodology and provide a high level logical design of a data warehouse architecture.

(b) Discuss how your high level warehouse architecture design in part A could incorporate the capture processing storage and presentation of big data. Your answer here should focus on providing explanation of a revised high level diagrammatic representation of the logical design of your data warehouse including how big data analytics would be incorporated/integrated in the logical design of your data warehouse.

Note that the coverage of these concepts in textbook Chapter 2 Data Warehousing is somewhat limited and dated and may not be current thinking for such a fast moving field. Hence you will need to research and critically review the current literature in relation to the concept of data warehouses and different data warehouse design architectures and data warehouse architecture design methodologies in more detail. You will also need to consider how big data is being incorporated/integrated into data warehouses initiatives in order to provide a comprehensive and informed answer to these sub questions for Task 2.

Task 3 Sales Reports using Tableau Desktop

Task 3 Sales Reports using Tableau Desktop consists of the following sub tasks

With the following Excel file SalesSuperstore.xlsx provided on the course study desk Assignment 2 Folder link and using Tableau Desktop produce the four following reports with appropriate accompanying graphs based on a Tableau workbook sheet view for each. Briefly comment on each report in about 125 words in terms of what trends and patterns are apparent in each report.
The SalesSuperstore.xlsx file contains the following dimensions and information:

1. Customer Name, Customer Segment

2 . Location - Region , State, City, Zipcode

3. Product Category, Sub Category, Product Name, Product Container, Unit Price

4. Order Information

5. Shipping Information

6. Sales Information

7. Profit

a) Create a report and accompanying graph using Tableau that shows a trend analysis for sales by Product Category over the years 2009 to 2012 and comment on key trends and patterns apparent in this report (About 125 words)

b) Create a report and accompanying graph using Tableau that shows for each Product Category Average Profit and Total Sales for each month over the years 2009 to 2012 and comment on key trends and patterns apparent in this report (About 125 words)

c) Create a geographical map presentation using Tableau that shows graphically the relative size by City within each state, Product Sales for year 2010 and comment on key trends and patterns in this report (About 125 words)

d) Create a report and accompanying graph using Tableau that shows for Product Sub Categories that are technology based Unit Prices, Sales and Profit for each month over the years 2009 to 2012 and comment on key trends and patterns in this report (About 125 words)

Your assignment 2 report must be structured in report format as follows:

Cover page for assignment 2 report
1. Title Page
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..
Task 2 ...
Task 3 ....
4. List of References
5. List of Appendices

Reference no: EM131034570

Questions Cloud

Employees should understand algorithmic thinking : Think of Infosys' belief that employees should understand "algorithmic thinking." How would you manage people, set systems, and promote corporate culture to attain this goal?
What is better institutional home for incubating research : What is the better institutional home for incubating research in the social sciences in general and public policy and administration in particular, a traditional univer- sity or the modern U.S. think tank?
Issuance of the bonds-first semiannual interest payment : On the first day of its fiscal year, Robbins Company issued $1,900,000 of 6-year, 6% bonds to finance its operations of producing and selling home improvement products. Interest is payable semiannually. The bonds were issued at a market (effective..
What are some other characteristics of this market structure : What are some other characteristics of this market structure
Design a data warehouse architecture : Exploratory Data Analysis and Decision Tree Analysis - Discuss how your high level warehouse architecture design in part A could incorporate the capture processing storage and presentation of big data.
Should the government build the bridge : A company is considering building a bridge across a river. The bridge would cost $2 million to build and nothing to maintain.
Identify various cost aspects for developing his interface : Your journal 3 task is to identify various cost aspects for developing the HIS interface that is accessible through smart handheld devices and integrating the HIS interface securely with other information systems in the hospital
How can social dilemmas hinder global negotiation : How can social dilemmas hinder global negotiation? Give several examples. Choose a country and define foreign investor risks. Do you think that they investor risks can be avoided? Why or why not?
Charge on the audit of fine chem : You are the senior in charge on the audit of Fine Chem Pty Ltd (FCPL), a private company controlled by three pharmacists; Janine Cole, Peter Davis and Warren Banks, who form the Board of the company.

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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