BK
All projects
Business IntelligenceZoho AnalyticsTerritory IntelligenceDelivered

Zoho CRM Analytics & Territory Intelligence Dashboard

A territory intelligence dashboard built in Zoho Analytics to map pharmacy coverage, analyze trainer portfolios and support management decision-making across France.

Project delivered during the experience at Les Préparations de l'Apothicaire.

01 · Overview

Territory data translated into a management view.

Zoho CRM held the operational records, but management needed a reliable geographic view of pharmacies, trainer portfolios and territory coverage. The delivered Zoho Analytics solution combined an interactive France map, data-quality controls, filters, KPI views and territorial analyses to identify concentrations, under-covered areas and potential overlaps.

The Challenge

From CRM records to territorial clarity.

The challenge was to turn CRM records into dependable territory intelligence. Geographic and trainer-assignment fields first had to be reviewed and prepared, then translated into clear views that supported national coverage analysis, trainer portfolio assessment and management decisions without exposing confidential operational data.

02 · Data Architecture

CRM as the source. Analytics as the decision layer.

The delivered flow covers audit, preparation, territorial modeling and decision support. No separate ETL product or custom API layer is claimed.

  1. BI-01

    Zoho CRM

  2. BI-02

    Data Quality Audit

  3. BI-03

    Data Preparation

  4. BI-04

    Zoho Analytics

  5. BI-05

    Territory Modeling

  6. BI-06

    Interactive Dashboard

  7. BI-07

    Management Decision Support

CRM as Source of Truth

Zoho CRM provided the operational records. Zoho Analytics provided the visualization and management layer. The pre-existing CRM-to-Analytics connection is project context, not a connector implementation claimed here.

Fields Required for the View

  • Pharmacy name
  • CRM ID
  • Address
  • Postal code
  • City
  • Department
  • Region
  • Group / independent
  • Assigned trainer

These fields come from the initial specification. The final production schema is not publicly available.

03 · Territory Intelligence Map

A geographic interface for pharmacy and trainer coverage.

The delivered dashboard included an operational France map. The illustration below communicates the concept without reproducing confidential production data.

Territory view

France coverage map

Conceptual France territory mapAn abstract France silhouette divided into three generic trainer zones with anonymous location markers.
Trainer ATrainer BTrainer C

Conceptual representation — original production dashboard not publicly displayed. This abstract substitute is used only because the delivered production dashboard and its data are confidential.

Confirmed Filters

Region

All regions

Department

All departments

Trainer

All trainers

Territory / zone

All territory / zones

Abstract controls — not a pixel-perfect reproduction of Zoho Analytics.

Total Mapped Pharmacies

Delivered KPI · value withheld

Total Trainers

Delivered KPI · value withheld

Pharmacies per Trainer

Delivered KPI · value withheld

Pharmacies per Region

Delivered KPI · value withheld

Pharmacies per Department

Delivered KPI · value withheld

Portfolio Share

Delivered KPI · value withheld

Unassigned Pharmacies

Delivered KPI · value withheld

Incomplete Geographic Data

Delivered KPI · value withheld

04 · CRM Data Quality Audit

Geographic reliability started with an audit of the CRM data.

The delivered work reviewed data availability, missing fields, inconsistencies and geographic readiness before the dashboard was configured.

  1. DQ-01

    Zoho CRM

  2. DQ-02

    Data Quality Audit

  3. DQ-03

    Geographic Field Review

  4. DQ-04

    Corrections / Recommendations

  5. DQ-05

    Zoho Analytics Dashboard

Delivered audit and preparation activities

  • CRM field availability audit
  • Missing-field identification
  • Inconsistency identification
  • Geographic-field review
  • Mapping-data preparation
  • CRM improvement recommendations

05 · Delivered Capabilities

A complete territory-intelligence dashboard for operational and management use.

The documented specification and explicit user confirmation establish these capabilities as delivered.

  • Interactive France territory map
  • Pharmacy geolocation
  • Trainer territory visualization
  • Region filtering
  • Department filtering
  • Trainer filtering
  • Territory / zone filtering
  • Pharmacy detail views
  • Trainer portfolio analysis
  • Geographic distribution analysis
  • Under-covered area identification
  • Territory overlap identification
  • Incomplete geographic data indicators
  • Management-oriented territorial views

06 · Trainer Portfolio Analytics

Portfolio views connected trainer assignments to geographic distribution.

  • Pharmacy count by trainer
  • Geographic distribution
  • Main territories
  • Concentrated areas
  • Dispersed areas
  • Potentially inconsistent territory assignments

07 · Territory Management Intelligence

Coverage patterns translated into management-oriented signals.

  • Strongest coverage areas
  • Under-covered areas
  • Insufficiently animated territories
  • Potential territory overlaps
  • Geographic concentration
  • Management-oriented coverage assessment

08 · My Contribution

Delivered the workflow from CRM data audit to management dashboard.

  • Audited CRM data quality for analytics readiness.
  • Reviewed geographic and assignment fields.
  • Prepared and structured data required for territory analytics.
  • Built and configured the Zoho Analytics dashboard.
  • Implemented the France territory map.
  • Implemented region, department, trainer and zone filters.
  • Designed KPI views for territorial monitoring.
  • Built trainer portfolio and geographic distribution views.
  • Created management views for under-coverage and territory overlaps.
  • Produced CRM data improvement recommendations.

Engineering / Analytics Skills

  • Business Intelligence
  • Zoho Analytics
  • Zoho CRM
  • Data Visualization
  • Dashboard Design
  • Data Quality Audit
  • KPI Design
  • Territory Analytics
  • Decision Support

09 · Documentation Limitations

The delivered scope is confirmed; confidential and undocumented technical details remain excluded.

  • No public production screenshots are available.
  • The original production dashboard cannot be displayed for confidentiality reasons.
  • Exact formulas and the final internal data model are not available in the current portfolio sources.
  • The refresh schedule is not documented.
  • The access-management configuration is not documented.
  • No public quantitative business-impact metrics are currently available.

Engineering Takeaways

  1. 01Analytics quality depends on source-data quality.
  2. 02Territory views become useful when they connect geographic distribution to management questions.
  3. 03Portfolio analysis can surface concentration, dispersion and assignment inconsistencies.
  4. 04Clear evidence boundaries make it possible to explain a delivered system without exposing production data.