CRICOS Provider No. 00103D | RTO Code 4909
ITECH7406 – Business Intelligence and Data Warehousing
Assessment Task – Data Analytics Assignment
Overview
For this assessment task, you will need to form for a team of up to 5 members to conduct data analytics over a dataset. Students need to investigate the practice, approaches and understanding of business intelligence as it is being applied in the real world to realize organizational objectives. Students are expected to show innovation and creativity in applying SAP Business Object/Predictive Analytics/any other analytical tool and designing useful visualisation for different datasets.
Timelines and Expectations
Percentage Value of Tasks: Group Presentation 10%
Group Report 20%
Due: Refer to Course Description
Minimum time expectation: 40 hrs
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment task:
Knowledge:
K1. Investigate the scope and application of various technologies within a business intelligence system context.
K2.Investigate the major approaches to the development of business intelligence and reporting systems.
K3.Apply the theories and principles of data warehousing in diverse contexts.
K4. Explain the potential benefit of data warehousing.
K5. Describe the relationship between business intelligence and data warehousing.
Skills:
S1. Apply business intelligence techniques using an industry standard approach to explore, extract and analyse enterprise datasets.
Application of knowledge and skills:
A1. Communicate and foster realistic expectations of the role of technology and business intelligence systems in management and decision support.
A2. Adopt problem solving and decision making strategies to communicate solutions with key stakeholders for a variety of issues relating to data warehousing and business intelligence solutions.
Values:
V1. Value the need to work collaboratively and autonomously on business intelligence and data warehousing problems.
V2.Appreciate the strategic importance of business intelligence data.
Assessment Details
A team of students first need to select a dataset of choice, design and develop the reporting solution/BI dashboard, and through research into the literature and analytics on selected dataset provide a comprehensive report.
Some datasets/sources:
Frontpage
You are welcome to find other datasets for the assignment. Please contact your tutor/lecturer to check if your dataset is appropriate first.
Once you have selected your dataset, each member should select a different analysis tool or a different analysis technique to analyse the dataset and create proper visualisations. The data analytics performed by individual members should be integrated together as a team effort. The analytics conducted by a team is expected to cover at least two types of analytics out of descriptive predictive and prescriptive ones. Based on your analytics results, give relevant recommendations to the management team of the related company or organisation. The team will also design and develop a reporting solution or BI dashboard for mobile users, and justify the design of it.
The assessment includes two deliverables.
Deliverable 1. Group Presentation
Subject to the teaching mode in Week 10, your team may need to give an oral presentation in class or create a video presentation using Kaltura Capture, to report your findings in your data analytics work.
In case you need to create a video presentation, each member should create an individual video using Kaltura Capture to record both your Powerpoint slides and your face. The links to the videos should be included in a Word file in the proper sequence, and submit the file to Moodle. Please refer to the instructions on Kaltura Capture (https://federation.edu.au/staff/learning-and-teaching/elearning-hub/kaltura/how-to) to get familiar with the video recording tool and make your video accessible by the marker.
The total length of all these individual videos from a team should be no longer than 10 minutes.
Deliverable 2. Data Analytics Report
The data analytics report should draw on the dataset to give the insights into the data through diverse data analytics, and present your recommendations to the management team. The report should include a comparison and integration of the tools/solutions/visualisations used by different team members, as well as the design and development of your reporting solution or BI dashboard. Please check the marking criteria for the detailed requirements of the report.
Minimum words: 3000
Data analytics report must include at least 10 references in APA style together with in-text citations.
The report should follow a formal report structure with cover page, table of contents, introduction, use of headings, subheadings, conclusion sand reference section.
Marks would depend on the following factors:
- Depth of research to illustrate the BI application chosen
- Quality of the developed BI dashboard/reporting solution
- Variety of data analytics and quality of the findings
- Quality of reference provided
- Quality of overall team presentation
- Quality of report writing.
Submission
Your presentation Powerpoint files (together with links to your Kaltura videos if needed), and your data analytics report should be submitted to the drop boxes on Moodle. One submission is needed from a team.
Marking Criteria / Rubric
Please refer to the .
Feedback
Feedback will be supplied through Moodle.
Authoritative results will be published on fdlMarks.
Academic Misconduct
To submit your assessment task, you must indicate that you have read and understood, and comply with, the Federation University Australia Academic Integrity and Student Plagiarism policies and procedures (http://policy.federation.edu.au/learning_and_teaching/compliance/academic_integrity/ch02.php).
You must also agree that your work has not been outsourced, and is entirely your own except where work quoted is duly acknowledged. Additionally, you must agree that your work has not been submitted for assessment in any other course or program.
ITECH7406- Business Intelligence and Data Warehousing
Marking Guide – Group Presentation (10%)
Each team is expected to create and present a 10-minute overview of data analytics report.
Student IDs:
Assessment Criteria:
| Criteria | Marks | |
|
Introduction |
/1 | |
|
Content – integration, comparison, findings, implications |
/5 | |
|
Conclusion |
/1 | |
|
Presentation Style eg. clarity, engagement, visual aids, etc. |
/2 | |
|
Timing (10 minutes) |
/1 | |
| Total | /10 | |
|
General Comments: |
ITECH7406- Business Intelligence and Data Warehousing
Marking Guide – Data Analytics Report (20%)
Student IDs:
Assessment Criteria:
|
Tasks |
Max Marks |
Marks Awarded |
Comments |
| Introduction to the dataset, background, data quality, any data transformation before analytics, and your BI reporting solution/dashboards design for the Senior Executives of chosen dataset. | 2 | ||
| Design Mobile application using QR code for your insights /solutions/dashboard – Please provide your QR code in your assignment | 2 | ||
| Justify why these BI reporting solution/dashboards are chosen and why those attributes are presented and laid out in the fashion you proposed (feel free to include all other relevant justifications using the academic articles). Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your assignment report (i.e. the report to the senior executive team of the company). | 2 | ||
| Discuss the findings of your data analytics in depth, with corresponding visualisations (eg. screenshots, charts, diagrams, reports, etc.). At least two types of analytics out of predictive/prescriptive/descriptive are expected to be applied. For complex analytics, please also explain your configuration of the algorithm. Compare the techniques used by different members, and discuss the differences | 8 | ||
| Furthermore, the CEO would like to improve the operations. Based on your BI analysis and the insights gained from “Data Set”, make some logical recommendations to the CEO, and justify why/how your proposal could enhance company operations, sales etc. Include the relevant screenshots of the BI analysis, and also any assumptions that you may have made about the analysis. | 2 | ||
| Report is well-written and presented professionally, containing: Title page Executive Summary (outlining the scope of report, key findings and recommendations) Table of Contents Appropriate use of headings within report Appropriate use of figures (i.e. graphs, summary tables) and References (APA Style)- in text and bibliography (10 articles) | 4 | ||
| Total Marks | 20 | ||
| Total Percentage | 20% |
