Featured Project

Neomedical sales intelligence dashboard

A custom online reporting platform built for a specialist surgical distributor, giving management and regional sales teams a clear, live view of sales performance, customer momentum, product uptake, and territory opportunity across South Africa and Namibia.

The Challenge

Sales data existed, but not in a form that could drive better decisions.

Neomedical distributes ENT surgical tools to hospitals and pharmacies across South Africa and Namibia. Sales were being recorded in Pastel, including the representative attached to each sale, but the business still needed a clearer way to convert that raw information into practical commercial insight.

Management needed to understand which products were gaining traction in each region, which customers were growing or declining, how representatives were performing against expectations, and where effort should be focused to improve market penetration and new product adoption.

The Solution

A secure online dashboard with role-based access and targeted sales analysis.

Ddesign created a cloud-based dashboard system that gave management and representatives access to the information most relevant to their role. The platform was structured with tiered logins, allowing leadership to view high-level performance across territories while giving reps access to customer-level intelligence in their own regions.

The result was a practical sales intelligence platform that turned accounting data into a clearer picture of opportunity, performance, and strategic direction.

Management View

Territory visibility, target comparison, and regional turnover tracking.

The dashboard gave management a territory overview by region, including monthly turnover trends and comparisons between recent performance and target expectations. This made it easier to identify where sales were accelerating, where momentum was slowing, and where attention was needed.

Best performing customers Quick visibility into the accounts producing the strongest value so far in the year.

Best performing representatives A clearer measure of rep contribution across territories and periods.

Target opportunity Management could compare actual turnover against recent targets and capacity.

Sales Grid By Rep

A month-by-month sales grid gave the business a direct view of activity and output per representative, helping monitor consistency and target progress.

Customer Trend Analysis

Every customer could be analyzed to see whether business was increasing or declining, allowing teams to respond before key accounts lost momentum.

Product Performance Insight

Product-level graphs showed how well lines were growing in the market and where further sales effort could improve uptake.

Practical Reporting

Designed to support real commercial decisions, not just display numbers.

Top Performing Clients Highlighted the top-performing hospitals in an area and identified hospitals losing momentum by comparing the last 365 days against the prior 365-day period.

Product Usage per Customer Analyzed product usage for an individual customer across the product range, comparing recent buying behavior with historical trends.

Customised Reports Delivered custom reporting so Neomedical could compare selected products against regions, time periods, and sales quantities to support targeted sales planning.

Neomedical top hospitals and sales momentum dashboard

Neomedical product usage analysis dashboard

Neomedical custom regional sales report dashboard

Technical Approach

Automated daily upload, cloud access, and no ongoing maintenance overhead.

Because the source data lived on an internal office machine, the solution included an automated extraction and daily upload process to a secure cloud environment. Once uploaded, the latest sales data became available through the web dashboard to authorized users through login.

The platform was developed using Microsoft .NET technology with data stored on a cloud-based Microsoft SQL Server. It was designed to run reliably without day-to-day maintenance, giving the client a stable reporting platform with only an annual server cost rather than a heavy recurring support model.