<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Rita German</title>
    <description>The latest articles on DEV Community by Rita German (@ritagerman).</description>
    <link>https://dev.to/ritagerman</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4246611%2F79f7b813-cf2e-4903-8f38-7f430aa3db4b.jpeg</url>
      <title>DEV Community: Rita German</title>
      <link>https://dev.to/ritagerman</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/ritagerman"/>
    <language>en</language>
    <item>
      <title>From Data to Distribution: How I Used Google Maps, QGIS and Power BI to Support a Nationwide FMCG Expansion Project</title>
      <dc:creator>Rita German</dc:creator>
      <pubDate>Mon, 16 Nov 2026 11:45:19 +0000</pubDate>
      <link>https://dev.to/ritagerman/from-data-to-distribution-how-i-used-google-maps-qgis-and-power-bi-to-support-a-nationwide-fmcg-4nan</link>
      <guid>https://dev.to/ritagerman/from-data-to-distribution-how-i-used-google-maps-qgis-and-power-bi-to-support-a-nationwide-fmcg-4nan</guid>
      <description>&lt;p&gt;Introduction&lt;/p&gt;

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

</description>
      <category>analytics</category>
      <category>data</category>
      <category>management</category>
    </item>
  </channel>
</rss>
