Retail Case Study

:: Subject

Client can track the Store, SKU and Territory Wise Productivity



:: Challenges

  1. Geographical territory planning for informational tracking purposes.

  2. The client was unable to perform manual checks to validate incoming invoices.

  3. Store Keeping Units (SKU) rationalisation.

  4. Inventory management for the SKU's and their transferred locations.

  5. Plot key competitors to better understand the retail environment you’re competing in.



:: Our Solution

  1. Planning out sales territories with front line reps or justifying territory boundaries to retail partners creates a range of challenges often due to a lack of information to support decision making.

  2. Use of Power BI to visualise your retail geography. Overlay analytics to show under–supported areas or territory overlap.

  3. Integrate big data feeds such as population and demographics to help support commitment to a retail location.

  4. Analysed key competitors to better understand the retail environment you’re competing in with the help of Big Data Analysis.

  5. As business expands a portfolio of SKUs can begin to get away on you. Low or negative margin lines become lost in the mix and begin to erode net margin.

  6. Leverage Power BI associative data model to start at any point in your product hierarchy and identify the true drivers of both positive and negative to margin.

  7. Identify under-performing SKUs build performance trending to help explain cyclical and seasonal dependencies and stay one step ahead of maintaining a healthy and efficient product portfolio.

  8. Build custom categorisations to group your customers by purchase history demographics geographies and personality.

  9. Identify under-performing SKUs build performance trending to help explain cyclical and seasonal dependencies and stay one step ahead of maintaining a healthy and efficient product portfolio.



:: Result

  1. Geographical Territory tracking was able to be done by the client.

  2. Sales visits were transformed into Outcome-based visits.

  3. More and readily available information available about the performance of the product with no or less paperwork.

  4. Being able to anticipate or react rapidly to the new sources of incidents.

  5. Dramatic improvement in process efficiency with data-driven insights and analytics and real-time transparency.

  6. Client was able to identify the under-performing SKU's and took actions over them.

  7. Analysts can now implement immediate changes to input variables and produce accurate current and past data outputs of an assortment of formats

  8. Able to manage the inventory and avoid non required purchases.