Introduction
- Expanding a distribution network across multiple locations is not simply a matter of deploying vehicles and assigning sales representatives. It requires accurate outlet information, effective territory planning, visibility into field activities and the ability to make decisions using reliable data.
- During my work supporting the Neighbourhood Channel expansion project at GBfoods, I was involved in applying data analytics and geospatial tools to support the deployment and management of a nationwide distribution initiative involving 200 vans across Nigeria.
- One of the major challenges was ensuring that the expansion was supported by reliable outlet mapping, structured journey planning and consistent performance monitoring.
- I approached this challenge by combining Google Maps, QGIS, Microsoft Excel and Power BI to create a more data-driven approach to distribution planning and project monitoring.
- The Challenge: Managing Expansion Across Multiple Locations
- A nationwide distribution expansion presents several operational challenges.
- Some of the key questions we needed to address included:
- * Where were the potential outlets located?
- * How could outlets be mapped to support effective field coverage?
- * How could routes and sales journeys be organised?
- * How could management monitor deployment progress?
- * How could project performance be tracked consistently across locations?
- Without structured location data and reporting processes, managing these activities would become increasingly difficult as the network expanded.
- The challenge was therefore not just to support vehicle deployment, but to establish a data-driven process that could improve visibility, coordination and decision-making.
- My Approach: Combining Four Digital Tools
- I used four complementary tools to support different aspects of the project.
- 1. Google Maps: Developing Outlet Location Intelligence
- I personally developed the outlet mapping using Google Maps.
- The objective was to translate outlet location information into a practical geographical view that could support distribution planning and field execution.
- By organising outlet locations geographically, I helped create visibility into where business opportunities existed and how the distribution network could be structured around them.
- This provided a practical foundation for territory planning and subsequent journey development.
- 2. QGIS: Supporting Geospatial Analysis and Journey Planning
- Mapping locations was only the first step. The information also needed to support practical field operations.
- I used QGIS to develop journey plans using the outlet mapping data.
- This introduced a more structured geographical approach to planning distribution journeys. Rather than relying solely on manually reviewing outlet addresses, I could work with their spatial relationships to support better journey organisation.
- The use of QGIS demonstrated how geospatial technology could be applied to a commercial distribution challenge, connecting location intelligence with operational planning.
- 3. Excel and Power BI: Building Performance Visibility
- A major part of the project involved ensuring that management could monitor progress and understand what was happening across the expansion programme.
- I developed dashboards using Microsoft Excel and Power BI to support project performance monitoring.
- These dashboards provided a structured way to present project information and make performance easier to review.
- I also developed daily reporting processes using Excel to support consistent tracking of project activities.
- This helped move reporting away from fragmented updates towards a more organised approach to project monitoring.
- 4. Project Reporting and Stakeholder Coordination
- Beyond the technical work, I was responsible for handling and presenting weekly project management meetings.
- I presented updates on the Neighbourhood Channel expansion, communicated project progress and supported discussions around implementation.
- This was an important part of the process because technology is most useful when its outputs are translated into information that decision-makers can understand and act upon.
- My role therefore combined data analysis, geospatial planning, dashboard development and project communication.
- The Results: Connecting Data with Business Growth
- The project delivered significant business outcomes.
- The Neighbourhood Channel achieved 100% growth within one year.
- The nationwide deployment programme involved 200 vans, supported by structured outlet mapping, journey planning and performance reporting.
- My contribution helped establish the data and reporting processes used to support the expansion and improve management visibility.
- Some of the most important lessons from the project were:
- * Location intelligence can make distribution planning more structured and actionable.
- * Geospatial tools such as QGIS have practical applications beyond traditional mapping.
- * Business intelligence dashboards can improve visibility into complex operational projects.
- * Consistent reporting helps management monitor implementation and make informed decisions.
- * Technical capability becomes more valuable when combined with an understanding of real business problems.
- Beyond Dashboards: The Role of Data in Digital Transformation
- One of my biggest takeaways from this experience is that digital transformation does not always require developing an entirely new software product.
- Sometimes, it involves identifying an existing operational challenge and combining accessible technologies in a way that improves how an organisation works.
- In this project, Google Maps, QGIS, Excel and Power BI served different purposes but contributed to a connected approach to location intelligence, planning and performance monitoring.
- The experience reinforced my interest in using technology to solve complex business problems, particularly in distribution, supply chain operations and commercial analytics.
- Conclusion
- The Neighbourhood Channel expansion project strengthened my belief in the role of data analytics and geospatial technology in improving business operations.
- It also demonstrated the importance of connecting technical solutions with implementation, stakeholder engagement and measurable business outcomes.
- As organisations continue to expand their distribution networks and operate across increasingly complex markets, I believe there is significant opportunity to apply business intelligence, geospatial analytics and automation to improve operational efficiency.
- My continued focus is on developing practical data-driven solutions that help organisations turn information into better decisions and measurable impact.

