Catalogue — oCode360

Catalogue

Everything we make.

Online courses, guides, templates, live workshops, and free resources — all in one place. Built for data practitioners and the teams they work with.

International clients: Prices shown are in South African Rand (ZAR) — contact us directly for USD/GBP quotes. We accept PayPal, Wise Transfer, and Paystack for international payments. Prefer to shop in USD? Find the same products on our Lemon Squeezy store.
Course

SQL for Business Analysts — Zero to Confident

A practical, project-based course covering SQL from fundamentals to advanced analytical queries. Built for analysts, not engineers.

Course

Power BI Foundations — From Raw Data to Dashboard

Build your first end-to-end Power BI report. Covers data connections, Power Query, data modelling, DAX basics, and report design.

Course

Python for Data Analysts — Practical Essentials

Learn pandas, data wrangling, and visualisation using real business datasets. No prior programming experience required.

E-Book

The CEO Mindset — Strategic Data Analytics for Small Business Leaders

A practical 10-step framework for small business leaders who want to use data strategically — without a data team or technical background. Instant PDF download.

Guide

The KPI Playbook — Design Metrics That Drive Decisions

Step-by-step guide to designing, implementing, and reviewing KPIs that your team actually acts on. Includes worked examples and templates.

Guide

The 30-Day SQL Challenge

Structured daily SQL exercises to build real querying confidence in one month. Designed for analysts who know the basics and want to go deeper.

Template

SQL Analytics Starter Pack

20 production-ready SQL queries for common business analysis tasks — annotated, documented, and ready to adapt to your schema.

Template

Python Data Cleaning Notebook

Annotated Jupyter notebook for the 15 most common data cleaning tasks using pandas. Download, adapt, and use immediately.

Template

Power BI Report Template Pack

5 pre-built Power BI report templates for sales, finance, operations, HR, and marketing. Clean layouts, consistent styling, ready to connect your data.

SQL · Intermediate

SQL for Business Analysts — Half Day Intensive

Go beyond SELECT * and learn the SQL patterns that make the biggest difference in real analytics work: window functions, CTEs, subqueries, date maths, and performance tips. You’ll write and run queries throughout — not just watch slides.

Window Functions CTEs Date Logic Aggregations Query Optimisation
Duration
4 hours (half day)
Format
Live Online
Group Size
Max 12
Price
Available on Request
Register Interest
Power BI · Beginner–Intermediate

Power BI Foundations — Full Day

Build your first end-to-end Power BI report from raw data. Covers data connections, Power Query transformations, the data model, basic DAX measures, and report design principles. You leave with a working report and the confidence to build the next one yourself.

Power Query Data Modelling DAX Basics Report Design Publishing
Duration
8 hours (full day)
Format
Live Online or In-Person
Group Size
Max 16
Price
Available on Request
Register Interest
Strategy · All Levels

KPI Workshop — From Objectives to Dashboards

A facilitated session for business and analytics teams to align on what to measure and why. We work through your actual business objectives, design a coherent KPI framework, and map it to existing or planned dashboards. Practical, collaborative, and immediately usable.

OKRs to KPIs Metric Hierarchies Dashboard Planning Stakeholder Alignment
Duration
4 hours (half day)
Format
Team-only (private)
Group Size
4–10 (team)
Price
Available on Request
Book for Your Team
Python · Beginner

Python for Data Analysts — Zero to Useful

A practical introduction to Python for analysts who don’t have a programming background. Covers Python basics, pandas for data wrangling, and matplotlib for visualisation — using real business datasets throughout.

Python Basics pandas Data Wrangling Visualisation
Duration
Full day
Format
Live Online
Coming Soon
Template

SQL Query Starter Pack

20 production-ready SQL queries for common business analysis tasks — sales summaries, customer cohorts, running totals, period-over-period comparisons, and more. Annotated with explanations.

Guide

KPI Design Workbook

A step-by-step framework for defining KPIs that actually get used. Covers business objective mapping, metric hierarchy design, and the seven most common KPI mistakes.

Checklist

Dashboard Design Review Checklist

32-point checklist to review before you publish any Power BI or Tableau dashboard. Covers data accuracy, layout, performance, and stakeholder communication.

Template

Python Data Cleaning Notebook

Jupyter notebook template with annotated pandas code for the 15 most common data cleaning tasks. Handle missing values, duplicates, outliers, and type mismatches without reinventing the wheel.

Guide

Analytics Maturity Self-Assessment

Score your organisation’s data analytics capability across five dimensions: data quality, tooling, skills, processes, and culture. Includes a prioritised improvement roadmap template.

Workbook

Excel to Power BI Migration Planner

A structured workbook for teams moving from Excel-based reporting to Power BI. Covers report inventory, data source mapping, stakeholder change management, and a 6-week rollout timeline.

Checklist

Business Process Audit Template

Document, score, and prioritise processes for improvement using a structured lean-influenced methodology.

Guide

The 30-Day SQL Challenge

Structured daily SQL exercises to build real querying confidence in one month. Designed for analysts who already know the basics but want to go deeper.

Need a custom session for your team?

We design private workshops tailored to your team’s tools, data, and skill level. Minimum 4 participants. Available online and in Cape Town.

Enquire About Private Training

// Free Download

Enter your details and we’ll send the download link straight to your inbox.

Check your inbox!

The download link is on its way. Check your spam folder if you don’t see it in a few minutes.