Data Analytics for Kenyan Businesses — The Opportunity

Why Data Analytics Matters Now

Every M-Pesa transaction, every POS sale, every QuickBooks entry creates data. Most Kenyan SMEs sit on months or years of data they've never analysed. A restaurant with 18 months of sales data doesn't know which menu items make money and which lose it. A retail shop can't tell you their busiest hour or their best-selling product.

You don't need a data science degree to help them. You need the ability to open their spreadsheet, clean the data, build a few charts, and say: 'Your Thursday lunch specials bring in 40% more revenue than regular days. Here's why, and here's what you should do about it.'

Services That Sell

• •Monthly business reports from POS/M-Pesa data — KSh 3,000–8,000/month
• •Sales analysis dashboard — KSh 10,000–20,000 one-time setup
• •Financial performance review — KSh 5,000–15,000 per report
• •Customer segmentation analysis — KSh 10,000–25,000
• •Inventory optimisation (what to stock, what to drop) — KSh 8,000–20,000
• •Ad campaign performance analysis — KSh 3,000–10,000 per analysis

Tools You Need

Start with what businesses already use:

Google Sheets: free, collaborative, handles most SME data. Learn pivot tables, VLOOKUP/INDEX-MATCH, conditional formatting, and charts.

Microsoft Excel: still the standard in corporate Kenya. Same skills apply, with added Power Query for data cleanup.

Google Looker Studio (formerly Data Studio): free dashboarding tool. Connects to Sheets, CSV files, and databases. Produces professional, shareable reports.

Python (optional upgrade): for large datasets that crash Excel, or tasks like scraping, cleaning thousands of rows, and statistical analysis. Pandas library + Google Colab (free) is enough to start.