Beginner Level12 Weeks

Data Analytics

By the end of this course, students will confidently analyze business data, build dashboards and explain insights clearly.

Live Online

Interactive sessions

Hands-On Projects

Build real portfolio pieces

Certificate

Professional Certificate of Completion

Course Prerequisites

What you need

  • Basic computer skills
  • Basic numeracy
  • Familiarity with Excel
  • Willingness to learn and work with data

Not required

  • No programming experience
  • No data analytics background
  • No advanced mathematics

Equipment

  • • Laptop required (8GB RAM recommended)
  • • Stable internet connection

What You'll Learn

Excel for Business Analysis

Master formulas, pivot tables and data visualization for real business scenarios.

SQL Without Fear

Write queries to extract and analyze data from databases with confidence.

Power BI Dashboards

Create interactive dashboards that tell compelling data stories.

Business & Financial Analytics

Apply analytics to solve real business problems in finance, sales and operations.

Portfolio Development

Build a showcase of projects that demonstrate your analytical capabilities.

Career Preparation

Learn to present insights clearly and prepare for data analyst interviews.

What You'll Build

Throughout the course, you'll create portfolio-ready projects that showcase your skills to employers.

Excel Dashboards

Build dynamic business dashboards using advanced Excel features, conditional formatting and charts.

Pivot TablesAdvanced FormulasData Visualization

SQL Analysis Projects

Query real-world datasets to answer business questions and extract meaningful insights.

JoinsSubqueriesAggregations

Interactive Dashboards

Design and deploy professional dashboards in Power BI for stakeholder presentations.

Data ModelingDAX/CalculationsVisual Design

Portfolio Case Studies

Document end-to-end analytics projects with clear problem statements, analysis and recommendations.

Problem SolvingStorytellingDocumentation

Your Instructor

Likeleli Motheo

Likeleli Motheo

Finance Analyst

A professional Finance Analyst with data analytics certification and extensive experience in financial modeling, business intelligence and data-driven decision making in international companies. Specializes in practical Excel, SQL and dashboard tools for businesses and finance professionals who want to level up their analytical capabilities. Known for breaking down complex concepts into clear, actionable steps.

Course Curriculum

Shared learning in Weeks 4-6. SQL course students join this cohort for the SQL weeks, working through the same curriculum at the same time as Data Analytics students.

Shared learning in Weeks 7-9. Power BI course students join this cohort for the dashboard weeks, working through the same curriculum at the same time as Data Analytics students.

1

Excel Foundations

Formulas, functions, data cleaning and basic analysis

2

Advanced Excel Part 1

Pivot tables, VLOOKUP, XLOOKUP and data validation

3

Advanced Excel Part 2

Conditional formatting, charts, dashboards and automation

4

SQL Basics

Shared with SQL

SELECT statements, filtering, sorting and basic queries

5

SQL for Analysis

Shared with SQL

Joins, subqueries, aggregations and data manipulation

6

Advanced SQL

Shared with SQL

Window functions, performance optimization

7

Introduction to Dashboards

Shared with Power BI

Data modeling, connecting data sources, basic visuals

8

Advanced Dashboards

Shared with Power BI

Calculations, DAX, interactivity and filters

9

Dashboard Design & Best Practices

Shared with Power BI

Visual design, storytelling and UX principles

10

Business & Financial Analytics

Financial analysis, KPIs, metrics and reporting

11

Advanced Analytics & Case Studies

Real-world projects, problem solving and insights

12

Portfolio & Career Preparation

Final project, resume tips, interview preparation

Who This Course Is For

Career switchers targeting analyst roles
Students preparing for data analyst positions
Finance professionals wanting to add data skills
Business analysts ready to level up
Anyone handling data in Excel who wants to do more
Professionals seeking to make data-driven decisions

Small Class Sizes for Better Learning

Limited to 25 students per cohort

Data analytics requires close guidance, feedback on analysis and discussion around business decisions. By limiting each cohort to 25 learners, we ensure every student receives personalized support, clear feedback on assignments and hands-on mentoring needed to turn data into real business insight.

Why Learn Data Analytics?

High Demand Skills

Data analysts are in high demand across every industry. Organizations rely on data to make smarter, faster decisions.

Make Better Decisions

Learn how to turn raw data into clear insights that guide strategy, improve performance and reduce risk.

Career & Freelance Opportunities

Data analytics opens doors to full-time roles and consulting or freelance work. Analyze data for businesses anywhere in the world.

Future-Proof Career

Data-driven decision-making is the foundation of modern business. Analytics skills will remain essential as technology and AI continue to evolve.

Course Pricing

M4,500.00

12-Week Program

M350.00 application fee paid upon applying

Upfront Payment

M4,500.00

Pay in full before course starts

Installment Plan

M1,650.00/month

3 monthly payments

Total: M4,950.00 (includes M150 monthly fee)

Frequently Asked Questions

Why only 25 students per cohort?

Data analytics requires hands-on practice with real datasets, troubleshooting formulas and interpreting results. Small cohorts enable instructors to provide personalized feedback, answer specific questions and ensure each student develops strong analytical skills through guided practice.

Do I need any prior experience?

No! This course is designed for complete beginners. We start with the fundamentals and build up gradually.

What if I have a full-time job?

Sessions are done in the evenings for 2 to 2.5 hours, only for 2 days per week. So you are covered.

Will I get a certificate?

Yes, you will receive a Professional Certificate of Completion after finishing the course and submitting your projects.

What happens after I complete the course?

You will have a portfolio of real analysis projects, career preparation support and lifetime access to our community for networking and job opportunities.

Ready to Become a Data Analyst?

Join the next cohort and build the analytical skills that open doors in business, finance and beyond.

Enroll in Data Analytics Course

Have questions? Contact us

Got any Questions?Chat with us