Project Plan Dashboard - ZIP Code Heat Map Site Selection & Territory Prioritization

P osition - Remote Date : May 26, 2026 Start : May 2026 Frequency : One Time Setup and Monthly updates of Changes(ongoing)

1. Executive Summary

Create an interactive dashboard that answers: “Where is contractor demand high, supply access weak, delivery radius efficient, and customer acquisition realistic? ”

The solution combines public data into a ZIP-level opportunity scoring model with layered maps, drive-time analysis, and ranked tables.

1. Business Objectives

- Identify high-opportunity ZIP codes for new locations and sales territories
- Quantify demand vs. competition gaps
- Support data-driven site selection and monthly market tracking
- Prioritize field validation (not replace it)

- Scope

In Scope

- All 10 required visuals (see Section 4)
- Atleast 5-page dashboard structure
- Monthly data refresh process
- Interactive features (map ↔ table linking, filters, drill-down)

Out of Scope

- Real-time feeds, CRM integration, mobile app, or field visits

1. Key Deliverables - Required Visuals
- ZIP Opportunity Heat Map (core) - Color-coded by weighted Opportunity Score
- Contractor Density Map - Normalized (per 10k population / 1k businesses)




- Supply Store Competition Map - Competitor locations + 10/20/30/45-min drive-time rings
- Demand vs. Competition Scatter Plot - Four-quadrant analysis
- ZIP Code Ranking Table - Linked, sortable, exportable
- Customer Acquisition Map - Contractor status tracking
- Product Demand Proxy Map - Refrigeration/HVAC/plumbing signals
- Cannibalization / Saturation Map - Contractors per supply house ratio

Dashboard Pages Page 1: Executive Scorecard Page 2: Contractor Demand Page 3: Competition Page 4: Demographics & Density Page 5: Sales Execution

Priority Visuals (80% value) : 1, 2, 3, 4, 5

1. Recommended Tool Stack

Primary : Excel/Google Sheets → Power BI Advanced (optional) : ArcGIS / Mapbox for exact drive-time modeling

1. Timeline

- Phase 1-4 (Initial Build) : 1 Week
- Go-Live : Week 2
- Ongoing : Monthly Additions updates (4-8 hours/month)

- Deliverables

- Fully functional Power BI dashboard
- Source data model + refresh instructions

- Next Steps for Vendors (RFQ)

Please include in your proposal:

- Tool recommendation and approach
- Cost (initial build + monthly maintenance)
- Sample timeline
- Relevant work examples

Pay: From ₹5,000.00 per month

Work Location: Hybrid remote in Hyderabad, Telangana

📌 Dashboard - Power BI / Gis Dashboard Developer Zip Code Heat Map & Market Analysis (Hyderabad)
🏢 Plucky
📍 Hyderabad