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


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.

Evner: Excel, Dataindførsel, Databehandling, Websøgning, Research

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) riyadh, Saudi Arabia

Projekt ID: #32304203

Tildelt til:

(611 bedømmelser)

35 freelancere byder i gennemsnit $433 timen for dette job

(223 bedømmelser)
(86 bedømmelser)

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 Flere

$650 USD in 7 dage
(105 bedømmelser)
(177 bedømmelser)

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 Flere

$750 USD in 6 dage
(12 bedømmelser)

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 Flere

$250 USD på 1 dag
(103 bedømmelser)
(32 bedømmelser)
(40 bedømmelser)
(34 bedømmelser)

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 Flere

$300 USD in 5 dage
(20 bedømmelser)

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, Flere

$650 USD in 7 dage
(6 bedømmelser)
(3 bedømmelser)

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 Flere

$250 USD in 3 dage
(9 bedømmelser)

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 Flere

$500 USD in 7 dage
(5 bedømmelser)

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 Flere

$300 USD på 1 dag
(5 bedømmelser)
(2 bedømmelser)

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. Flere

$650 USD in 2 dage
(2 bedømmelser)

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 Flere

$500 USD in 7 dage
(0 bedømmelser)

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 dage
(1 bedømmelse)

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 dage
(0 bedømmelser)