GacaloTech
AI & DataUpcoming
Insights Track

Data Analytics

Learn how to work with data, analyze information, and communicate insights that inform real decisions.

6 WeeksOnline & LabBeginner FriendlyHands-on Analysis
Data Analytics

Upcoming Cohort

Mogadishu Lab & Online

Duration6 Weeks5 hours / week
FormatHybridOnline & Mogadishu Lab
ScheduleWed & Sat4:00 – 6:30 PM EAT
CohortCohort 01October 2026
PrerequisitesNoneSpreadsheet curiosity helps
Foundations to Production

What You'll Learn

From messy tables to a clear story: spreadsheets, SQL, Python, and charts you can present.

MODULE 01

Spreadsheets to SQL

Clean, filter, and join data. Move from spreadsheet habits into queries you can reuse.

Weeks 01–02Foundations
MODULE 02

Python for Data Analysis

Load tables, compute summaries, and handle missing values with beginner-friendly Python.

Weeks 03–04Analysis
MODULE 03

Visualization & Storytelling

Choose the right chart and write the sentence that makes the insight usable.

Week 05Communication
MODULE 04

Actionable Dashboards

Assemble a simple dashboard and a short readout for a decision-maker.

Week 06Delivery
Pedagogical Framework

How the Program Works

Every week you work a real table, not a toy lecture.

1

Learn

Live walkthroughs of cleaning, querying, and charting with the cohort.

2

Practice

Lab time on datasets with mentor help when you get stuck.

3

Build

A weekly notebook or sheet that answers a defined question.

4

Share

Present one insight and take questions — the same way teams actually work.

Week-by-Week Syllabus

Program Structure

Five hours a week, with a weekend lab for analysis sprints.

Week 01

Data hygiene in spreadsheets

Types, filters, pivot tables, and common errors

Spreadsheets
Week 02

Asking questions with SQL

SELECT, WHERE, GROUP BY, and simple joins

SQL
Week 03

Python notebooks

Loading CSVs, summaries, and missing data

Milestone 1
Week 04

Analysis patterns

Comparisons, trends, and checking your own work

Python
Week 05

Charts that tell the truth

Visualization choices and a one-page insight write-up

Story
Week 06

Dashboard & demo

A simple dashboard and live readout for the cohort

Graduation

Program Overview

Duration

6 Weeks · 5 hrs/week

Format

Online & Mogadishu Tech Lab

Schedule

2 live sessions/week

Mentorship

Small-group mentor review

Outcome

Dashboard + insight notebook

Cohort StatusAdmissions Review

Who is This For?

  • Somali girls and women who want to work with numbers, not just consume reports.
  • Beginners comfortable with a computer who are ready to practice every week.
  • People who prefer clear questions and evidence over vague dashboards.
  • Students who can attend live labs and finish a short weekly analysis.
Hands-on Portfolio

Don't just learn. Build.

Finish with a cleaned dataset, a notebook, and a dashboard you can talk through.

Cleaned dataset & query pack
Project 01
SpreadsheetsSQL

Cleaned dataset & query pack

A messy table turned into a reliable source, with the queries used to answer three defined questions.

Insight notebook
Project 02
PythonCharts

Insight notebook

A short analysis with charts and a plain-language summary a non-analyst can use.

Decision dashboard
Project 03
DashboardDemo

Decision dashboard

A simple dashboard and a five-minute readout of what to do next.