All programmes
    Career Track

    Data Analysis with Python (AI-Powered)

    Python, Pandas & NumPy, SQL and Power BI/Excel, accelerated with AI tools, plus a business dataset project.

    2 Months Professional

    Programme overview

    Combines Data Analysis with Python with its AI-Powered track. Covers Python fundamentals, Pandas & NumPy, data wrangling, SQL for data analysis and Power BI/Excel integration, culminating in a business dataset project, with AI tools accelerating analysis throughout.

    What you will learn

    6 modules. Every module is hands-on, with practical work in class. Tap a module to see its topics.

    1. 01

      Module 01

      Python Fundamentals

      The programming basics every data analyst needs.

      By the end of this module, you will be able to write Python scripts to work with data.

      • Core Python: Variables, data types, loops and functions.
      • Working with files: Reading CSV and Excel files.
      • Notebooks: Analysing data step by step in Jupyter.
    2. 02

      Module 02

      Pandas & NumPy

      The main Python tools for handling data.

      By the end of this module, you will be able to load, explore and summarise datasets with Pandas.

      • NumPy: Fast calculations on arrays of numbers.
      • Pandas DataFrames: Selecting, filtering and sorting data.
      • Grouping and summarising: Totals, averages and pivot tables.
    3. 03

      Module 03

      Data Wrangling

      Getting messy real-world data ready for analysis.

      By the end of this module, you will be able to clean and reshape messy data so it can be analysed.

      • Cleaning data: Missing values, duplicates and wrong formats.
      • Combining data: Merging and joining datasets.
      • Reshaping: Changing data layout for analysis.
    4. 04

      Module 04

      SQL for Data Analysis

      Pulling data straight from databases.

      By the end of this module, you will be able to query databases to get the data you need.

      • SQL basics: SELECT, WHERE, ORDER BY.
      • Joins and aggregation: Combining tables and summarising results.
      • SQL with Python: Running queries from your analysis code.
    5. 05

      Module 05

      Power BI & Excel Reporting

      Presenting findings so decision-makers can use them.

      By the end of this module, you will be able to build clear charts, reports and dashboards.

      • Charts: Choosing the right chart for the message.
      • Power BI dashboards: Interactive reports from your data.
      • Excel integration: Sharing results in the format offices use.
    6. 06

      Module 06

      AI-Accelerated Analysis & Business Project

      Using AI tools to work faster, then analysing a real business dataset.

      By the end of this module, you will be able to complete and present an analysis of a business dataset.

      • AI tools for analysis: Using AI to write code, explain data and check work.
      • Business dataset project: Asking questions, analysing and finding answers.
      • Presenting insights: Explaining findings and recommendations.

    Career opportunities

    • Data Analyst
    • Business Intelligence Analyst
    • Data Scientist
    • Reporting Analyst

    Frequently asked questions

    How long is the Data Analysis with Python (AI-Powered) course?

    Data Analysis with Python (AI-Powered) takes 2 months. It is a professional course.

    Do I need any experience before joining?

    Basic computer skills; programming knowledge helpful. If you are not sure the course is right for you, talk to us and we will help you choose.

    What certificate will I get?

    You will receive the Data Analysis with Python Certificate when you complete the course.

    Can I study online, or do I have to come to Rongai?

    Both. You can attend in class at our Rongai campus (KayGee House, 1st floor, opposite KCB Bank), where physical classes have a maximum of 15 students, or you can study online.

    What class times are available?

    We run morning classes (8:00 AM to 12:00 PM), afternoon classes (1:00 PM to 5:00 PM), evening classes (6:00 PM to 8:00 PM) and Saturday morning classes, so you can study around work or school.

    How much does it cost?

    Contact us on WhatsApp or call +254 797 884 545 for current fees, payment options and the next intake date.

    How do I enrol?

    Register online on our website, visit us at our Rongai campus, or call or WhatsApp us on +254 797 884 545. We will guide you through choosing a start date and getting set up.