We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.
Important Note: Your order at Assignment Experts is protected by Consumer Law UK; also, we use 3rd party merchant support “PayPal” for all online transactions to provide you with the most protected online buying experience.
100% Pass and No Plagiarism Guaranteed
Possible Marks and Wtg(%)
Assignment 2 Written Practical Report
100 marks 30% Weighting
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:
Note you must use Rapid Miner Studio for Task 1 and Tableau Desktop for Task 3 in this Assignment 2. Failure to do so may result in Task 1 and/or 3 not being marked and zero marks awarded.
Note carefully University policy on Academic Misconduct such as plagiarism, collusion and cheating. If any of these occur they will be found and dealt with by the USQ Academic Integrity Procedures. If proven, Academic Misconduct may result in failure of an individual assessment, the entire course or exclusion from a University program or programs.
Assignment 2 consists of three main tasks and a number of sub tasks
Task 1 Exploratory data analysis and Decision Tree Analysis (Worth 35 Marks)
Task 1a) Identify, critically review and discuss literature which determines higher adult income. This research will inform your assessment and identification of the key variables for determining higher level adult incomes in the data set adult-income.csv. I suggest you relate your discussion here to the variables in the adult-income.csv data set where possible (About 600 words).
Task1 b) Conduct an exploratory data analysis of the adult-income.csv data set using the RapidMiner Studio data mining tool to understand the characteristics of each variable and the relationship of each variable to the other variables in the data set adult-income.csv. Summarise the findings of your exploratory data analysis in terms of describing key characteristics of each of the variables in the adult-income.csv data set such as maximum, minimum values, average, standard deviation, most frequent values (mode), missing values and invalid values etc and relationships with other variables if relevant in a table named Task 1b Results of Exploratory Data Analysis for Adults Income Data Set.
Hint: The Statistics Tab and the Chart Tab in RapidMiner will provide descriptive statistical information and useful charts like Barcharts, Scatterplots etc. You might also like to look at running some correlations and chi square tests. Indicate in this Table which variables you consider to be the top five key variables and which contribute most to determining whether an adult is on a high income over $50,000. Note in completing Task 1b you will find it useful to refer to the data dictionary for the Adult Income provided in this document which defines each of the variables in terms of their data type and range of values.
Briefly discuss the key results of your exploratory data analysis and how you have selected your five top variables for predicting adult income higher than $50,000. (About 600 words)
Task 1c) Build a Decision Tree model for predicting higher Adult incomes using RapidMiner and an appropriate set of data mining operators and a reduced adult-come.csv data set determined by your exploratory data analysis in Task 1b. Provide these outputs from RapidMiner (1) Final Decision Tree Model process, (2) Final Decision Tree diagram, and (3) associated decision tree rules.
Briefly explain your final Decision Tree Model Process, discuss the results of the Final
Decision Tree Model drawing on the key outputs (Decision Tree Diagram, Decision Tree Rules) for predicting higher Adult Income and relevant supporting literature on the interpretation of decision trees (About 600 words).
Note For Task 1b and Task 1c completing the Tutorial Activities for RapidMiner and postings on the Assignment 2 discussion forum will assist you in determining what are appropriate RapidMiner operators to use.
Include all appropriate RapidMiner outputs such as RapidMiner Processes, Graphs and Tables that support the key aspects of your exploratory data analysis and decision tree model analysis of the adult-income.csv data set in Appendix A. Note you need export these outputs from
RapidMiner using the File/Print/Export Image option and include where relevant in Task 1 and Appendix A of the Assignment 2 report.
Table 1 Adult Income Data Dictionary
Type and description of
Range of values
Integer, Age of Adult
Polynominal, Category of
Private, Self-emp-not-inc, Self-emp-
inc, Federal-gov, Local-gov, State-
gov, Without-pay, Never-worked.
Integer, final weighting for
each adult income record
Bachelors, Some-college, 11th, HS-
Education level obtained
grad, Prof-school, Assoc-acdm,
Assoc-voc, 9th, 7th-8th, 12th, Masters,
1st-4th, 10th, Doctorate, 5th-6th,
Integer, education level
Married-civ-spouse, Divorced, Never-
Martial status of Adult
married, Separated, Widowed,
Tech-support, Craft-repair, Other-
occupation of each Adult
service, Sales, Exec-managerial, Prof-
specialty, Handlers-cleaners, Machine-
op-inspct, Adm-clerical, Farming-
fishing, Transport-moving, Priv-
house-serv, Protective-serv, Armed-
Wife, Own-child, Husband, Not-in-
family, Other-relative, Unmarried.
Polynominal, Race of each
, White, Asian-Pac-Islander, Amer-
Indian-Eskimo, Other, Black.
Integer, capital gain for each
Integer, capital loss for each
Integer, hours per week
worked by each adult
Polynominal, Native country
United-States, Cambodia, England,
of each adult
Puerto-Rico, Canada, Germany,
Japan, Greece, South, China, Cuba,
Iran, Honduras, Philippines, Italy,
Poland, Jamaica, Vietnam, Mexico,
Portugal, Ireland, France, Dominican-
Republic, Laos, Ecuador, Taiwan,
Haiti, Columbia, Hungary, Guatemala,
Nicaragua, Scotland, Thailand,
Trinadad&Tobago, Peru, Hong,
Task 2 Data Warehousing Architecture Design (Worth 35 Marks)
A data warehouse is the foundation of any Business Intelligence or Business Analytics initiative. Consider the following scenario:
A large regional University consisting of five divisions (Academics, Academic Services, Students, Research and Campus Services), with a number of functional groups within each division. There are many different data sets residing in functional groups within the five divisions. They want high level advice on the logical design of a data warehouse architecture that will meet their reporting and decision making needs into the future.
Task 2a) Discuss the Kimball Model versus the Inmon Model as possible approaches by considering relative advantages and disadvantages of each approach with appropriate in-text reference support that could be used for designing and developing a data warehouse architecture that would meet the reporting and decision making needs of a large regional University described above (about 1000 words)
Task 2b) Provide a high level diagrammatic representation of your proposed data warehouse architecture design for a large Regional University as outlined above
Task 2c) Describe and justify your proposed data warehouse architecture design for a large regional University presented diagrammatically for Task 2b with appropriate in-text referencing support (about 500 words)
Note that the coverage of these concepts in the 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 a data warehouse, different data warehouse design architectures and data warehouse design and implementation methodologies in more detail.
Task 3 Global Bike Company Sales Reports using Tableau Desktop (Worth 20 Marks)
The bicycles-sales.xlsx file provided for Assignment 2 on course study desk contains the following dimensions and information:
With the bicycles-sales file use Tableau Desktop to produce four sales reports:
Task 3a) Create a sales report in a Text Table or Graph view that lists by sub region, business segment and model for all mountain bikes sold for the years 2002, 2003 and 2004. Analyse this sales report and comment on key trends and patterns that are apparent (about 500 words).
Task 3b) Create a sales report in a Text Table or Graph view that lists by region, sub region, business segment, order quantity and sales amount for all bicycle clothing for the years 2002, 2003 and 2004. Analyse this sales report and comment on key trends and patterns that are apparent (about 50 words).
Task 3c) Create a sales report in a Text Table or Graph view that lists by region, sub region, business segment and model for all the road bicycles in order of the total sales and profit for years 2002, 2003 and 2004. Analyse this sales report and comment on key trends and patterns that are apparent (about 50 words).
Task 3d) Create a sales report in in a Text Table or Graph view that lists by category, model, colour and order quality for all bicycles for the years 2002, 2003 and 2004. Analyse this sales report and comment on key trends and patterns that are apparent (about 50 words).
Note that you need provide a copy of the Text Table or Graph view of each sales report in your Assignment 2 report for the relevant sub Tasks 3a, 3b, 3c and 3d. The Tableau Menu Option Worksheet and then Copy or Export Options will allow you to copy and paste the view for each sales report into relevant section of Task 3 for your Assignment 2 report.
Your assignment 2 report must be structured in report format as follows:
You need to submit two files for Assignment 2:
Use the following file naming convention:
International House, 12 Constance Street, London, United Kingdom, E16 2DQ
UK Registered Company # 11483120
View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains
If your assignment is plagiarised, we will give you £ 2999 in compensation