Skip to content
Social Jin — digital marketing agency in NagpurSOCIALJIN
Case Study · Operations · India

Sanjay Singh / TSSone screen instead.

A live operations dashboard replacing the weekly ritual of reconciling files by hand.

Studio Desk · ActiveNagpur · In-House
Client
Sanjay Singh / TSS
Service
Dashboard
Category
Automation
Coverage Period
Since deployment
MIHAN & MIDC HQ 100% Accountable
One screenReplaced four files
LiveNot weekly reconciliation
MobileReadable in 30 seconds
Scroll
[01]The Brief

What the client came to us with & where they started.

Professional services Profile

TSS needed a dashboard. Operational data was spread across several spreadsheets maintained by different people, and producing a single view of the business took a manual reconciliation every week.

What We Found

The reporting delay was the visible symptom. The real cost was that decisions were being made on numbers that were several days old and quietly contradicted each other, and nobody could tell which file was authoritative. This is the point at which a spreadsheet has stopped being a tool and started being a liability.

[02]What We Did

Execution workstreams shipped in-house.

01

One source of truth defined first

Before building anything we established which figures are authoritative and how each is calculated. Most dashboard projects fail here — a beautiful interface over inconsistent definitions is a faster way to be wrong.

02

Scattered data consolidated

The separate sheets were brought into a single structure, with entry points that prevent the same field being recorded three different ways by three different people.

03

A screen a director can read in thirty seconds

Headline operational figures at the top, detail available underneath. Built mobile-first, because the person who most needs it is rarely at a desk when the question comes up.

[03]What Changed

Quantified metrics & results.

Replaced four files

One screen

Not weekly reconciliation

Live

Readable in 30 seconds

Mobile

Summary of Impact

The weekly reconciliation disappeared and operational figures became current rather than several days old. Discussions now start from a number everyone agrees on, which is most of what a dashboard is actually for.

Achieve Similar Growth

Want results like Sanjay Singh / TSS? Book a call

Book a free 30-minute diagnosis call with our senior team. We will review your current setup and give you a straight, fixed proposal.

No Pitch DeckNo JargonNo Obligation100% In-House Nagpur