Homeโ€บProgramsโ€บData Analyst & AI Agent Builder
โญ Flagship ProgramNow Enrolling

Data Analyst & AI Agent Builder

Solve real industry problems across insurance, banking, telecom, and supply chain. Use modern AI tools throughout. Graduate having built a working analytics agent pipeline from scratch.

๐Ÿ“… 4 Months๐Ÿ™๏ธ Hybrid: Online + Classroom๐Ÿ† 5 Projects (4 Industry + Capstone Agent App)๐Ÿ”“ 1 Year Access

Next Cohort

August 2026

Seats

Limited

Fee

KES 70,000

High Demand CareerUsed Across All IndustriesStrong Salary Growth

Growing

Global demand

All sectors

Finance, Telecom, Health

Top 10

Most in-demand roles

Market Opportunity

Data Analysts Are in High Demand โ€” And the Role Is Evolving Fast

Organizations across industries rely on data to make decisions, creating strong and growing demand for skilled analysts. But something bigger is happening: the analysts who thrive are not the ones who fear agents โ€” they are the ones who know how to build them.

๐Ÿ“Š

87% Feel More Strategically Valuable

According to Alteryx's 2025 State of the Data Analyst report, 87% of analysts feel more strategically valuable than ever โ€” because those who design and validate AI-assisted workflows are becoming the most valuable people in any data team.

๐Ÿค–

The Agent Era Has Begun

Satya Nadella declared the end of the chatbot era and the beginning of the agent era. Jensen Huang called agentic systems "as big a deal as the internet." Data analysis is at the center of that shift.

๐ŸŒ

Every Industry Hiring

Finance, telecom, healthcare, logistics, and retail companies are all hiring analysts to interpret growing volumes of business data โ€” and increasingly to build the AI systems that help do it.

Sources: Alteryx 2025 State of the Data Analyst ยท Microsoft Build 2025 ยท NVIDIA GTC 2025

Career Outcomes

What You Will Become

Graduate ready to work as a data analyst across multiple industries, understanding how data drives real business decisions.

๐Ÿ›ก๏ธ

Insurance

Insurance Data Analyst

Analyzing claims patterns, loss ratios, and policy performance.

๐Ÿฆ

Banking & Finance

Banking / Finance Analyst

Evaluating loan risk, customer behavior, and financial performance.

๐Ÿ“ˆ

Stocks & Capital Markets

Capital Markets Analyst

Analyzing market trends, portfolio performance, and investment data to support trading and financial decisions.

๐Ÿ“ก

Telecom

Telecom Data Analyst

Identifying churn patterns, customer segments, and service issues.

๐Ÿšš

Supply Chain

Supply Chain Analyst

Optimizing inventory, demand forecasting, and logistics performance.

Along the way, you will learn how to

Break down complex business problems using a structured analytical framework.

Use Excel, SQL, and Python to clean, transform, and analyze real operational data.

Use AI tools to accelerate work while maintaining control over analytical thinking and validation.

Build AI agents that convert business questions into SQL queries and Python programs, run analysis, and generate reports โ€” with you reviewing and validating every step.

Communicate insights and recommendations clearly to managers, executives, and interview panels.

Apply for Next Cohort

Next cohort: August 2026 ยท Limited seats available

Curriculum Overview

Four Months. Four Industries. Five Projects.

Each month builds on the last โ€” from foundational analytics to AI-assisted workflows to building your own agent pipeline โ€” with a portfolio project at the end of every month.

Month by month walkthrough โ€” what you will learn, the tools you will use, and how the program builds progressively

< 2 min ยท Coming soon

Learn how insurance companies analyze claims, policies, and customer payments. The first half covers Excel and SQL; the second half replaces those tools with Python โ€” so you learn the same operations across three environments and arrive at Month 2 with Python already familiar.

Key Topics

  • Analytical thinking framework โ€” breaking down business problems before touching data
  • Data cleaning and data quality
  • Excel: pivot tables, aggregations, dashboards
  • SQL fundamentals โ€” SELECT, GROUP BY, JOINs, aggregate functions
  • Python & Pandas โ€” replicating all Month 1 operations in code
  • Business metrics: loss ratio and claims patterns
  • AI tools: ChatGPT and DeepSeek for learning support

Portfolio Project

Insurance performance dashboard analyzing policy payments and claims trends.

5

4 industry projects + capstone agent app

Excel ยท SQL ยท Python

Core analytics stack

AI Tool Ladder

ChatGPT โ†’ Ollama โ†’ Claude Terminal

Job-Ready

Portfolio + interview prep

Want the full week-by-week breakdown?

Download the complete curriculum guide with detailed topics and project descriptions.

Apply Now

Portfolio Projects

Projects You Will Build

Certificates don't impress hiring managers. Projects do. Throughout the program you will build five real projects โ€” four across real industries plus a working AI agent application โ€” that demonstrate how data is used to solve business problems.

Walkthrough of the 5 projects โ€” see a finished project and what it looks like to an employer

< 2 min ยท Coming soon

01Insurance

