What you get with this Offer
Business data has value, but only if it the relationships can be teased out. I have many years experience developing bespoke Excel models, but the key first step is to understand the current data and relationships.
Where appropriate I will undertake the following techniques to understand any relationships within your data:
- charts/graphs - using appropriate formats to visualise the any trends of underling relationships;
- pivot tables to summarise your data;
- formulas/regression analysis to confirm any relationships.
I will work closely with you to understand what you are looking to draw out from the data, and develop a output format that matches your expectations. This will include the design of output that could be used within presentations to the board for example.
In my experience the format of the output (number of sheets, use of colour, summary tables and the use of charts) is just as important as the actual analysis of the data.
Although this hourlie covers a snapshot analysis of your data I will also discuss with you if you would like to undertake further development, which could include monthly tracking and key performance indicators (KPIs) for example.
What the Freelancer needs to start the work
Data for analysis in Excel of CSV format.
Description of the data, including the type of relationship(s) that would be expected.
Description of the proposed use of the output, and level of technical expertise of the target audience.
Company logo etc to customise output.