Auditing data holdings and gap identification

Assignment Help Database Management System
Reference no: EM132406463 , Length: 26 pages

Data Handling and Decision Making

Assignment Brief

As part of the formal assessment for the programme you are required to submit a Data Handling and Decision Making report. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments.

Learning Outcomes (LO):

After completing the module, you should be able to:

1. Analyse methods of auditing data holdings and gap identification.

2. Critically analyse theoretical and core processes of data manipulation and mining.

3. Utilise and evaluate basic statistical concepts.

4. Appreciate ethical issues and their importance to data handling and decision making.

5. Develop a practical ability with data analysis and data mining methods to analyse and interpret data sets.

6. Make recommendations based upon the findings from data analysis.

7. Graduate Attribute - Effective Communication

Communicate effectively both, verbally and in writing, using a range of media widely used in relevant professional context.

Assignment Task - Report

The aim of this assignment is twofold:

• Conduct and report on an audit of the data environment in an organisation of your choice.

• Based on the outcomes of the audit, develop a report presenting statistical analysis of a large data set coupled with a concluding narrative demonstrating appropriate recommendations.

An audit of the data environment an organisation operates in represents a starting point in developing a big data analytics framework, and as such, is a key part of data enabled decision-making at all levels. This audit should include the following processes:

• Identification of major data sources and flows between the organisation and its stakeholders;

• Formulation of the improvement in data integrity as well as its storing, processing and reporting mechanisms;

• Recommendations on compliance procedures, specifically, data protection, privacy and ethical assurance.

A statistical analysis of a large data set is used to support and enhance the decision-making process in a case organisation. It should include the following components.
• Identification of a strategic decision which can be supported by data analytics;

• Description of relevant dataset;

• Selection and application of data mining procedures to the data set in question.

• Development of a report on forecasting and/or trends obtained through data mining, which should be visualised with tables, charts and diagrams.

• Recommendations based on the outcomes of the aforementioned analysis.

Task 1

What are the key sources and flows of data that are collected, processed, stored and taken into account in the organisation's decision-making process? Your response must include:

• A statement of all the current financial and non-financial data the organisation uses in its decision making;

• An analysis of data integrity and identified gaps;

• A map between business functions and data sources.

Task 2

Based on the outcomes of your response to Question 1, a specific proposal must be developed on a streamlined and more informed decision making based on (a) additional analysis of the currently observed data, and (b) any extra types of data that can be retrieved, stored and processed for augmenting the currently available information. Your response must include:

• Description of data flows between the organisation and all of its stakeholders identified and ranked in terms of their relevance to strategic, tactical, and operational decision making;

• An approach to the improvement in data integrity of the proposed data analytics framework;

• Data protection and ethical assurance requirements.

Task 3

Statement of a specific decision the organisation currently needs to make, and how big data are expected to improve its quality. Your response must include:

• A statement of major strategic decisions and how the current financial and non- financial data are currently used in respective decision making;

• Statement of a particular decision selected for data analysis, and its critical importance for the organisational competitive advantage or performance improvement;

• Identification of a specific data set to be analysed for supporting the stated decision. The assignment must utilise a large data set obtained from the chosen organisation.

Task 4

Description of a relevant dataset to be applied for the improvement of the selected decision, including:

• Discussion of business-related information the dataset represents;

• Explanation how it has been obtained;

• Analysis of how representative the data set is, and potential limitations associated with its application.

Task 5

Discussion of data mining procedures with the dataset in question, performed using Excel, SPSS and / or Weka, which include:

• Data preparation, cleaning and filtering;

• Statement of immediate observations of business performance using descriptive data analysis;

• Development of an organisation's forecast report based on inferential data analysis and / or application of machine learning techniques.

Task 6

Visualisation and interpretation of results as expected in business and academic reporting - this discussion must be supported extensively by tables, charts and diagrams demonstrating how the outcomes of analysis performed in the previous task can be interpreted.

Task 7

Recommendations for the decision making based on the analysis described earlier as well as a proposal on the deployment of extra data sources potentially capable of further augmenting the organisational big data framework.

Reference no: EM132406463

Questions Cloud

Review the processes of invention and innovation : Review the processes of invention and innovation. Then, select a new product that you have been introduced to in the past 12 months
Determine the transaction price for this contract under ifrs : The customer hopes to rent apartments at the beginning of the school year and offers a performance bonus of $145,500 to be paid if the building is ready.
What is the depreciation expense of project : What is the depreciation expense of this project in Year 4? Round to the nearest penny. Do not include a dollar sign in your answer.
Misleading to an uninformed borrower : Explain why this rate is misleading to an uninformed borrower. Use 365 days a year - Do not round intermediate calculations and round your final answer
Auditing data holdings and gap identification : Analyse methods of auditing data holdings and gap identification and Critically analyse theoretical and core processes of data manipulation and mining
Describe how the manual is developed : Describe how the manual is developed. Describe the evolution of the manual in the zeitgeist and/or progress of our growth as a profession.
How much will dividends per share for each year be : Assume the payout ratio in each year is to be 20 percent ofthe net income and the firm will pay a 10 percent stock dividend in years 2 through 5.
What is project w net present value : If the cost of capital is 14%, what is Project W's net present value (NPV)? What is Project W's IRR? What is Project W's MIRR?
What do you think are most important ethical considerations : What do you think are the most important ethical considerations that a healthcare organization must address when developing a marketing strategy

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