MIS770 Data Analytics: Survey Design for ABC Corporation Employees

This assignment presents a comprehensive data analytics survey designed for the employees of ABC Corporation. The survey is divided into three sections: Demographics, Job Specifics, and Understand Employee Sentiment. The Demographics section gathers basic employee information like identification numbers, gender, postal code, and contact details, with the purpose of employee identification, legal compliance, and demographic analysis. The Job Specifics section focuses on employment type, department, position, salary, and tenure, aiming to categorize employees, understand organizational structure, and analyze cost-to-company. The Understand Employee Sentiment section explores employee satisfaction levels, work-life balance, support from co-workers, and alignment with company policies, with the goal of improving employee retention and addressing workplace issues. The assignment also includes a detailed data collection methodology, outlining the source of data (primary survey), sample (employees of ABC Corporation), method (SurveyMonkey), and reasoning behind the chosen method, as well as the survey sampling methodology, including sampling frame, target audience, and method (non-probability sampling), along with potential errors and how to avoid them. The survey design includes variable types, scales of measurement, and appropriate visualization methods for each question, providing a robust framework for data analysis. The document concludes with a bibliography of the resources used.

Sneh Mehta - S222337462 MIS770-Data Analytics
SURVEY DESIGN FOR EMPLOYEES OF ABC CORPORATION
Section 1. Demographics –
1. State your Employee identification Number as provided by your current
employer.
*TYPE RESPONSE*
Purpose- To get a count of employees and maintain records with systematic
identification. Employee number will also help to link/match old company records
with new records when needed.
Variable Type- Numerical, Discrete
Scale of Measurement- Ratio
Type of Visualization- This data does not need to be visualized as it is basic employee
information collected by the HR department.
2. Confirm your Identification using your valid Passport Number
*TYPE RESPONSE*
Purpose – Fulfill legal requirements and avoid potential crime by verifying identity
Variable Type- Numerical, Discrete
Scale of Measurement- Ratio
Type of Visualization- This data does not need to be visualized as it is basic employee
information collected by the HR department.
3. Employee TFN Number
*TPYE RESPONSE*
Purpose- To file the tax numbers with the government and link superannuation
benefits for employees.
Variable Type- Numerical, Discrete
Scale of Measurement- Ratio
Type of Visualization- This data does not need to be visualized as it is basic employee
information collected by the HR department.
4. How do you like to identify your gender as?

Male

Female

Other
Purpose- Analyze the overall company demographics, determine overall inclusivity
and examine number of women in leadership positions.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A summary table can be used to analyze this information. The
table will provide frequency and percentage of males and females in the organization.
The data can be further broken down sub-company wise to understand proporation of
females in each company.
5. State your current postal code
*TYPE RESPONSE*
Purpose- To understand where employees are from, determine distance from current
office and prospect future office locations. It also helps during emergencies and to

Sneh Mehta - S222337462 MIS770-Data Analytics
send official documents when needed. No categories given in this question as there
can be too many employees in different parts of the town.
Variable Type- Numerical, Discrete
Scale of Measurement- Ratio
Type of Visualization- A summary table will be appropriate to understand clusters of
postal codes in which employees from different companies reside. It will enable
management to make quick decision on office locations.
6. State your primary contact number
*TYPE RESPONSE*
Purpose- To contact employees and communicate information about policies, salary
credited, engagement activities.
Variable Type- Numerical, Discrete
Scale of Measurement- Ratio
Type of Visualization- This data does not need to be visualized as it is basic employee
information collected by the HR department.
7. Do you have any special needs like disability, health issues etc

Yes

No
Purpose – To protect welfare of employees with special health conditions and provide
additional assistance. To sensitize coworkers and manager when required.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A summary table will help understand the portion of
employees with disabilities. This data can be linked with employee identification
numbers and contacted to understand more
Section 2. Job specific –
8. Which company were you associated with before the transition with ABC
Corporation?

Company A

Company B

Company C

Company D

Company E

Company F
Purpose- Important for segregation of employees into clusters, match old employee
records if needed and understand employee count of each company.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A pie chart can be used to visualize proportions of employees
from different sub-groups. The frequency/ proportions can be indicated in %.
9. Select your employment type with ABC Corporation

Full Time

Part Time

Sneh Mehta - S222337462 MIS770-Data Analytics

Contractual

Casual

Other
Purpose – To segregate employees based on type of employment contract and provide
different employment benefits based on employee type. It will also help to understand
future requirements.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A pie chart can be used to visualize proportions of employees
based on their contractual information. The frequency/ proportions can be indicated in
%.
10. State the department you work in at ABC Corporation.

Sales

Relationship Management

Marketing

Finance

Purchase

Technology

Customer Service

Operations
Purpose – To categorize different teams and know the number of employees required
in each team. It will also help to understand number of employees in cost intensive
teams and plan hirings in the future.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- Since there are multiple categories in this question, a bar chart
would be appropriate to display the frequency of employees in each team.
11. State your position in your department.

Intern

Junior

Associate

Team Lead

Manager

Director
Purpose – Understand hierarchical structure of the organization and provide data to
general management for restructuring.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A bar chart will accurately represent the positions employees
serve in the organization. This can be further compared sub-company wise to
understand the organization structure.
12. Mention your current salary per annum
*TPYE RESPONSE*
Purpose - Understand cost to company and further analyze average salary department
wise, previous company average salaries etc
Variable Type- Numerical, Continuous

