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.