Sedang Disiapkan

Advanced Excel Data Analysis

Task 1.

I have some data in a set of excel spreadsheets for six years. The data is a set of information for helicopter usage across 8 helicopters. There is some variation in the helicopters across the years.

The files are divided by year and by identified helicopter and in each file, the hours of use are divided up by month .

The hours of usage are categorised by a set of usage codes:

Incident HR&FM Transp Survey Pest Infra Traing Other

I need to consolidate this data into a more user friendly sheet. Specifically I need to create a table that shows usage by each helicopter, by hours per usage code for each year of the five year period.

I also need to have a table for each of the helicopters showing me hours per usage for each year and also the trends in usage by month throughout each of the years.

I am attaching some samples of the data (Park Air 1 NPS [url removed, login to view] and Park Air 1 NPS [url removed, login to view]). Overall there are 41 excel spreadsheets like this.

Task 2.

I have another spreadsheet (Flight Section - Summary of Hours [url removed, login to view]) showing similar data for earlier years. This is in a simpler format. I need to collate the data into one table. I am attaching the file.

Quality and reliability in this work is essential. In your response please demonstrate your ability to carry out a project of this kind?

If you can offer any additional analysis and trend data analysis on this data, please let me know in your response.

If you are able to carry out this sort of work to a high standard, I may have some other projects in the short and long term.

Thanks

Kate

Kemahiran: Perlombongan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: advanced excel data analysis, advanced data analysis excel, excel data analysis xls, advanced excel analysis, data analysis advanced excel, excel flight data analysis, task five, excel for data analysis, excel advanced 2010, excel 2010 advanced, data analysis for excel, nps data, survey analysis, sort excel, PEST, incident, HR Projects, helicopter, excel projects, excel data sheet, excel data processing, excel data analysis, excel advanced, data analysis, Data analysis in excel

Tentang Majikan:
( 32 ulasan ) Sydney, Australia

ID Projek: #1550183

Dianugerahkan kepada:

David3110

Hello, I am a MS Excel expert. I have taken a look at the workbooks you have provided and I am confident this is something I will be able to do for you. I am well practised in this area and I am always extremely accur Lagi

$295 USD dalam 3 hari
(1 Ulasan)
3.3

13 pekerja bebas membida secara purata $374 untuk pekerjaan ini

ethicalboy

Please see what I said.

$250 USD dalam 3 hari
(30 Ulasan)
4.7
naveenvarthaan

Hi, Did so many projects of such kind. Not only analysis , but also can present such data in visual form. Please look at one of my sample at my website. [url removed, login to view] Lagi

$250 USD dalam 2 hari
(13 Ulasan)
4.2
ifaisal

Hello I can do this for you. Please see my Private message for more details. Regards Faisal

$250 USD dalam 5 hari
(4 Ulasan)
3.4
mhtkhan

Hi Mr. Kate, I can do this job easily. Please check PMB for sample work.

$250 USD dalam 3 hari
(2 Ulasan)
3.0
rohitpithisaria

Hi... I would like to apply for the job.

$250 USD dalam 2 hari
(4 Ulasan)
3.0
cheungkc

Hi Please see detailed proposal in PM

$250 USD dalam 5 hari
(6 Ulasan)
2.9
manohartvs

Hi Kate, I am a Data Analyst by profession and I am confident of being able to produce an analysis to your requirements. I've sent you my bid in a message. Kindly peruse my bid. MAV-IT

$450 USD dalam 8 hari
(3 Ulasan)
2.7
Kubwaj

Hi Kale, Thank you for posting this requirement. Kindly check your PMB for more details. Regards.

$650 USD dalam 10 hari
(2 Ulasan)
2.1
online2610

Hi Sir, I read your all of the details of your Project. I have two years experience as a virtual assistant, and I am able to do this project in less days... Please read PM... Thanks

$250 USD dalam 5 hari
(0 Ulasan)
0.0
coolestbliss

Hey! i am expert in excel using VBA. I can do complex extraction analysis in excel using visual basic.

$250 USD dalam 2 hari
(0 Ulasan)
0.0
sharmeen007

Interested

$750 USD dalam 10 hari
(0 Ulasan)
0.0
Orsinoblue

When does your project start.

$711 USD dalam 14 hari
(0 Ulasan)
0.0