FIT5141 - Assignment 3 Monash University
Get the best assignment help from MakeMyAssignments.com
This is an individual assignment and must be entirely your own work. Please note the section on plagiarism, cheating and collusion in this document.
This assignment builds on the work done in assignments 1 and 2. Specifically, you will develop and implement a quantitative analysis that will aim to answer the business question that you have formulated.
It will have two parts: A: the implementation, and B: the report.
Part A: The implementation will be in MongoDB, R, and Tableau.
Marks: [35 marks]
Part B: Additionally, a report must be written about the implementation and results of analyses.
- Data stored in MongoDB
- Data analysis done in R
- Optimisation and/or forecasting in R or in an Excel spreadsheet
- Results of analysis must include ALL of the following:
o Tables produced by R
o Charts produced by R, and o Charts produced by Tableau
§ In order to produce charts using Tableau you will need export any of the data to be plotted into a “.csv” file and then opened with Tableau
- The results must be comprehensive enough that are report can be produced according to the outline of the report for part B below.
The overriding requirement of any business data analysis is whether it is sufficiently complete to be used as the basis for decision-making. Hence:
o You must answer the question in a way that leads to decisions that could be implemented in practice by the business or organization that may have requested the analysis.
Minimal Report outline:
- Description of the Dataset
o Dealing with data format issues (e.g. text to numerical or date issues)
o Dealing with missing data and addition or removal of fields. • The analysis and why it was done (the business question)
This must include:
o Analysis overview o Summary statistics
This section should describe why and how the analysis was performed including:
o The rational for selecting the particular calculations performed, o The justifications for the data sub-setting choices,
o The justifications for the type of statistics reported
o An explanation of the forecasting or optimisation performed
o The justifications for the types of charts produced • Conclusion
A summary of how the results of the analysis answer the question. Should include:
o Discussion of how the analysis supported the answer to the question
o Questions that couldn’t be answered and what could be done in future to answer them
o The possible decisions that could be made by the organization as a consequence of the
• [Optional] Appendix: Technical specifics and other data that does not fit naturally in the main
The assignment will be marked on:
- Completeness and seamlessness of implementation
- Relevance of analysis to proposed business question
- Appropriateness of analysis to answering the question.
- Innovativeness of analysis and implementation
Sophistication of analysis (a complete analysis would involve effective data analytics and
statistics, forecasting and optimisation)
- Completeness of report
Overall quality of report
Students will be interviewed for 15-20 minutes to confirm the work is their own and during which they will be required to demonstrate:
- How the analysis worked (from connecting to database to generating tables and charts)
- How the Tableau charts were generated
The report part of the assignment should be up to 1500 words
Recommended font for the report body is Times New Roman, 12 point, single line spacing.
Please consult the lecturer if you have any enquiries about any of the aforesaid points or requirements.
This assignment is due to be submitted by 11:55pm 22nd October 2017.
PLEASE NOTE: submission of the report component of the assignment assignment requires only a single submission to Moodle through a Turnitin link.
Turnitin is a plagiarism detection system that is very effective in discovering and proving plagiarism and collusion. Submission can be made through the following.
Your submission to Turnitin is your report in an MSWord file or PDF file that must be named with your student id number followed by _A1. For example, if your student id number is 12345678, then the file you submit should be named 12345678_A1.doc .
Cover Sheet: You must include a cover sheet with you name, student ID as a minimum. Marks will be deducted for any non-compliance with any these submission requirements.
Plagiarism, cheating and collusion
Students should consult University materials on this matter at:
The following excerpt is from the aforementioned url:
Plagiarism and cheating are regarded as very serious offences. In cases where cheating has been confirmed, students have been severely penalised, from losing all marks for an assignment, to facing disciplinary action at the Faculty level. While we would wish that all our students adhere to sound ethical conduct and honesty, I will ask you to acquaint yourself with the University Plagiarism policy and procedure (http://www.policy.monash.edu/policy-bank/academic/education/conduct/plagiarism- procedures.html) which applies to students detected plagiarising
It is your responsibility to make yourself familiar with the contents of these documents.