Distribution Landing Analytics

INCREASING PROFITABILITY
USING BI AND DATA ANALYTICS FOR THE WHOLESALE AND DISTRIBUTION BUSINESS
How Data Nectar used BI and Data Analytics to predict customer need, optimize inventory, reduce receivable time to boost revenue for a B2B Office Supplies Company by 20% in 8 months.
20%
Increase in revenue in 8 months.
12%
Reduction in payment receivables
15%
Increase in high-margin product sales
Our client, a Wholesale and Distribution industry player, headquartered in London, United Kingdom, is one of the fastest-growing independent business supplies companies. They are well-known for offering high-quality office consumable supplies, with great focus on customer retention. The company offers a product line-up of more than 4000 products to more 1000+ customers across the city.

The client’s business does not undertake retail sales and operates primarily from the company’s warehouse, with the salespersons directly dealing with B2B (Offices, Factories, Showrooms, Schools) supplies customers. The business principle followed by the sales team is to focus on customer retention and create patrons with whom they can build a long-term business relationship that will facilitate upselling and cross-selling of their products.
INDUSTRY:
Wholesale and Distribution
LOCATION:
United Kingdom
BUSINESS:
Office Consumable Supplies No. of Clients: 1000
PRODUCTS:
4000; stationery, housekeeping, pantry, electronics, furniture.
SERVICE
DELIVERIES
  • Data Integration, MDM
  • Data Warehouse
  • Self-service Dashboards & Reports
  • Data Security
  • BI Support
BUSINESS REQUIREMENT
The client had a growing concern about making the right decisions to improve their operational and sales efficiencies. It is worth mentioning that the client was using the Zoho book + Zoho inventory + Zoho CRM. Data analytics and visualization capabilities of Zoho's book were limited to providing generic sales and inventory statuses.

The client was looking for more data-driven perspectives to make better decisions towards improving vendor negotiations, reducing payment receivable time and profit optimisations through cross/upselling of alternative products with better margins. A transformation from the traditional decision-making approach to 'data-driven decision making' was possible through implementing a robust business intelligence system to equip the client with dashboards and actionable insights to improve operational efficiencies.
REQUIREMENTS
Analyse data to know about:
  • Payment Receiveables
  • Customer Buying Pattern
  • Inventory Replenishment
  • Demand Forecasting
THE SOLUTION
After a detailed analysis of the client’s domain, business processes, and business model, Data Nectar Technologies defined a blueprint for Business Intelligence solution design. This was built with the intent to address the client's current business problems and also enable them to expand data analytics capabilities through the business growth journey.
  • A business intelligence system ingested data from Zoho systems including data sources like Excel & Order booking web portal.
  • Required data processing and data transformation were applied to make all data consistent and qualified to load into the MS SQL-based Data Warehouse using Talend Open Studio as a data integration and ETL tool.
Considering various dimensions required to analyse the data by a specific business user; data cubes and data marts were designed and developed to enable faster access of specific data for analysis and visualization purposes.
The following KPIs plotted on Power BI-based drill-through Dashboards and associated specific reports were designed to distribute to stakeholders on a set frequency - through email and mobile app.
  • Customer Segmentation (based on category and product demand)
  • Supplier Analysis: Across pricings, margins, delivery time & credit time
  • Account Receivable(AR) analytics: Time, invoice date, receipt date, customer type(Office, Showroom, Schools & ), top 20 best and worst customers by AR (required to define targeted sales/marketing strategies)
  • Customer Analytics - Customer segmentation by account receivable tracks, product volume, revenues, purchase patterns/order frequencies (by product, quantity, timeframe)
VALUE ADDS
  • Increased revenue
  • Improved high-margin product sales
  • Reduced Payment Receivable time
  • Improved inventory replenishment leading to reduced cost of inventory / stocking
sql-server
azure
power-bi
sap-hana
Data Security & Confidentiality
Your trust is important to us and so also is the confidentiality of your Data. At Data Nectar Technosys, we consider the privacy and protection of your data at the highest priority, along with following the provisions of the EU General Data Protection Regulation (GDPR). We follow stringent data protection guidelines and take adequate measures to ensure that we fulfil our promise of being fully GDPR compliant.
Read our Data Security & GDPR Compliance