employee survey raw data to a pivot table

Terminé Publié le il y a 2 ans Paiement à la livraison
Terminé Paiement à la livraison

I am running an employee survey with around 50 questions to around 300 employees. Each question is tagged with three different markers that measure 3 different dimensions within the organization. see link below for a sample of the questions

https://docs.google.com/spreadsheets/d/1eC2pGtnvyXwr8z4bty7YU1xTCUSjCwbf/edit#gid=2137896613

The survey engine will spit out the data without the tags. see attached file for a sample of the output of the survey engine.

the requirement,

I would like to someone who is an expert in excel and pivot tables to help me with

1- adding the three tags (drivers, values, effectiveness) to the questions in the output of the survey engine.

2- I need to change the scale from strongly agree -- strongly disagree to 1 - 5 (5 being strongly agree)

3- I need to create a pivot table that can help me drill down and see the average score of each dimension

Filter by gender, length in organization, job grade, value, driver, effectiveness, Saudi or non-Saudi.

Final product I should have a pivot table that can help me find out the following

- what is the average score (out of 5) for the value of respect with females who have been in the organization for less than three months - this for example will take all the questions tagged with the word respect and filter them and shows only female employees who have been in the company less than 3 months

freelancers need to use the sample data I shared to show me what kind of work they can produce. Once we ensure the outcome - a freelancer will be hired to help me create the pivot table for the real data.

Excel Saisie de Données Traitement de Données Recherche sur Internet Recherche

Nº du projet : #32304203

À propos du projet

35 propositions Projet à distance Actif il y a 2 ans

Décerné à:

(611 Commentaires)
8.3

35 freelances font une offre moyenne de 433 $ pour ce travail

suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Plus

$650 USD en 7 jours
(105 Commentaires)
7.0
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Plus

$750 USD en 6 jours
(12 Commentaires)
5.9
topacademictutor

employee survey raw data to a pivot table I have 13 years of experience in the Writing Industry and I can provide you with “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIARIS Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(103 Commentaires)
5.8
techplusintl

Hi there, ★★★ Data Processing / Entry (Word/Excel/PDF Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to work on your project. I can do any type of excel,Data science,Data processing data entry, Plus

$650 USD en 7 jours
(6 Commentaires)
4.9
EmiliaSimon

Hello, I have seen your requirements and the attached files, and I am ready to help you process your employee survey data and display it in a pivot table with filters. I am a Data Analyst with extensive experience in m Plus

$250 USD en 3 jours
(9 Commentaires)
3.5
hirayousuf13

Hi, I am an experienced research report writer with an undisputed reputation for meeting my clients’ expectations. I have been writing for the past 5 years and have written over 1000 plus high-quality plagiarism fre Plus

$500 USD en 7 jours
(5 Commentaires)
3.3
Rgoutham8500

Warm greetings! I am data entry operator. I'll try to do your work as per your requirement. Even though I started my new journey as freelancer, you don't worry about the perfection of the work. Will do the work with10 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
2.5
BlessAccounts

Hi, I am a qualified Chartered Accountant with more than 10 years of experience in accounting and finance. My profession involves me to work and play around with figures and calculations and I love working with Excel. Plus

$650 USD en 2 jours
(2 Commentaires)
1.3
vipdesignbd

assalamualaikum ⭐⭐⭐⭐⭐ Thanks for sharing your project details .You need a quick and talented designer for the job I will design your Project. I have checked your description that you have added, yes i can do it because Plus

$500 USD en 7 jours
(0 Commentaires)
0.0
Vikas1985tex

I am a Ph.D. writer with 5 years of experience. I’ve worked on several similar projects compiling presentation slides and lecture notes into a single set of notes. I can deliver quality notes to tight deadlines.

$500 USD en 7 jours
(0 Commentaires)
0.0
Ankit112002

I have essential skills, knowledge and submit the work before time. I am also a Data Entry operator.

$625 USD en 7 jours
(0 Commentaires)
0.0
rubabkhan20000

Hello, I read your project and understand it what actually you need. I think its time to discuss your porject to complet it in time

$500 USD en 7 jours
(0 Commentaires)
0.0
parthg31

Hi This is Parth Gupta from Gwalior Madhya Pradesh India. I am a working professional in Accenture, and I have experienced in Excel and data analysis. I have done this kind of thing in my internship. With all this kind Plus

$400 USD en 5 jours
(0 Commentaires)
0.0
Yolla12

Kepada Yth, Bapak/Ibu Recruiter Izin memperkenalkan diri, perkenalkan nama saya Yolla Eka Destiani merupakan mahasiswi S1 lulusan tahun 2020 Universitas Esa Unggul jurusan Akuntansi lulus dengan IPK 3,43 Saya memil Plus

$600 USD en 13 jours
(0 Commentaires)
0.0
GOURAV184

Hii i'm gourav. I'm from indian and i'm a great work at all and I'm interested in this job. You can just hire me because I can do it best and fast. So you final decision. Please reply me.

$500 USD en 7 jours
(0 Commentaires)
0.0
nishigandhabende

Good morning ! I have been a virtual assistant specialising in data entry, copy writing, form filling over 3 . I provide quick, high quality work to my on every as soon as possible. I look forward to hearing from yo Plus

$500 USD en 7 jours
(0 Commentaires)
0.0
csarkar976

Hii. So I like to make pivot tables and work in excel that makes me suitable for the projects .. i have little bit experience in this field as well . So we can discuss mor about it if you like to...thank you

$500 USD en 7 jours
(0 Commentaires)
0.0
dineshdsd6743

i am doing this job perfectly and satisfying for this work so please consider my requirements thank you

$250 USD en 7 jours
(0 Commentaires)
0.0
richa818

I can do the work and deliver exceptional results to the company. I will fit in beautifully and be a great addition to the team. I possess a combination of skills and experience that make you stand out.

$500 USD en 7 jours
(0 Commentaires)
0.0
Maysha216

My name is Maja Vidovic and im 33 years old.  Im looking for dara entry jobs, that are serious and reliable. I have 6 years of experiences from office work, being assistant, doin data all the time. Im good in Google Sh Plus

$300 USD en 7 jours
(0 Commentaires)
0.0