Insurance Performance Dashboard

  • Clean and prepare policy and claims datasets
  • Calculate key metrics: loss ratio and claim frequency
  • Identify high-risk segments using descriptive analytics
  • Build an insurance performance dashboard

Outcome

A business-ready report showing policy performance and claims insights.

02Banking & Stocks

Credit Risk & Market Analysis

  • Apply descriptive statistics and distribution analysis to financial data
  • Use correlation and statistical inference to identify real drivers of loan default
  • Build a statistically-backed credit risk scorecard
  • Analyze stock returns, volatility, and portfolio correlation

Outcome

A dual-view analytics report with statistical evidence behind every finding โ€” credit risk scorecard and market performance summary.

03Telecom

Customer Churn Analysis & Prediction

  • Engineer features from raw data โ€” calls per day, usage trends, support ticket frequency
  • Use K-means clustering to segment customers by behaviour
  • Build a logistic regression model to predict churn probability
  • Build a Power BI dashboard showing churn risk by segment and predicted scores

Outcome

A Power BI churn dashboard with ML-based customer segments, churn predictions, and actionable retention recommendations.

04Supply Chain

Demand Forecasting & Risk Analysis

  • Decompose a demand time series into trend, seasonality, and residual components
  • Build demand forecasts using ARIMA and Prophet, then compare results
  • Apply a decision tree to classify supply chain risk and derive human-readable rules
  • Build an executive Power BI dashboard with forecasts and risk rules

Outcome

A supply chain analytics report with ARIMA and Prophet demand forecasts, decision tree risk rules, and a Power BI executive dashboard.

05Capstone

Build a Data Analytics Agent

This is the project that sets your portfolio apart โ€” a working multi-agent analytics application of the kind real data teams are starting to deploy today.

  • Build an SQL agent that converts a plain-English question into a database query
  • Build an analyst agent that reads results and identifies key patterns and insights
  • Build a report agent that produces a clean, business-ready summary
  • Connect agents into a full pipeline with human-in-the-loop review at each step
  • Build a Streamlit front-end where users type their question and see the final report
  • Wire the pipeline together using FastAPI as the back-end
  • Run the entire system locally using Ollama and Qwen โ€” zero API costs, full data privacy

Outcome

A fully working, deployable analytics agent application โ€” powered by local AI, built with Python, FastAPI, and Streamlit, built by you.

Your Portfolio at Graduation

4 industry analytics projects1 working AI agent applicationPower BI dashboards & professional reportsInterview-ready portfolio
Apply for Next Cohort

Is This For You?

Who This Program Is For

This program is designed for people who want to learn how data is used to solve real business problems across industries.

๐ŸŽ“

Students & Recent Graduates

Who want to start a career in data analytics but lack practical industry exposure.

๐Ÿ’ผ

Working Professionals

In finance, operations, customer service, or business who want to transition into data-driven roles.

โš™๏ธ

Technical Professionals

Engineers or IT professionals who want to understand how data supports real business decisions.

๐Ÿ”„

Career Switchers

Who want to move into technology and analytics with a structured, project-based learning path.

No Prior Experience Required

The program starts with foundational concepts and builds gradually toward real industry analysis. What matters most is curiosity, consistency, and the willingness to solve real problems with data.

Our Differentiators

What Makes This Program Different

Most data courses focus on tools. This program focuses on how real businesses use data to make decisions.

Industry-Based Learning

You apply analytics to Insurance, Banking, Telecom, and Supply Chain โ€” understanding how different sectors use data to make operational and strategic decisions.

Problem-Solving First

You learn a structured analytical framework to break down complex business problems before writing any query or code โ€” building the judgment real analysts need.

A Full AI Tool Ladder

You learn the full landscape progressively โ€” ChatGPT, DeepSeek, Ollama + Qwen (local, private, free), Gemini CLI, and Claude Terminal. Agents you build run locally with zero API costs โ€” how real enterprise analytics teams handle sensitive data.

Build AI Agents, Not Just Use Them

In the final month you build a working multi-agent analytics system โ€” an SQL agent, an analyst agent, and a report agent connected into a full pipeline with human-in-the-loop review. Built with Python, FastAPI, and Streamlit.

Project-Based Portfolio

Every month ends with a real industry project. By graduation, you have five portfolio pieces โ€” four industry projects plus a working agent application โ€” ready to show in interviews.

Career Preparation Built In

Interview prep, voice mock interviews, peer practice sessions, and an ATS resume builder โ€” integrated into the program, not tacked on at the end.

Hybrid Learning Model

Weekday online sessions for flexibility. Weekend classroom sessions in Nairobi for hands-on collaboration and the professional network that opens doors.

Tools & Technologies

The Tools You Will Learn

Tools are introduced progressively within the context of real business problems โ€” not in isolation. Tools change. Analytical thinking does not.

๐Ÿ“Š

Data Analysis & Visualization

  • Microsoft Excel
  • Python
  • Pandas
  • Matplotlib & Seaborn
  • Plotly
  • Power BI
