
Data Analysis, PPT Charts and Tables
- or -
Post a project like this2961
$$$
- Posted:
- Proposals: 29
- Remote
- #1802863
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing

Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦

Market Reseach, Digital Marketing, Lead generation, Social media management, sales and Marketing

AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
1851898111412814670171133729140641617378281935771193573548649515829298959681768403
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