1. Project Title & Company Review
Anchor-Hold Retail Group: Driving Business Transformation Through Sales Data Intelligence.
INDUSTRY: Consumer Goods Industry.
Anchor-Hold Retail Group is a multinational consumer goods company operating across diverse markets including North America, Europe, and Asia. With a broad product portfolio and customer base spanning
government, enterprise, midmarket, and small business segments, the company has experienced rapid expansion over the past two years. However, inconsistent data practices and fragmented reporting structures
have hindered its ability to make informed sales decisions. As competition intensified and growth plateaued, Anchor-Hold initiated a data-driven transformation project aimed at improving sales performance, streamlining
operations, and aligning its strategy with actionable insights drawn from its existing but flawed sales data.
ROLE: Data Analyst.
2. Business Problem
The FMCG Company was facing key challenges should as:
- Inconsistent, unstructured, and poorly maintained data.
- Unrealiable reporting.
- Limited visibility into salesperson performance.
- Inefficiencies in Data Decision-making
3. Business Objectives
- Improved Decision-Making Accuracy: Clean and analyze messy sales data by allowing the business to make data-backed decision, reducing reliance on assumptions and outdated reports.
- Enhanced Sales Strategy Alignment: By uncovering performance trends across regions, products, and sales teams, Anchor-Hold can realign resources and efforts to where they generate the highest return.
4. My Approach
- Data Collection and Cleaning.
- Exploratory Data Analysis (EDA).
- Insight Generation.
- Visualization/Dashboard Building.
- Recommendations: Actionable strategies.
TOOL USED: MS Excel.
5. Key Deliverables
Delivered a MS Excel dasboard to improve data driven decision-making.
6. Insights
- Target Youth Salespeople: Youth salespeople generate the highest revenue (2.2B).
- Expand Market Presence in Mexico: Mexico contributes the least revenue (1.02B) compared to Canada (2.04B) and the USA (1.84B).
- Boost Sales in Low-Performing Months: Revenue dips significantly in March (300M) compared to October the peak (1.4B).
- Increase Engagement with Government and Small Business Segments: These customer bases drive the majority of revenue (44% and 36%, respectively).
7. Recommendations
- Focus on scaling their impact by launching leadership develoment workshops tailored for youth salespeople. this aligns with the long-term goal of fstering leadership while capitalizing on is proven sales strength.
- Investigate market demand and consider scaling operations to its region, possibly by introducing shared tools like CRM systems to streamline sales efforts, as discussed in your mid-term plans.
- Implement targeted promotions or campaigns during low months, leveraging performance insights from bi-weekly team check-ins to identify and address seasonal challenges.
- Strengthen relationships by offering tailored products or incentives, and use feedback frm performance reviews to refine strategiies for the key segments.