STUDENTS · COURSES

Structured courses in the 4 tools every analyst needs.

Python, SQL, Power BI and SAS — each a 6-module lecture curriculum with a capstone, taught with real datasets, one-on-one or small group, in English or French.

🎓

You stay the author

Every choice is explained so you can defend it in front of your jury — no copy-paste analyses.

🗓️

Flexible scheduling

Evening and weekend sessions available. Online or in-person in Bamenda.

📈

Learn by doing

Real datasets, exercises and a capstone project in every course — you finish with work you can show.

🐍

Python for Data Analysis

The most transferable skill in data — free, powerful and in demand everywhere.

📚 6 modules 🎯 Beginner → Job-ready 🛠️ Capstone project
1Python Foundations
  • Setup: Anaconda, Jupyter & Google Colab
  • Variables, numbers, strings & printing
  • Lists, tuples, dictionaries & sets
  • Control flow: if / for / while
  • Writing and reusing functions
2Data Wrangling with pandas
  • Series & DataFrames explained
  • Reading CSV, Excel & Google Sheets
  • Selecting, filtering & sorting rows
  • groupby & aggregation
  • Merging & joining tables
3Cleaning & Transformation
  • Handling missing values
  • Data types & parsing dates
  • String & text operations
  • Finding & removing duplicates
  • Reshaping: pivot & melt
4Visualization
  • matplotlib essentials
  • seaborn for statistical charts
  • Distributions & relationships
  • Styling publication-ready figures
  • Exporting charts for your report
5Statistics in Python
  • Descriptive statistics
  • t-tests & ANOVA (SciPy)
  • Correlation & cross-tabulations
  • Linear & logistic regression (statsmodels)
  • Reading & reporting p-values
6Capstone Project
  • Framing the research question
  • End-to-end analysis on a real dataset
  • Building a clean, shareable notebook
  • Writing up your findings
  • Presenting results with confidence
By the end you can

Clean any messy dataset, run the right statistical test, and produce report-ready figures — entirely in Python, ready for a thesis or a data-analyst job.

🗄️

SQL for Data Analysis

The language of data. If your data lives in a database, this is how you ask it questions.

📚 6 modules 🎯 Beginner → Job-ready 🛠️ Capstone project
1Databases & Basic Queries
  • The relational model & tables
  • SELECT, FROM, WHERE
  • ORDER BY & LIMIT
  • Filtering: AND / OR / IN / BETWEEN
  • Handling NULLs
2Aggregation & Grouping
  • COUNT, SUM, AVG, MIN, MAX
  • GROUP BY
  • HAVING vs WHERE
  • Conditional logic with CASE WHEN
  • Rounding & formatting results
3Joins & Combining Tables
  • INNER JOIN
  • LEFT / RIGHT / FULL JOIN
  • Self-joins
  • UNION & UNION ALL
  • Avoiding fan-out & duplicate rows
4Subqueries & Window Functions
  • Subqueries in WHERE / FROM
  • Common Table Expressions (WITH)
  • ROW_NUMBER, RANK, DENSE_RANK
  • Running totals & moving averages
  • LAG & LEAD
5Data Modeling & Cleaning
  • Primary & foreign keys
  • Normalization basics
  • Date & string functions
  • Deduplication strategies
  • Views for reusable logic
6Analytics Capstone
  • Explore a multi-table schema
  • Answer real business questions
  • Build KPI queries
  • Optimize & document queries
  • Export results to a BI tool
By the end you can

Query any relational database confidently and turn multi-table data into clear answers — the single most-requested skill in data-analyst job listings.

📊

Power BI: From Data to Dashboard

Build the interactive dashboards that managers and juries love to see.

📚 6 modules 🎯 Beginner → Job-ready 🛠️ Capstone dashboard
1Power BI Foundations
  • Power BI Desktop tour
  • Connecting to Excel, CSV & SQL
  • The Power Query Editor
  • Data types & column profiling
  • Refreshing your data
2Shaping Data (Power Query)
  • Removing errors & duplicates
  • Splitting & merging columns
  • Unpivoting messy tables
  • Appending & merging queries
  • Applied steps & M basics
3Data Modeling
  • Relationships & cardinality
  • Star-schema design
  • Calculated columns
  • Hierarchies
  • Sort-by & data categories
4DAX Essentials
  • Measures vs calculated columns
  • SUM, COUNTROWS, DIVIDE
  • CALCULATE & filter context
  • Time intelligence (YTD, MoM)
  • KPI & variance measures
5Visualization & Report Design
  • Choosing the right visual
  • Slicers & filters
  • Drill-through & tooltips
  • Conditional formatting
  • Layout, theme & accessibility
6Publish, Share & Capstone
  • Storytelling with bookmarks
  • Publishing to Power BI Service
  • Scheduled refresh
  • Row-level security (RLS)
  • Build a full capstone dashboard
By the end you can

Model data and build an interactive, shareable executive dashboard end-to-end — from raw file to a published report with scheduled refresh.

📋

SAS Programming & Analysis

The industry standard in clinical research, banking and government analytics.

📚 6 modules 🎯 Beginner → Certification path 🛠️ Capstone report
1SAS Foundations
  • SAS Studio & the environment
  • Libraries & datasets
  • The DATA step & the PDV
  • Importing Excel & CSV
  • Reading the LOG & debugging
2DATA Step Programming
  • Reading raw data: INFILE / DATALINES
  • Creating & recoding variables
  • IF-THEN / ELSE logic
  • SAS functions (numeric & character)
  • Iterative DO loops
3Manipulating Data
  • Subsetting & the WHERE statement
  • PROC SORT
  • Merging datasets with BY
  • RETAIN & accumulating totals
  • Concatenating & appending
4Summarizing with PROCs
  • PROC MEANS & SUMMARY
  • PROC FREQ
  • PROC SQL inside SAS
  • PROC TABULATE
  • Formats & labels
5Statistical Analysis
  • PROC TTEST
  • PROC ANOVA / GLM
  • PROC CORR
  • PROC REG (regression)
  • Charts with PROC SGPLOT
6Reporting & Capstone
  • ODS output: PDF / RTF / Excel
  • PROC REPORT
  • Macro-variable basics
  • A clinical-style analysis dataset
  • Build a full capstone report
By the end you can

Read, transform and analyze data in SAS and produce a clean statistical report — following the SAS Base Programming certification path (aligned to A00-215).

🧭
Placement chat

A short call to find your level and goals.

👥
Live sessions

One-on-one or small group, online or in Bamenda.

💻
Practice on real data

Exercises and datasets after every module.

🎓
Capstone & certificate

Finish with a portfolio project you can show.

Ready to start learning?

Tell me which course and your current level — I'll suggest a plan and schedule.

Enroll or ask a question
FREQUENTLY ASKED

Honest answers to common questions.

Will you write my thesis for me? +

No. I help you understand and run the analysis, and I document what we do so you can defend it. The writing and the ideas stay yours.

What software will we use? +

Whatever your program requires — Python, SAS, Excel, SPSS basics. If you have no preference, I usually recommend Python (free, transferable to future jobs).

Can we work in French? +

Yes. Native French, fluent English. Sessions, reports and deliverables can be in either language.

What if I'm completely new to data? +

That's the most common case. We start from your data and your question — not from textbook theory. You'll learn the tools you need to finish this project, not a semester of unrelated material.

LET'S TALK

Ready to get started?

Tell me about your project, question or goal. I reply within 24 hours, in English or French.

Get in touch