Data Analysis, PPT Charts and Tables
- or -
Post a project like this2314
$$$
- Posted:
- Proposals: 30
- Remote
- #1802863
- Awarded
Market Reseach, Digital Marketing, Lead generation, Social media management, sales and Marketing
Secunderabad
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
185189819149221582929165286417378281768403183857018582141935735193430919241781935771
Description
Experience Level: Expert
Description of excel work: We require an URGENT piece of analysis and chart creation. Ideally to be completed by Sunday 26th November.
Analysis 1: Analysis of Company Recruitment Data
- we have a spreadsheet of organisational recruitment data that needs to be cut and presented by specific fields
- there are 15 key data categories (business units), within this there are 6 views of recruitment data that we want to see
- we need to create a table for each of the 6 views within each of the 15 categories ( 6 x 15 tables). there is a % small calculation required for each table.
- we then need to create a graph for each of the 6 views within each of the 15 categories ( 6 x 15 graphs)
- we then need to consolidate all 6 charts for each category on to one PPT slide (15 slides, 6 charts per slide)
- and consolidate all 6 tables for each category on one PPT slide (15 slides, 6 tables per slide)
- total of 30 slides
Analysis 2: Age demographics
- we have a spreadsheet of employee age data data that needs to be cut and presented by specific fields
- total view: create 7 charts from 7 data tables. Put charts and summary data table into PPT slide
- regional view: create 7 charts from 7 data tables for 7 regions. Put charts and summary data table into 1 PPT slide for each region (7 slides)
- business unit view: - create 7 charts from 7 data tables for 10 business units. Put charts and summary data table into 1 PPT slide for each business unit (10 slides)
Extra notes: Please only respond if you have immediate capacity
Analysis 1: Analysis of Company Recruitment Data
- we have a spreadsheet of organisational recruitment data that needs to be cut and presented by specific fields
- there are 15 key data categories (business units), within this there are 6 views of recruitment data that we want to see
- we need to create a table for each of the 6 views within each of the 15 categories ( 6 x 15 tables). there is a % small calculation required for each table.
- we then need to create a graph for each of the 6 views within each of the 15 categories ( 6 x 15 graphs)
- we then need to consolidate all 6 charts for each category on to one PPT slide (15 slides, 6 charts per slide)
- and consolidate all 6 tables for each category on one PPT slide (15 slides, 6 tables per slide)
- total of 30 slides
Analysis 2: Age demographics
- we have a spreadsheet of employee age data data that needs to be cut and presented by specific fields
- total view: create 7 charts from 7 data tables. Put charts and summary data table into PPT slide
- regional view: create 7 charts from 7 data tables for 7 regions. Put charts and summary data table into 1 PPT slide for each region (7 slides)
- business unit view: - create 7 charts from 7 data tables for 10 business units. Put charts and summary data table into 1 PPT slide for each business unit (10 slides)
Extra notes: Please only respond if you have immediate capacity
Sara H.
100% (10)Projects Completed
12
Freelancers worked with
11
Projects awarded
50%
Last project
31 Mar 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Sara, do you have the sheet with the set of the data? Your time is almost running out.
546674
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies