Concluído

employee survey raw data to a pivot table

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.

Habilidades: Excel, Processamento de Dados, Processamento de dados, Busca na Web, Pesquisa

Veja mais: vbscript read data source excel pivot table, show data existing pivot table, vbscript change pivot table data source, change data connection pivot table, source data pivot table vbscript, sql server data pivot table vbasript, macro refresh powerpivot data pivot table, convert raw excel table data pivot table results, excel convert pivot table raw data, organize data pivot table, excel pivot table data raw data, convert pivot table raw data, fill data pivot table yes questions, excel pivot table raw data, big data pivot table, pivot table different filters for each column, how to extract raw data from pivot table, contoh data pivot table

Acerca do Empregador:
( 1 comentário ) riyadh, Saudi Arabia

ID do Projeto: #32304203

Concedido a:

(611 Comentários)
8.3

35 freelancers estão ofertando em média $433 nesse trabalho

(223 Comentários)
7.0
(86 Comentários)
6.6
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 Mais

$650 USD in 7 dias
(105 Comentários)
7.0
(177 Comentários)
6.5
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 Mais

$750 USD in 6 dias
(12 Comentários)
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 Mais

$250 USD em 1 dia
(103 Comentários)
5.8
(32 Comentários)
5.2
(40 Comentários)
5.0
(34 Comentários)
4.6
GabrielBarreiro1

Hello, I have experience and skill in the creation of dashboards and in everything related to graphic interpretation of data through MS Excel. I can achieve an optimal combination between functionality and visualizatio Mais

$300 USD in 5 dias
(20 Comentários)
4.6
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, Mais

$650 USD in 7 dias
(6 Comentários)
4.9
(3 Comentários)
4.1
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 Mais

$250 USD in 3 dias
(9 Comentários)
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 Mais

$500 USD in 7 dias
(5 Comentários)
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 Mais

$300 USD em 1 dia
(5 Comentários)
2.5
(2 Comentários)
1.3
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. Mais

$650 USD in 2 dias
(2 Comentários)
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 Mais

$500 USD in 7 dias
(0 Comentários)
0.0
Ahsan2526

Hi, I am a Chartered Management Accountant (CMA) and will do your work . You can see my portfolio [login to view URL] Looking forward to discussing with you. Thanks

$250 USD in 7 dias
(1 Comentário)
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 in 7 dias
(0 Comentários)
0.0