Royal Gold

Sales Intelligence Dashboard

Royal Gold Pvt. Ltd. · Please sign in to continue

Invalid user or password
Software Developed By Engr. Redom Dutta

Sales Intelligence Dashboard

Royal Gold Pvt. Ltd. · District, Division, Manager, Dealer & Mechanic Analytics
Management Decision Support

Turn your sales workbook into a live management dashboard

Upload the District Wise Sales Excel file. The dashboard builds itself instantly — filters by Division, District, Manager and Financial Year, full dealer & mechanic counting, and a one-click A4 PDF report.

Drag & drop your Excel file here
or click to browse (.xlsx)
Choose File
100% private — the file is processed inside your browser and never uploaded anywhere.
Smart Filters
Division, District, Manager, Financial Year, Dealer status.
Dealer & Mechanic Count
Dealers, active dealers and mechanics per district side by side.
Growth Insights
Year-wise trend, YoY growth, concentration and auto-written insights.
A4 PDF Report
Management-ready, multi-page report with logo and filters applied.
Executive Insightsauto-generated from the current filter selection
    Year-wise Sales & Growth
    Sales per financial year with YoY growth line
    Division-wise Sales Share
    Division Contribution by Year
    Stacked sales of every division across financial years
    Dealers vs Mechanics by Division
    Head-count with mechanics-per-dealer ratio
    District Performance Matrix
    X = number of dealers · Y = sales · bubble size = number of mechanics · colour = division
    District-wise Sales
    District — yearly sales
    Dealers by Division
    Active vs inactive dealers with active-rate line
    Districts per Division
    Districts that have dealers
    Active Dealers · Division Share
    Polar view of active dealer count
    Dealers & Mechanics per District
    Stacked active / inactive dealers · amber = mechanics
    How many dealers does a district have?
    Number of districts per dealer-count band
    Manager workload
    Number of managers per dealer-count band
    Dealers & Districts per Manager
    Bars = dealers · line = districts handled
    District Heat-Tiles
    Grouped by division · darker = higher · click a tile to filter that district ·
    Active Dealers · District × Year
    Number (and % of the district's dealers) that bought in each financial year
    Active Dealers · Division × Year
    Active Dealers · Manager × Year
    Active vs Inactive Dealers by Year
    Dealers that bought in each financial year
    Dealer Movement by Year
    New / reactivated / retained above the line · lapsed below
    Retention, New & Lapse Rate
    Full financial years only
    Dealer Loyalty (years bought)
    How many dealers bought in 0, 1, 2 … years
    New Dealers by First Purchase Year
    New dealers per year, stacked by division
    Average & Median Sales per Active Dealer
    Per financial year
    Districts Growing vs Declining
    Count of districts versus the previous full year
    Active Dealers by Division
    Trend over the years
    Dealers by Sales Slab & Division
    Dealers by Sales Slab & Year
    Slabs pro-rated for the year-to-date period
    District Sales Concentration
    Division Profile Radar
    Each axis scaled to the best division = 100%
    District Productivity Map
    X = active dealers · Y = sales per active dealer · bubble = total sales
    Top Gaining & Declining Districts
    Average vs Median Sales per Active Dealer
    By division (selected financial year)
    Cash / Unassigned vs Dealer Sales
    Share of cash sales by year
    Managers × Divisions
    Dealers per manager split by division
    District-wise Sales
    Dealers & Mechanics per District
    Number of dealers and registered mechanics
    District Detail Table
    Sortable · searchable · export to Excel
    Division-wise Sales
    Division Sales Trend
    Year-on-year movement per division
    Zone-wise Sales Trend
    Year-on-year movement per zone · zones group the districts (see the Zone filter)
    Division Detail Table
    Manager-wise Sales
    Dealers per Manager
    Total vs active dealers
    Manager Detail Table
    Top Dealers
    Dealer Status
    Active vs inactive
    Dealers by Sales Slab
    Number of dealers per slab
    Sales Concentration Curve
    Cumulative share of sales by dealer decile (top dealers first)
    Dealer Wise Sales
    Search by dealer name, code, district or manager
    Upload Mechanic Excel file

    Drop Excel file here

    or click to choose a file (.xlsx / .xls / .csv)

    The file is processed in your browser only — nothing is uploaded anywhere. Columns such as Division, District, Police Station, Mobile, NID, DOB, Blood Group and Date of Issue are detected automatically, and District spelling mistakes are corrected.
    Processing…
    Mechanics by Division
    Mechanics per District
    Highest mechanic strength
    Mechanics by RG Representative
    Coverage Gaps
    Districts with the fewest mechanics per dealer
    No mechanic data loaded yet. Open the Mechanic Analytics sub-tab and upload your Mechanics Excel file – mechanic counts will then appear here and in the district / division charts.
    Mechanic Directory
    Search by name, workshop, code, district or mobile
    © Royal Gold Pvt. Ltd. · Confidential — for management use only
    Software Developed By Engr. Redom Dutta
    Processing…
    A4 Report Preview