Client: A Global UK based consumer goods company, focused on hygiene, wellness, and home care products.
The scale of the business expanded to small towns and rural areas where distributors didnt have software to manage inventory. This reduced visibility for the company into its tertiary sales figures.
To address these challenges, data from the dealer/distributor management system, raw Excels, and Sap have been used and compiled into the sales data warehouse. We have identified gaps, decoded embedded logic, implemented a Sales Analysis Solution in the warehouse, and incorporated E-commerce Tracking. This enabled the segmentation of strategies based on primary and secondary sales, returns, and collections. Notably, E-commerce tracking mechanisms have been established, and key performance indicators (KPIs) have been introduced using interactive Power BI reporting.