๐Ÿ”ฌ

Statistics & Machine Learning

  • Scipy โ€” hypothesis testing, t-tests, chi-square
  • Statsmodels โ€” confidence intervals, ARIMA
  • Scikit-learn โ€” clustering, regression, decision trees
  • Prophet โ€” demand forecasting
๐Ÿ—„๏ธ

Data Querying & Databases

  • SQL
  • Relational Data Models
  • Subqueries, CTEs, Window Functions
  • Data Aggregation & Grouping
๐Ÿค–

AI Tools โ€” From Free to Professional

  • ChatGPT โ€” learning support from day one
  • DeepSeek โ€” code generation & analysis
  • Ollama + Qwen2.5-Coder โ€” local, private, free
  • Gemini CLI โ€” agentic multi-step workflows
  • Claude Terminal โ€” coding assistant for agent dev
โš™๏ธ

Agent Development

  • FastAPI โ€” back-end orchestration
  • Streamlit โ€” front-end interface
  • Ollama โ€” local model runtime (zero API cost)
  • Qwen2.5-Coder โ€” SQL generation, analysis, reporting
๐Ÿ“‹

Reporting & Communication

  • Analytical dashboards
  • Executive summaries
  • Data storytelling
  • Visual presentations

How It Works

Learning That Fits Your Life

A hybrid model designed for working professionals โ€” combining structured online learning with hands-on weekend classroom sessions and AI mentor support.

The hybrid format โ€” weekday online sessions, weekend classroom labs, AI mentor, and what a typical week looks like

< 2 min ยท Coming soon

๐Ÿ’ป

Weekday Online Sessions

Live sessions with experienced instructors. Learn analytical concepts, walk through real problems, and see live tool demonstrations. All sessions are recorded.

๐Ÿซ

Weekend Project Labs

In-person classroom sessions in Nairobi. Work on industry datasets, build dashboards, collaborate with peers, and receive direct instructor guidance.

๐Ÿค–

AI Mentor โ€” 24/7

Ask up to 20 questions per day. Explain concepts, debug code, understand datasets, and review approaches โ€” instant help whenever you need it.

๐Ÿ“ˆ

Progress Tracking

Intelligent learning agents monitor your progress, track assignment completion, identify learning gaps, and recommend topics to review.

๐ŸŽฏ

Interview Preparation

AI-generated questions, voice mock interviews, peer-to-peer practice, and an ATS-optimized resume builder โ€” available from the later program stages.

๐Ÿ“š

Learning Platform

Recorded lectures, lab exercises, project datasets, and all tools available in one dedicated platform โ€” accessible throughout and beyond the program.

Your Instructor

Built by Someone Who Has Done the Work

Instructor Photo

Sai introduces himself โ€” his background, why he built this program, and what he wants you to achieve

< 2 min ยท Coming soon

Saikumar Allaka

Head of AI at Okhi ยท Former Data Science Manager at Equity Bank & Safaricom

Saikumar is a data analytics and AI professional with extensive experience building data-driven systems and products. He has led analytics and AI initiatives across finance, telecommunications, and technology โ€” working with real operational data and the business problems organizations face daily.

Equity BankSafaricomOkhi

This curriculum emphasizes

Structured analytical thinking
How businesses use data
Real industry datasets
Modern AI-assisted workflows

FAQ

Frequently Asked Questions

AgenticSchool
Certificate of Completion

This certifies that

Your Name Here

has successfully completed

Data Analyst & AI Agent Builder

Data AnalysisStatistics & MLAI ToolsAgentic SystemsPower BI4 Industry Domains

Saikumar Allaka

Instructor & Founder, Ramayai AI Academy

ID: AS-2026-XXXX

Your Certificate

A certificate that shows exactly what you can do.

Your certificate lists every skill area you were assessed on โ€” so employers know precisely what you built and proved, not just that you attended a program.

Data Analysis

SQLPython & PandasMicrosoft ExcelPower BIData Cleaning & Transformation

Statistics & Machine Learning

Descriptive StatisticsHypothesis Testing & InferenceClustering (K-means, Hierarchical)Regression (Logistic & Linear)Decision TreesTime Series (ARIMA & Prophet)

AI Tools

ChatGPT & DeepSeekOllama + Qwen2.5-Coder (local AI)Gemini CLIClaude Terminal

Agentic System Development

Multi-agent pipeline designSQL AgentAnalyst AgentReport AgentFastAPI (back-end)Streamlit (front-end)Human-in-the-loop workflows

Industry Experience

Insurance AnalyticsBanking & Stocks AnalyticsTelecom AnalyticsSupply Chain Analytics

Certificate is issued upon successful completion of all four industry projects, the capstone agent application, and program assessments. Each certificate carries a unique credential ID verifiable by employers.

Next Cohort: August 2026

Ready to Start Your
Data Analytics Career?

Join the next cohort and start building real-world analytics skills across four industries โ€” with AI tools, expert mentorship, and a portfolio that gets interviews.

4 months ยท 5 projectsKES 70,000Limited cohort seats