PowerBI GeoJSON Dashboard for NYC
Budget: $250 – $750 USD
I need a PowerBI dashboard created using a GeoJSON map for NYC zip codes and District Offices. The dashboard should connect to SQL/Server database
Key Requirements:
- Utilize GeoJSON for mapping
- Integrate with a SQL/Server database
- Visualize NYC zip codes and District Offices
- three reports (2 very simple, one slightly complex, merge/dissolve polygons)
1. Create heat map for Zip Codes based on the sales (Zipcode GeoJson file will be provided)
2. Create heat map for Districts based on the sales (District GeoJson file will be provided)
3. Create a new GeoJason file ServiceDistricts by merging zip code to ServiceDistrict mapping (e.g. ServiceDistrict1 has 3 contiguous zip codes 11203,11226, 11218) - this is design time mapping only. Once created, ability to dissolve polygons at run time is not required.
4. Create zip code dashboard based on the amount spent by various filters (about 5 categories), provide a toggle switch to overlay ServiceDistrict polygon layer over the top of zipcodes.
Ideal Skills:
- Expertise in PowerBI
- Proficiency with GeoJSON and mapping
Key Requirements:
- Utilize GeoJSON for mapping
- Integrate with a SQL/Server database
- Visualize NYC zip codes and District Offices
- three reports (2 very simple, one slightly complex, merge/dissolve polygons)
1. Create heat map for Zip Codes based on the sales (Zipcode GeoJson file will be provided)
2. Create heat map for Districts based on the sales (District GeoJson file will be provided)
3. Create a new GeoJason file ServiceDistricts by merging zip code to ServiceDistrict mapping (e.g. ServiceDistrict1 has 3 contiguous zip codes 11203,11226, 11218) - this is design time mapping only. Once created, ability to dissolve polygons at run time is not required.
4. Create zip code dashboard based on the amount spent by various filters (about 5 categories), provide a toggle switch to overlay ServiceDistrict polygon layer over the top of zipcodes.
Ideal Skills:
- Expertise in PowerBI
- Proficiency with GeoJSON and mapping