Data Analysis and Summary Report
- or -
Post a project like this1758
$$
- Posted:
- Proposals: 18
- Remote
- #2427028
- Awarded
Data analyst (IBM SPSS/ R/ RStudio/ Power BI) |Excel Expert (Dashboard/ Macro/ VBA/ Power pivot)
Brisbane
1668440205323527829882766612275302727356422611300260516225224802210990208270
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
UPDATE: Please find sample datasets attached. I could only attach 3 (Thanks PPH!) but there are 2 others which are similar but have other secondary details. Thanks - Wayne.
--------------------------------------------------------
Wonder if you can help. I am looking for someone that can help me analyse data held in multiple Excel spreadsheets, with a view to sanitising and summarising the data. The content of the data relates directly to applications in our organisation, and we are looking to determine; which are compatible/not compatible with Windows 10 (using Microsoft's "Ready for Windows" online checker tool), which are business critical and which require upgrade. Alongside this, we would need numbers of each.
Secondary to this, we would like to understand areas where we can consolidate applications either because they are not used, have multiple versions etc. There are 5 sources of data, and merging all of this data will give the answers we are looking for. All the sources are excel spreadsheets. We have an aggressive timescale (circa. 1 week) but could extend to ensure an accurate picture. Primarily the requirement is to combine, sanitise and analyse the data to output; Applications that are compatible / non-compatible with Windows 10, Applications requiring an upgrade to be compatible with Windows 10, Application lists by department, role and criticality, Applications that can be consolidated (due to multiple versions, low usage patterns, zero installs etc), all with a view to understanding which applications we should test before deploying Windows 10.
Is this something you might be interested in helping us with? Please respond with a quote and likely time needed if interested, and to open an initial discussion to clarify the requirements. Sample data is available on request.
Much Thanks,
Wayne
--------------------------------------------------------
Wonder if you can help. I am looking for someone that can help me analyse data held in multiple Excel spreadsheets, with a view to sanitising and summarising the data. The content of the data relates directly to applications in our organisation, and we are looking to determine; which are compatible/not compatible with Windows 10 (using Microsoft's "Ready for Windows" online checker tool), which are business critical and which require upgrade. Alongside this, we would need numbers of each.
Secondary to this, we would like to understand areas where we can consolidate applications either because they are not used, have multiple versions etc. There are 5 sources of data, and merging all of this data will give the answers we are looking for. All the sources are excel spreadsheets. We have an aggressive timescale (circa. 1 week) but could extend to ensure an accurate picture. Primarily the requirement is to combine, sanitise and analyse the data to output; Applications that are compatible / non-compatible with Windows 10, Applications requiring an upgrade to be compatible with Windows 10, Application lists by department, role and criticality, Applications that can be consolidated (due to multiple versions, low usage patterns, zero installs etc), all with a view to understanding which applications we should test before deploying Windows 10.
Is this something you might be interested in helping us with? Please respond with a quote and likely time needed if interested, and to open an initial discussion to clarify the requirements. Sample data is available on request.
Much Thanks,
Wayne
Wayne W.
100% (5)Projects Completed
5
Freelancers worked with
4
Projects awarded
67%
Last project
11 Sep 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Wayne,
Can you quantify the volume of data to analysed? Secondly, are you looking at MS Office only products or are there others in the Microsoft catalogue of products that need to be looked at?
816380
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