Reference no: EM133773078

Business Intelligence and Data Warehousing

Assessment Task - Data Analytics Assignment

Overview
For this assessment task, you will need to form up 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 realise organisational objectives. Students are expected to show innovation and creativity in applying SAP Business Object/Predictive Analytics/or any other analytical tools and designing useful visualisation for different datasets.

Learning Outcome
The following course learning outcomes are assessed by completing this assessment task: Knowledge:
K1. Differentiate between the various applications and scope of different technologies within a business intelligence system context.
K2. Critique the major approaches to the development of business intelligence and reporting systems.
K3. Compare and contrast the architecture and related processes of data warehousing and BI systems.
K4. Explain the potential benefit of data warehousing and business intelligence.
K5. Investigate and summarise the future trends of business intelligence and data warehousing.

Skills:

S1. Apply business intelligence techniques using an industry standard approach to explore, extract and analyse enterprise data sets.
S2. Use complex multi-dimensional databases.
S3. Design and develop BI dashboard according to requirements on business performance management.

Application of knowledge and skills:
A1. Apply data analytics techniques to gain insights, predict behaviours and generate value from data.
A2. Communicate and foster realistic expectations of the role of technology and business intelligence systems in management and decision support.
A3. Adopt problem solving and decision making strategies to effectively report solutions with key stakeholders for a variety of issues relating to data warehousing and business intelligence solutions.

Assessment Details

A team of students 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.

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.

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.

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.

Data analytics report must include at least 10 references in APA style together with in-text citations.

Marks would depend on the following factors:
Depth of research to illustrate the BI application chosen
Quality of the developed BI dashboard/reporting solution (with necessary screenshots and QR code)
Variety of data analytics and quality of the findings
Quality of reference provided
Quality of report writing.

Deliverable. Self-Reflection Report
This deliverable is an individual work and can be attached to your data analytics report.
In this part, each student will write a one-page-long reflection report covering the following points:
Personal understanding of course content, and personal insights into the importance and value of the course topics.
Three most useful things you have learned from the course and explain how they could help your current learning and future professional career.
Personal feeling of SAP products used in lab exercises and assignments. All discussion is expected to be well backed with real examples.