MIS609 Data Management and Analytics

 

ASSESSMENT 2 BRIEF
SubjectCode and TitleMIS609 Data Management and Analytics
AssessmentAdvanced DataAnalysis and Visualisation Presentation
Individual/GroupGroup
Length10- 15 Minutes
LearningOutcomes

The Subject Learning Outcomes demonstrated by successful completion of the taskbelow include:

  1. Elaborate how to manage data within organisations, teams and projects. Investigate techniques on how to collect, store,clean and manipulate data.
  2. Explore data analysis and visualisation techniques and apply when andwhere applicable.
  3. Critically analyse and apply data issues in an organisational context.
  4. Effectively reportand communicate findings to a business audience who are not necessarily IT professionals.
  5. Critically analyse and interpret data analytics, its principles and

    tools for organizational problemsolving.

    Submission

    Due by 11:55pm AEST/AEDT Sunday end of Module 4.2 (Week 8)

    Weighting

    30%

    Total Marks

    100 marks

  
  
  

 

 

Assessment Task

In groups, apply advanced data analysis and visualisation skills, and create meaningful data visualisations for a public dataset. Then, create a 10-15-minute presentation as a short video explaining the findings of your visual analysis.

 

Context

In Modules 3 and 4, you learnt about Advanced Data analytics and Visualisations techniques. You have also explored different analysis methods including descriptive, diagnostic and prescriptive analytics. This group presentation gives you the opportunity to select publicly available datasets, transform and clean data, apply advanced visualisation techniques and derive meaningful findings and insights about the data.

 

Instructions

Step 1: Form groups of two members each. You may seek help from your learning facilitator.

Step 2: Select a publicly available dataset from the internet. Alternatively, you can use the same dataset used for A1, provided it allows you to apply the below listed advanced analytical methods.

Step 3: Explore the dataset thoroughly and provide a detailed description of the data variables and attributes.

Step 4: Find out the issues that the selected data has and apply suitable steps to handle the issues and errors if any. Also transform the data variables if needed, to make it suitable for subsequent analysis. Step 5: Formulate investigative questions that you can answer using the chosen data analytical methods.


 

Step 6: Analyse selected dataset using the selected tool and implement the advanced analytics and visualisation techniques. Creating meaningful visualisations that answer your questions, support your analysis and provide further visual insights into your data.

Step 7: Based on the above analysis and visualisation charts, identify important finding and add further insights.

Step 8: Carefully identify your limitations.

Step 9: Now create a Microsoft PowerPoint presentation having the following sections:

 

Section1: Selected Dataset

  • Provide a link to dataset and add a rationale for the choice of this data.
  • Explore your data and provide a detailed description of your data exploration identifying key variables and their attributes.
  • Explain how you handled data issues.
  • What data transformations did you do to prepare the data? Explain in detail the steps used to shape and transform your data to meet your needs for this analysis.

 

Section 2: Selected Advanced Data analytics technique / Visual

  • Provide a list of objectives or investigative questions you are interested to explore in this dataset.
  • For each question, select an analysis method or approach from the list below and apply on the dataset. Explain the rationale for the choice and also state how the approach helped you in answering your investigative questions.
    • Use of data modelling and transformations
    • Use of analytical expressions on the data variables
    • Trendlines and forecasting
    • Prediction with linear regression
    • Classification with Clustering and Decomposition trees
    • Python interface with the visualisation tool

 

Section 3: Visualisations (Diagrams)

  • On every PowerPoint slide, copy a visualisation chart created for the advanced analytics, above every diagram state the objective and beneath the visual briefly explain what information/knowledge you obtained from the visual. Make as many Power point slides as you need to.
  • In the video recording, it is expected and important that the student shows the functionality of the visualisation tool, the charts, and the dashboard, by moving to the application window of the visualisation tool in the video rather than just adding screenshots in the presentation.

 

Section 4: Findings and Limitations

  • Explain your findings about the selected data as a result of advanced data analysis you performed and visualisations that you have created. Summarise your findings.
  • Enlist all the limitations you encountered in this analysis.


 

Section 5: Group Work Distribution

  • Categorically explain how work was distributed between group members.

 

Using the PowerPoint, create a video presentation in which your facilitator should be able to see you as well as the PowerPoint slides in the video. Please note that this 10-15-minutes video is like an online presentation. Both members of the group should take part in the video equally.

 

Referencing

it is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing in the Academic Skills webpage.

 

 

Submission Instructions

Submit Assessment 2 via the Assessment link in the main navigation menu in MIS609 Data Management and Analytics. The submission documents include:

  1. Video recording of your presentation
  2. Power point slides of your presentation (ppt file)
  3. PowerBI file (pbix file)
  4. Dataset used for analysis (xlsx file)

 

Please note during the submission process if you would like to include a second file in your submission, once your first item has been uploaded, click ‘Browse Your Computer’ to attach the extra documents. Then, click Final Submit button. The Learning Facilitator will provide feedback via the Markbook in the MyLearn learning portal.

 

Academic Integrity

All students are responsible for ensuring that all work submitted is their own and is appropriately referenced and academically written according to the Academic Writing Guide. Students also need to have read and be aware of Torrens University Australia Academic Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are viewable online.

Students also must keep a copy of all submitted material and any assessment drafts.

 

Special Consideration

To apply for special consideration for a modification to an assessment or exam due to unexpected or extenuating circumstances, please consult the Assessment Policy for Higher Education Coursework and ELICOS and, if applicable to your circumstance, submit a completed Application for Assessment Special Consideration Form to your Learning Facilitator.


 

 

Assessment Rubric

 

