The project involves the following work. Sample data is attached with project.
1) Creation of Mockup and planning
a) Cluster identification for state trails on India's Map with click drill-downs to State- Districts- Farmer and once farmer appears, certain details will appear.
b) Interactive data Tables based on different permutations and combinations like India/State District Crop wise yield Increment or State Wise Trial Trials v/s Crop v/s Scientist visits etc.
c) Interactive and real-time Graphs/ Bar / Charts on the basis of Data.
d) Auto Geo Location facilities from photos uploaded from portal.
e) Season and Year demarcation.
f) Insertion of data through excel file, if required.
2) Developing Designs from initial mockup.
3) Converting Designs to functional webpage.
4) Developing map for state and district view to provide drill-down ability. Map should be as per latest Boundaries, especially J&K
5) Integration of charts - Yield, KVK, Area under cultivation.
a) Area under cultivation by Crop
b) On mouse over, following data should be visible
A. #of Trials
B. # of Farmers
C. # of Crops
D. Crop Area
c) On Mouse click - show Markers showing Farm locations, with Marker having a flag so that presenters knows whether particular farm has images or not, just by looking at the marker.
d) Yield Data - X Axis Year / Y Axis Yield - Bar graph so that they can compare Average Yield for any Crop for any state
e) On y axis - Yield, and on x axis - States - crop will be selectable, allow comparison based upon user selection - multiple Treatment, compare T1, T2, T3, T4, T5 - Bar Graph for particular crop. We should be able to see comparison for all crops based upon different Treatment types - All India / State
f) One more category of the crop - cereals / Vegetable / Fruits etc could be added to this analysis
g) Summary - Land Area - Total number of trials versus land area with respect to selectable states. Total number of Trials / crops and total area. E.g. 10 crops 100 acres in x state and so on.
18 freelanceria on tarjonnut keskimäärin 105725₹ tähän työhön
I have read what you required for this project. It is actually straight forward and I will be glad to be part of your team. If you are online, kindly let us chat on what you really want to do.
Hi, My self Praveen, I am having good hands-on Excel as I worked in Ericsson as Data Analyst, my work has fully depended on Excel spreadsheets. So I can meet your expectation on your project. //Regards, Praveen