Data Analysis and Summary Report

  • Posted:
  • Proposals: 23
  • Remote
  • #2427028
  • Awarded
Susan W.
Robert A.Kathrin P.Michael B.Ivan I. + 18 others have already sent a proposal.
  • 6


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,

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Michael B.

    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?