Assessment Attributes

Fail

(Yet to achieve minimum standard)

0-49%

Pass (Functional)

50-64%

Credit (Proficient)

65-74%

Distinction (Advanced)

75-84%

High Distinction (Exceptional)

85-100%

Data Selection and exploration Rationale for data selection.

 

Data exploration with data variables and attributes.

 

Identification of data issues, data cleaning and data transformation.

 

20%

 

Selected data is not suitable for this assessment.

 

Rationale for choice of data is not stated.

 

Data issued are not discussed and data variables are not explored.

 

Selected data is suitable but has not been approved by the facilitator.

 

Rationale for choice of data isstated but unclear.

 

Data issues and exploration attempted but not complete. No data transformations are attempted.

 

Selected data is suitable for this assessment and has been approved by the facilitator.

 

Rationale for choice of data is statedbriefly.

 

Data issues stated, few transformations done, and exploration attempted briefly.

 

Selected data is suitable for this assessment and has been approved by the facilitator.

 

Rationale for choice of data is presented.

 

Data issues addressed, transformations applied, and exploration sections are presented in

reasonable detail.

 

Selected data is suitable and comes from a high-quality source.

Clear and effective presentation of the rationale forchoice.

 

Data issues well addressed, data transformations applied and data exploration with key variables and attributes are all presented effectively.

Aims, Analysis and visualisations

 

Aims and investigative questions.

 

Applying advanced data analytics concepts, choice of suitable charts, analyse dataand provide

Aims and investigative questions are not listed.

 

Advanced data analytics concepts are not applied. Visualisations are not meaningful and are presented without any discussion.

Aims and investigative questions are listed but unclear and do notaddress analytical concepts.

 

A few advanced data analytics concepts are attempted but visualisations are not

Aims and investigative questions are listed and address a few analytical concepts.

 

A few advanced data analytics concepts are applied, and visualisations presented

with brief discussion.

Aims and investigative questions are listed, and they address most analytical concepts listedin the brief.

 

Most advanced data analytics concepts are applied on the data, visualisations are

Clear aims and investigative questions are listed, and they address all analytical concepts listed in the brief.

 

All advanced data analytics concepts are effectively applied on

  
 


 


 

 

meaningful explanations with insights.

 

Visualisation platform shown in the video and usedto explain each analysis with visualisation charts.

 

40%

Visualisation platform is not shownin the video.

meaningful and presented without clear discussion.

 

Visualisation platform is briefly shown but not used to explain the chartsand visualisations.

 

Visualisation platform is shown briefly and used to explain the charts and visualisations.

meaningful and presented with cleardiscussions.

 

Visualisations are meaningful and innovative and presented with adequate discussion.

 

Visualisation platform is shown and used to explain the charts and visualisations.

the data, visualisations are meaningful and presented with effective discussions.

 

Visualisations are appealing, meaningful, highly innovative and presented with detailed discussion.

 

Visualisation platform is effectively used to clearly explain all charts, visualisations, and findings

interactively.

Findings and Limitations

 

Detailed and objective discussion of the findings and limitations.

 

20%

No discussion of findings and limitations.Limited discussion of findings and limitationsFindings and limitations are there but are not objective.

Findings and limitations are discussed objectively.

Findings include new information.

Findings and limitations are discussed objectively.

Findings include newknowledge.

Use of visual aids

 

Visual aids support the spoken message.

 

Use of colour, layout, clarity and neatness of visual aids.

 

10%

 

No PowerPoint slides were used, OR PowerPoint slides were occasionally  appropriate and related to the spoken message.

The slides require

significant improvement

 

PowerPoint slides supported the presentation. They clarified and reinforced the spokenmessage.

 

However, most content requires clarityand

 

PowerPoint slides supported the presentation effectively. They clarified and reinforced the spoken message.

Demonstrate an acceptable level of design and layout

that supports the flow of

 

PowerPoint slides were carefully prepared and supported the presentation effectively. They clarified and reinforced the spoken message.

The visualaids added

impact and interest to the

 

PowerPoint slides were carefully prepared and supported the presentation effectively. They clarified and reinforced the spoken message.

The PowerPoint slides


 

 

 in design, color choice, layout, and neatness.improvement in design, layout, and neatness.information.presentation through the use of good design and layout to support the flow of information.have an excellent design and layout which supports the flow of information, and all of the required elements are well placed and clearly defined.

Effective communication

 

Ability to engage the audience. Clarity, pace and fluency.

Clear and logicalstructure.

 

10%

 

Techniques used to engage the audiencewere minimal, or mainly ineffective. The presenter occasionally spoke clearlyand at a goodpace. Difficult to understand. Lack of logical and clearstructure.

 

Techniques used to engage the  audience were adequate. The presenter usually  spoke clearly to ensure audience comprehension. Delivery was usually fluent.

Information, arguments and evidence are presented in a way that is not always clear and logical.

 

Techniques used to engage theaudience were effective. The presenter spoke  clearly to ensure audience comprehension. Delivery was fluent.

Information and evidence are adequately presented with a mostlyclear flowof ideas and arguments.

 

An interesting or original approach taken to the topic. The presenter spoke clearly and at a good pace to ensure audience comprehension. Delivery was fluent.

Information and evidence are well presented with clear and logical flow of ideas and

arguments.

 

An interesting or original approach taken to the topic. The presenter spoke clearly and at a good pace to ensure audience comprehension. Delivery was fluent and expressive. Expertly presented with a clear and logical flow of ideas, arguments.

 

Example invalid form file feedback

Join our 150К of happy users

Get original papers written according to your instructions and save time for what matters most.