From a Spreadsheet to a Sales Dashboard Ready to Use
An illustrative case study for a field sales team managing several distributors with sell-in and sell-out reports. The focus isn't replacing the spreadsheet, but making the data faster to read, compare, and act on.
This is an illustrative concept, not a real client project — the data and results shown are examples to demonstrate what we can build.
Sales has data. The problem is, the data doesn't automatically become insight.
When several distributors send reports in their own spreadsheet format, the sales job isn't just selling anymore. A lot of time also goes into merging, cleaning, and comparing data.
| Distributor | Sell In | Sell Out | Gap |
|---|---|---|---|
| Distributor A | 2,400 | 2,210 | 190 |
| Distributor B | 1,850 | 1,790 | 60 |
| Distributor C | 1,620 | 1,080 | 540 |
| Distributor D | 1,410 | 1,300 | 110 |
The hassle isn't the data itself. It's the process behind it.
Report formats differ
Every distributor can have a different column structure, product naming, period, or file format.
Repeated manual rollups
Sales has to download, copy-paste, merge, check the numbers, then build a new report for internal use.
Insight arrives late
The gap between sell-in and sell-out is only visible after the report is fully compiled, not when the problem starts happening.
One flow from a distributor's report to action.
The concept is simple: files can still come from a spreadsheet, but the normalization and analysis process is made automatic.
Distributor
Sends a sell-in / sell-out report via folder, email, or upload.
Data Reader
The system reads the file and recognizes the columns and report period.
Data Cleanup
Product name, distributor, SKU, date, and unit are standardized.
Sales Engine
Sell-in vs. sell-out, stock gap, trend, and anomalies are calculated.
Sales Alert
Sales gets a priority list of distributors/SKUs that need follow-up.
Example: a salesperson handling 8 distributors.
An illustrative scenario based on a common working pattern for field sales handling many distributors. The figures below are examples to illustrate the system, not a claim of client results.
Multi-distributor sales reporting
A salesperson handles several distributors. Every period they receive sell-in and sell-out reports, then combine them all to see performance, stock, and which distributor needs attention.
- Which distributor's performance is declining?
- Which product has high sell-in but slow sell-out?
- Where does sales need to follow up right now?
Illustrated automation architecture
EXCEPTION → distributor / SKU with a high gap → sales follow-up
- 8
- Example Distributors
- 2×
- Main Report Types
- 1
- Single View
managed in one dashboard
sell in & sell out
to read performance and priorities
The key change is how sales works.
Before / spreadsheet-heavy
- Download reports one by one
- Copy-paste into a master spreadsheet
- Align product names / SKUs
- Calculate sell-in vs. sell-out
- Find the gap manually
- Only then decide which distributor to follow up with
After / sales intelligence
- Reports enter one workflow
- Data normalized automatically
- Sell-in & sell-out compared instantly
- Gap and trend calculated automatically
- At-risk distributors flagged
- Sales focuses on follow-up and decisions
Not just a dashboard.
This workflow can be developed gradually to fit the sales team's needs.
File ingestion
Pull data from Excel, Google Sheets, email attachments, or a specific folder.
Data normalization
Mapping distributor, SKU, product, period, unit, and report structure into a master format.
Alerts & reporting
Generate a dashboard, weekly summary, anomaly alerts, and a sales follow-up list.
From spreadsheet to system, step by step.
- 01DISCOVERY
Map the current reports
Identify file sources, columns, sell-in/sell-out structure, SKU, distributor, period, and the calculation rules already in use.
- 02FOUNDATION
Create master data
Build one standard data structure so reports from different distributors can be read in the same format.
- 03AUTOMATION
Automate calculation
Calculate KPIs, sell-in, sell-out, gap, trend, and anomaly rules without building manual formulas every period.
- 04DASHBOARD
Build the sales view
A dashboard built around sales' questions: who to contact, which product has issues, and how the trend looks.
- 05OPTIONAL AI
Add an intelligence layer
If needed, AI can help generate summaries, explain anomalies, and produce follow-up recommendations from the data.