Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

AC579/AC584

2021-2022

DATA ANALYTICS FOR ACCOUNTING AND BUSINESS - ASSIGNMENT

Assignment 2 Part 1 – Data Analytics Report (50%)

Context:

I am the CEO of a company called D&D International. We are developing and distributing new business analytics software to companies and individuals. I currently have 3 locations, Ireland (HQ), France and  Australia. The company has been growing since 2017 and we have now a total of 1000 employees          worldwide. I have observed that some employees left the company in 2017 and returned in 2019 and I    think some of my employees may be dissatisfied by the job. In 2019, I asked my employees to fill out a  job satisfaction survey and I would like some insights to understand what might be occurring in my        company.

The survey is taken from the Indiana job satisfaction scale and includes the following questions with 5  answer possibilities (Strongly Disagree = 1, Disagree = 2, Neutral = 3, Agree = 4, and Strongly Agree = 5):

General Satisfaction

Q1: I feel good about this job

Q2: This job is worthwhile

Q3: The working conditions are good

Q4: I want to quit this job

Q5: This job is boring

Pay

Q6: I am happy with the amount this job pays

Q7: The vacation time and other benefits on this job are okay

Q8: I need more money than this job pays

Q9: This job does not provide the medical coverage I need

For your analysis, you will find my employees' details, their salary for 2019, 2018, and 2017 as well as their answers to the survey here attached.

Task:

Through utilising tools and methods that you studied, produce a report (maximum: 2000 words) which presents your analysis, results and suggestions to the CEO. Include a description of your methods to    transform, visualise and model the data in order to convincingly communicate your results.

More precisely, your report should include:

•   An introduction and background to the report

•   A formulation of the hypotheses that you will test and the description of the variables that you will process;

•   A method section, where you will describe the techniques and tools that you are using;

•   A descriptive statistics part including numbers, plots and tables;

•   An inferential statistics part describing you results, with numbers, plots and tables;

•   A discussion section, where you will formulate your insights from the data and recommendations to the CEO of D&D International

•   A conclusions section

Please attempt to produce high quality figures and to communicate statistical results using a conventional formulation.

Assignment 2 Part 2 – Data Analytics Report (20%)

Topic:

•    Identify a data analytics exercise applied to a problem (this can be an academic exercise or an organizational report) and explain how the data are analysed/processed/presented (maximum:

1000 words)

Indicative components to include:

•    Background to the organisation/problem and background/context of the analysis

•    Origin/size/storage/structure/schema of the data recorded or dataset(s)

•    Data processing/analytics justification/reasons

•    Data processing tools and/or technologies and/or techniques

•    Discussion of main findings from the report/exercise (include tables/figures)