Course Overview

DATA ANALYSIS USING PYTHON, SPSS, SQL, AND POWER BI
TRAINING WORKSHOP
Duration: 4 Days October 7th to 10th 2025

Course Fee: $ 700 per person
Venue: Meridian Hotel, Nairobi, Kenya

Target Audience: Researchers, data analysts, finance professionals, and business decisionmakers

Day 1: Introduction to Data Analytics & SPSS
• Overview of Data Analysis & Statistical Techniques
• Introduction to SPSS: Data Entry, Cleaning, and Descriptive Statistics
• Statistical Testing in SPSS (T-tests, ANOVA, Regression)
• Hands-on Exercise: Running a Regression Model

Day 2: SQL for Data Analysis
• Introduction to Databases & SQL Queries
• Data Extraction, Filtering & Joins in SQL
• Advanced SQL: Aggregate Functions & Stored Procedures
• Practical Exercise: Querying a Large Dataset

Day 3: Data Analysis & Visualization in Python
• Introduction to Python for Data Science (Pandas, NumPy, Matplotlib)
• Exploratory Data Analysis (EDA) & Data Cleaning
• Machine Learning Basics with Python (Regression & Classification)
• Workshop: Building a Predictive Model

Day 4: Power BI & Business Intelligence Dashboards
• Introduction to Power BI & Data Connectivity
• Data Transformation & Modeling in Power BI
• Creating Interactive Dashboards & Reports
• Hands-on Project: Developing a Business Dashboard

Kindly confirm your participation with:
The Training Coordinator
Capacity Africa Institute
Email: workshops@capacityafrica.org
Website: www.capacityafrica.org