Apply data issues in an organisational context

Assignment Help Database Management System
Reference no: EM133735875

Data Management and Analytics

Assessment - Advanced Data Analysis and Visualisation Presentation

Learning Outcome 1: Elaborate how to manage data within organisations, teams and projects. Investigate techniques on how to collect, store, clean and manipulate data.

Learning Outcome 2: Explore data analysis and visualisation techniques and apply when and where applicable.
Critically analyse and apply data issues in an organisational context.

Learning Outcome 3: Effectively report and communicate findings to a business audience who are not necessarily IT professionals.

Learning Outcome 4: Critically analyse and interpret data analytics, its principles and tools for organizational problem solving.

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 Visualisations techniques. You have also explored different analysis methods and the usage of statistics in data analysis. This group presentation gives you the opportunity to select publicly available datasets, transform, perform analysis, use advanced visualisation techniques on the data, identify meaningful insight into what selected data has to offer.

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: 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 (Note: Use power query editor and DAX expressions)
Step 4: Analyse selected data using the selected tool and implement the advanced visualisation techniques. Creating meaningful visualisations that give you more visual insight into data.
Step 5: Based on analysis using visualisation, identify important finding about that data.
Step 6: Carefully identify your limitations.
Step 7: Now create a Microsoft PowerPoint presentation having the following sections: Section1: Selected Dataset
Provide a link to data.
Provide a rationale for the choice of this data.
Explain how you handled data issues.
What data transformations did you do to prepare the data?

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 from the list below and apply on the dataset. Explain the rationale for the choice of a methods and also state how the method helped you in answering your investigative questions.
Use of power query and DAX expressions
Forecasting/Prediction, Trendlines, linear regression
Clustering techniques
Decision tree/Python in power BI

Section 3: Visualisations (Diagrams)
On every PowerPoint slide, copy a diagram / chart (visualisation created for the advanced analytics) and beneath the visual briefly explain what information/knowledge you obtained from the diagram. Make as many PowerPoint slides as you want to.
It is also 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 and visualisation that you have performed.
Enlist your limitations.

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.

Reference no: EM133735875

Questions Cloud

Project to build new racetrack and park : Consider a project to build a new racetrack and park. What are some of the resource constraints that would make this project challenging?
Economic resources of healthcare organization : How can I define and study different fiscal and economic resources of a healthcare organization?
About your own leadership and leadership development : Reflect on what you have learned so far about your own leadership and leadership development going forward.
Develop professional relationships : What strategies would use to develop professional relationships ? Under what conditions would you sever a networking relationship?
Apply data issues in an organisational context : Advanced Data Analysis and Visualisation Presentation Assessment - Explain your findings about the selected data as a result of advanced data analysis
Why is it important that you can feel the sensation : Write about this sensation and discuss how you feel this sensation. Trace the probable sensory pathway. Why is it important that you can feel this sensation?
Kaye is going above and beyond in their role at work : they are being proactive in seeking out new opportunities to contribute to work projects, and they have even taken it upon themself to develop mentoring program
Addressing what to do about unhappy customer : Addressing what to do about an unhappy customer while maintaining profit margins appears to be a vexing problem.
Performance appraisal for employees in her company : Sandy is organizing a performance appraisal for the employees in her company.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd