Machine Learning and Intelligent Systems

Advanced Analysis & Visualization in Excel

Posted on


Goal is Simple: Learn to create one pager executive dashboards in MS Excel that update with the click of the Refresh button, or with a simple copy-paste of your new data.

This course is suitable for you if you answer YES to:-

  • Do you want to spend less time creating reports and more time analyzing and gaining insights from the reports?
  • Do your reports take a long time to update each reporting cycle?
  • Do you want to gain skills to avail credible dashboards that allow the management to understand what is going on and make better decisions, quickly?

Read more HERE


Smart Farms-Remote Farm Monitoring system

Posted on Updated on


Every farmer understands the importance of monitoring the crops and/or animals in the farm. It is important to monitor crop growth, field environment, and farming operations in order to increase the agricultural productivity and to promote efficient management. With the growing green revolution in progress the world of agriculture and smart farms are taking a leading role in ensuring efficient, innovative, dynamic and eco-friendly farms. Farmers are now looking for smart ways to monitor and manage their crops remotely.

Farmers over the years have experienced problems related to water usage and supply, energy supply and the demerit of distance of accessing these resources. The importance of monitoring the water usage in farms is increasing with farmers seeking technology that will help them improve their agricultural productivity.

@iLabAfrica Research Centre based in Strathmore University in collaboration with IBM Kenya, and Oregon State University together with Trans-African Hydro-Meteorological Observatory (TAHMO) intend to come together to develop an intelligent farm Management system that leverages Internet of Things(IoT) architecture through remote sensing and low power wide area networks as well data analytics. The overall concept of the system is to be able to build deeper analytics that can provide more information in a predictive model to help farmers understand their farms in terms of soil composition and changes, water usage and evaporation rates as well as the changing weather parameters that can visually present an insightful trend on the changing climate. This project collaboratively explores a way of remote monitoring that could guarantee farmers an easy way to understand various parameters such as temperature, humidity, soil moisture and water levels in various tanks on their farms among other parameters. This is expected to provide a smarter approach to farming, referred to as Precision Farming.

The data collected in the Internet of Things (IoT) stack in this project so far includes temperature, humidity, water level (rate of water evaporation also monitored through the use of evaporimeters –provided by Oregon State University), battery level and  the signal strength of the data transmitting devices.

To reliably provide this solution, the project is expected to use GSM/GPRS and Long Range (LoRa) connectivity to achieve the desired Machine-to-Machine data exchange between the farms and the cloud since the farming areas envisioned in these concept are located in rural areas. These areas experience poor signal strength even on the cellular network. Hence, the need to also gather data on the signal strength of the network.

Currently, two IoT devices of this kind have been deployed to a test farm in Kitengela, south of Nairobi. The devices are currently powered by mini solar-panels and continually transmit data at an interval of 15 minutes. These devices make of the GSM/GPRS technology as at now. The project as is, has proven to be working and data can be relayed from the farm to both a web and a mobile interface through IBM’s Cloudant database. The information gathered provides real-time information on the parameters described to the farmer.

The next step of development will be to  deploy the solution in more farms and build a low cost, low maintenance weather station that can be used by farmers and also provide an irrigation service that can intelligently be measured and remotely actuated. Alternative Low Power Wide Area Network (LPWAN) communication technology, in this case, LoRa will also be implemented to provide a more stable and reliable service of transmitting these data.

@iLabAfrica IoT Manager and project lead Mr. Leonard Mabele mentioned that “with more funding, we can reach out to more farmers in remote areas and acquire more devices for deployment, mass testing and implementation. This will also allow us to reach out to IoT security experts to enable us to not only develop a working solution but a securely tested one as well. This projects will see us uplift the process and yields of farmers and in return build their communities.

For more information about this click HERE

Launch of Kiambu Cashless revenue collection System

Posted on Updated on


Kiambu county has launched a cashless payment system to improve its revenue collection. The payment system designed by @iLabAfrica Research Centre in Strathmore University through its other arm- Strathmore Research and consultancy center (SRCC) is designed to ensure that revenue collection in the county is a citizen centric automated system contributing to enhanced income streams and provision of services.

The Launch took place on the 2nd of March 2017 and was attended by the Kiambu Governor, Hon. Ferdinand Waititu his Deputy James Nyoro, @iLabAfrica Director Dr. Joseph Sevilla and county executives (CEC’s), and major stakeholders.

Speaking during the launch Governor Waititu said that the county collects up to Sh46 million a week and projects collections are expected to shoot up with the cashless system. “The revenue collected goes directly to our account. This eliminates middlemen who are an extra cost to the County and ensures accountability of the citizens’ revenue”; he said.  The governor further noted that they had launched a USSD code that will help Kiambu locals to pay for various services offered in the county.

“We have launched our USSD code *419# through Safaricom Kenya Limited which will assist Kiambu residents to pay for some services like parking, market fee, single business permits renewal among others”; Waititu said. “The USSD code is faster and people can pay their taxes wherever they are without going to county offices,” he said.

The county has partnered with Cooperative Bank to collect the revenue and residents will get a payment confirmation. With the launch, the governor noted that this implementation was a way that his administration would enhance revenue collection.
“These are some of the steps my county has undertaken to enhance revenue collection. Improved revenue collection will translate to more development projects for Kiambu citizens. This money is meant for development. We have reviewed all licenses and fees and have lowered them to help Kiambu residents conduct their business without high charges,” Waititu said.
Other counties where @iLabAfrica Research Centre has implemented revenue collection
systems are; Taita Taveta County, Busia County, Mombasa County and Kilifi County.

This step of implementing revenue collection systems is a move by the commission on Revenue Allocation, the ICT Authority of Kenya and implementers of financial management and policies in all 47 counties.
For more information about the system visit