Sneh Mehta - S222337462 MIS770-Data Analytics
Scale of Measurement- Ratio
Type of Visualization- To represent this data we can use a frequency distribution table
and cumulative frequency distribution table. The interval width can be decided based
on range of the data collected. We can also do a comparative study for each sub-
company using a percentage polygon chart. We can create an ogive to understand the
cumulative view sub-company wise.
13. How long have you been working with the current company for?

Less than 0.5 years

0.5 year but less than 1 year

1 year but less than 2 years

2 years but less than 3 years

More than 3 years
Purpose – To identify loyal employees, average retentions rate, and conduct a detailed
study based on job roles and salary packages.
Variable Type- Numerical, Continuous
Scale of Measurement- Ratio
Type of Visualization- Using a histogram, we can understand the average time an
employee works at the organization. A simple polygon can also help us to understand
the average retention rate graph.
14. How long has it been since your last salary appraisal?

Less than 0.5 years

0.5 year but less than 1 year

1 year but less than 2 years

2 years but less than 3 years

More than 3 years
Purpose –A new large company can help appraise important job roles and analyse
data for employee retention.
Variable Type- Numerical, Continuous
Scale of Measurement- Ratio
Type of Visualization- To do a comparative study, we can create a side by side bar
chart company wise. It will be an indicative of which company’s employees have
been appraised recently and of which level. X axis will contain the company names,
and level of employees and Y axis will have frequency of time since the last appraisal.
Color coding can be used to represent various levels of employees.
Section 3. Understand Employee sentiment –
15. Are you up to date with information about ABC Corporation and our company
values? (Netsuite.com)

Yes

No

Somewhat
Purpose- Determine if there is retraining required, alignment of values of the new
company and understand acquisition sentiment in employees.
Variable Type- Categorical
Scale of Measurement- Nominal

Sneh Mehta - S222337462 MIS770-Data Analytics
Type of Visualization- A pie chart would be an appropriate measure to determine
whether employees need to be retrained on ABC Corporation’s company information.
16. What are your satisfactory levels with the current work hours?

Very unsatisfied

Fairly unsatisfied

Neutral

Fairly Satisfied

Very Satisfied
Purpose- To understand employee workload after the transition and improve
employee retention by reducing overtime, and filling new positions where there is
work life imbalance.
Variable Type- Categorical
Scale of Measurement- Ordinal
Type of Visualization- A bar chart will be able to clearly indicate the proportion of
employees based on their work hour comfort levels. This can be further analysed
based on job role and positions of employees.
17. What is the most factor you consider during your employment? (Data HR should
track)

Work-life balance

Salary package

Flexible work hours and autonomy

Culture

Work environment
Purpose- To understand what employees from different companies looking for and to
increase work satisfaction by prioritizing factors based on employee needs.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A comparative study sub-company wise using pie charts, will
help identify what employees prioritize when it comes to work satisfaction.
18. Do feel supported by your co-workers during the transition phase?

Yes

No

Somewhat
Purpose- To understand employee secretary after the transition, avoid any job
switches for important role and determine what additional support is needed.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A comparative pie chart study will help understand if there are
any issues faced by employees in each sub-company.
19. Has your job role changed significantly since associating with ABC
Corporation?

Extremely different

Somewhat different

Neutral

Sneh Mehta - S222337462 MIS770-Data Analytics

Somewhat similar

Extremely similar
Purpose – To assist employees during the transition phase by informing general
management and reposition roles to meet work satisfaction levels.
Variable Type- Categorical
Scale of Measurement- Ordinal
Type of Visualization- An overall bar chart can be presented to the general
management to analyze whether employee roles need to be repositioned.
20. Are you fairly aligned with ABC Corporation’s HR policy and assistance
services?

Yes

No

Maybe
Purpose- To understand any gaps in communication and provide assistance based on
the response.
Variable Type- Categorical
Scale of Measurement- Nominal
Type of Visualization- A summary table representing frequency or portion of
employees who are aligned with the HR policies can be represented in % form.
Data Collection Methodology:
Source of data- Primary
Survey Sample- Employees of ABC Corporation
Method- SurveyMonkey (AdamenFroy, n.d.)
Reasoning- Employees can easily fill the survey at their convenience on their phone or
laptop. The HR team at ABC Corporation simply needs to share the survey link to employees
via email. SurveyMonkey has templates and allows you to customize your survey. Data can
also be retrieved in Excel compatible format (XLS), allowing the company to analyze and
save data internally as well. SurveyMonkey also has analytical features, which can auto-
analyze certain types of questions. It is also a cost-effective method to survey the employees.
Reminders can also be easily shared with employees, which makes it a time saving method of
surveying.
Survey Sampling Methodology:
Sampling frame- Entire Population
Target Audience – Employees of ABC Corporation
Method - It is essential to take a survey of the entire population as a new database of
information is being recorded about the employees of ABC Corporation. This will enable us
to reduce the potential sampling errors while collecting all information. Therefore,
probability sampling method will not be used. By using the non-probability sampling method,
we choose sample without the regard of probability of their occurrence. This will ensure that
we have an accurate view on the entire population.

Sneh Mehta - S222337462 MIS770-Data Analytics
Potential errors that can occur are non-response error in case some employees don’t respond,
measurement error in case the employee understand the question differently and general
sampling error. By ensuring that the survey questions are clear and all employees respond,
these sampling errors can be easily avoided as the population is comparatively small.
Bibliography
AdamenFroy. (n.d.). Retrieved from https://www.adamenfroy.com/best-survey-software
Data HR should track. (n.d.). Retrieved from Smallbusiness.chron.com:
https://smallbusiness.chron.com/data-should-hr-track-60439.html
Netsuite.com. (n.d.). Retrieved from
https://www.netsuite.com/portal/resource/articles/human-resources/hr-
statistics.shtml