Posts Tagged ‘Data/Map Tour


Data/Map Tour: Part One Recap

My database installation tour has gotten off to a great start and I have now completed my work in four of Burkina’s thirteen regions (Boucle du Mouhoun, Nord, Centre Nord, and the Sahel*). So, what’s involved in each visit?

First, I go over with the agents the advantages of the new system. Tracking payments has been simplified, and now we’re adding individual visits to our data collection. Once the agent is comfortable with the two data entry portions, I show them the power of having all of that data in one place, as I have simplified all of their reporting to just one-click.

Additionally, they can use the software to create custom characteristic reports – a few examples:

  • Before  traveling to a certain province, we can identify which borrowers are located there, and of those, who is behinds on their payments or has had too much time pass since we’ve last met with them.
  • If a borrower comes in for a meeting and says their business is struggling, we can quickly identify other successful borrowers who live in the same area and have the same type of business. We encourage our borrowers to create an informal network where they can go to each other for help.
  • Before deciding on next year’s loan portfolio, we can easily see if we’ve already over-financed a certain industry in a certain area. Allowing us to avoid over-saturating markets.

After showing off the system, then comes the real work. In order for all of those reports to be useful, we must be sure to have every borrower’s updated information. That means verifying everything from their phone numbers to the date of their first scheduled payment. It typically takes a little over two (long) days to get the data ready and then we spend a day and a half on practicing with the software. Then it’s off to the next region either by public transport or by private car.

There have been amazingly few hiccups so far, though I have had to deal with:

  • Missing the one and only bus to Dédougou (hitched a ride with another government trip that was headed out there).
  • One region had multiple borrowers with not only the same exact name, but also lived in the same city and had the same type of business.
  • Not being able to track down hard copies of payment receipts for one region.
  • Surprise holidays (March 8th was international women’s day – my colleague and I worked a half-day).
  • Living in the house of a PCV who left in December (no one had been in the house for almost three months – you can guess how clean it was).

Post training photo with FAIJ/Sahel representative and FAIJ/Centre Nord secretary.

Most interesting for me however, has been meeting and working with all of the other agents posted in each region. I’ve received great reactions from everyone, and all have been quick to pick up on the use of and importance of the software.

I’ve also had the chance to see many PCVs along the way and have spent about half of the time thus far being hosted in their houses. It’s a bit disorienting to wake up in a new place every few days, but it has been a great way to see more of the country.

And while the GPS/mapping portion of the project have been reduced, I have trained a small team in Ouaga to map the 1,100+ borrowers in the capital. I’m hopeful that the team can visit all of them by May (the time my tour is finished).

Up next – the Centre Ouest and Centre Sud. Then a four day break in Ouaga to report back on my progress and have a little downtime.


*Due to the ongoing Tuareg conflict and previous AQIM activity, I wasn’t able to travel to the Sahel, and instead had the agent meet me in the Centre Nord.


Data/Map Tour: Ramp Up to Kickoff

Remember when back in Oct/Nov I said I was just about to start a multi-month tour installing and training local agents on the software I created? Well, I’ve learned that here in Burkina things don’t always move quite as planned. The good news though is that the project is officially back on and I’m starting my travels in less than two weeks. This version is a bit shorter (more budget-friendly) three month project. Check out the map below for an idea of my future (somewhat crazy) travel schedule:

I spent the last few weeks at FAIJ HQ gathering all of its historical data and discussing new software features. The next few days will be  scrambling to get all of the new data in order, adding new reporting features and making sure that everything is in solid working order – not to mention wrapping up my life to not be home for quite some time.


Data/Map Tour: An Overview

As I mentioned last week, my colleague and I about to embark on a six month tour in order to train regional agents on using/updating a new database and integrating it with GPS mapping 2,500+ borrowers. Not only did FAIJ enthusiastically agree to my proposal, they are also going the extra mile and providing additional GPS units and cameras for each region, and even a car and driver for the duration of the project. Read on for more project details.

Project Summary

The implementation of a FAIJ database in all Burkina Faso regions will require a multi-month tour to visit each region and give hands on training. Once up and running, the database will function as a method to:

  1. Track payments
  2. Create automated reports
  3. Track meetings with borrowers
  4. Make data/statistics more accessible to both FAIJ and borrowers

The MS Access database will be installed in each regional FAIJ office, where the agent will be trained to use it as well as make future updates. Additionally, the data in the database will be linked to an interactive Google map with each borrower identified by a point on the map with their GPS coordinates. A click on that point brings up a borrower’s photo and relevant loan/payment information, and the color of each point will change in regard to the timing of our last meeting with that borrower and their repayment status.

The reports and map will serve as the basis to create a FAIJ borrower network where we will encourage borrowers to collaborate by using each other in their supply chains, sharing transport, etc.



  1. Saves time for agents and headquarters, especially important as program expands
  2. Automated reports are accurate and uniform
  3. Creates agent accountability – headquarters has a more real-time view into payments and meetings with borrowers
  4. Sets priorities – easy to see priority borrowers locally and nationally
  5. Easier to access data
  6. Creates/maintains institutional knowledge
  1. Provided more frequent and better targeted follow-up
  2. Allows for collaboration with other FAIJ borrowers
  1. Easier to group borrowers for trainings based on business needs
  2. Opens up the FAIJ network for collaboration with additional partners

Pre-Tour Planning

We’ll be spending a couple of days at the FAIJ headquarters in Ouaga with the Monitoring & Evaluation and IT groups to determine which data to track, establish collection rules, and to communicate to all regional agents about the upcoming work. We will also create training manuals for database/GPS/camera usage.

Tour Activities

During our visits to each region, we will be:

  1. Creating a region-specific version of each database
  2. Normalizing data
  3. Training regional agents on the database, GPS device and camera
  4. Taking locations/photos of all borrowers
  5. Data entry

Post-Tour Follow-up

After finishing the tour, we will create a headquarters version of the database with enhanced reporting functions. In addition, we will offer additional training and evaluate usage behaviors. An all-agent meeting will be held to review the on-the-ground use of the database and map in each region.


Data/Map Project Going Nationwide

Big news – remember the database and interactive Google map I made for the borrowers in the eastern region (plus the subsequent presentation I made to my organization to urge them to take the project nationwide)? Well, a couple of months and many meetings later, the project has received the official green light from all parties.

In order to map all borrowers my colleague and I will go on five mini-tours, visiting two or three regions at a time and coming back to our home-base in the East between each segment. This will allow us to concurrently serve our existing eastern clients and allow us a break every now and then.

Each mini-tour will require quite a lot of work, and will include everything from computer training to GPS device use (and of course meeting over 1,500 borrowers). We’re aiming to get started in just a few days and finish up in April 2012.

The tour itself will take approximately six months, but the resulting monitoring and evaluation, troubleshooting and feature additions likely means that this project will take up the majority of the rest of my service. I’ll be posting many more details as our plans become finalized.


RSSEmail LinkedIn LinkedIn

Burkina Faso


RSS Other PC Burkina Blog Posts

  • An error has occurred; the feed is probably down. Try again later.


Time in Burkina


The opinions on this blog are only those of the author, and and do not reflect any position of the U.S. Government or the Peace Corps.