Hi Guys,
Timeline: 2-3 business days.
Task: I seek an data analyst that can instruct what is required for collating data, leading to creation of radial heat maps. This is to analyse field agents.
Following functions are required:
a. Each Agent has a specific postcode
b. Visually present based on postcode (4-digit) and territory (km radius)
c. Territory has defined variable values
d. Upon clicking on points, show summary of data applicable to each Agent
e. Seek to replicate each map based on state and country
f. other:- allowance for similar map, replacing territory with sales value
Artefacts:
1. customised excel worksheet template(s)
2. 1x representative radial heat map (territory)
3. 1x representative dynamic heat map (sales)
Reference file/attachment:
- screenshot of a first attempt towards what I seek to achieve using [login to view URL]
Aim is to achieve 90%+ of required work for a satisfied result.
Please provide project fee amount
Kind regards
Gianni Iannazzo
create heat map
Relevant Skills and Experience
Excel/VBA
Proposed Milestones
$250 AUD - Complete work
Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.