The Analytics School

The Analytics School

← Back to All Programmes
Data & AI

Advanced Data Analytics

Become the SQL and Python-skilled analyst companies pay more to hire.

8 Weeks₦69,999₦120,000
Next Cohort Starts October 5, 2026

Learn how to analyze data and forecast trends for businesses, using SQL and Python alongside advanced Power BI, and turn messy data into decisions that drive growth.

Does This Sound Like You?

  • You're tired of your income and want to add more value at work, going beyond Excel
  • You spend hours cleaning messy data manually instead of automating the process
  • You can build basic reports, but struggle to go deeper into insights that drive business growth
  • You feel stuck at the "beginner level" and don't know how to move into tools like SQL or Python
  • Your dashboards look good, but they don't answer the real business questions managers care about
  • You see job postings asking for advanced data skills, and you worry you don't measure up

Before

  • You see job postings asking for advanced data skills, and you don't measure up
  • You rely on guesswork instead of clear insights
  • Basic reports that don't answer deeper business questions

After

  • Increase in income
  • You can handle larger datasets with SQL and Python
  • Clear problem identification and data-backed recommendations
  • Ready to move into data engineer or data scientist roles, with projects to show for it

Our Curriculum

Weeks 1-2

Advanced Power BI

  • Advanced data modeling and relationships in Power BI
  • DAX (Data Analysis Expressions) for complex calculations
  • Building interactive dashboards that answer strategic business questions
  • Advanced visualization for executive-level reporting
Weeks 3-5

SQL for Data Management & Analysis

  • SQL fundamentals: queries, joins, filtering, grouping
  • Advanced SQL: subqueries, window functions, CTEs
  • Cleaning, transforming, and preparing large datasets using SQL
  • Real business case studies, extracting insights from relational databases
Weeks 6-7

Python for Data Analysis

  • Python basics for data analysis, syntax, libraries, workflows
  • Pandas and NumPy for data manipulation and numerical analysis
  • Data visualization with Matplotlib and Seaborn
  • Automating repetitive tasks, and an introduction to machine learning concepts
Week 8

Intensive Internship & Capstone Project

  • Apply Excel, Power BI, SQL, and Python in real business projects
  • Work with messy, real-world datasets under supervision
  • Deliver insights and dashboards that solve actual business problems
  • Present your final capstone project to demonstrate mastery
Internship — Week 8

A one-week intensive internship and capstone project, applying everything you've learned (Excel, Power BI, SQL, and Python) to a real business problem under supervision.

During the internship, you will

  • Apply Excel, Power BI, SQL, and Python to real business projects
  • Work with messy, real-world datasets
  • Deliver insights and dashboards that solve actual problems
  • Present your capstone project to demonstrate mastery
  • Build a portfolio that proves your advanced skills to employers

You're graded on

  • Two real-world projects, done and presented30%
  • Portfolio built40%
  • 15 LinkedIn posts published15%
  • CV, cover letter and proposal completed15%

Who This Is For

GraduatesJob SeekersWorking ProfessionalsUndergraduatesIntending FreelancersConsultantsManagersEntrepreneurs

You should have prior working knowledge of Microsoft Excel.

Schedule & Format

Weekday classes: Mondays and Thursdays, 7-9 PM WAT.

Practical, case-based, real-life projects — live, instructor-led classes.

Career Outcomes

  • Senior Data Analyst
  • Data Engineer
  • Data Strategy Specialist
  • BI Consultant
  • Growth Analyst
  • Analytics Manager

Top Industries Hiring

Technology & SoftwareFinancial ServicesHealthcare & PharmacyGovernment & Public SectorProject ManagementManufacturingEnergy & UtilitiesConsultingTelecommunicationMedia & Entertainment

Why You Should Join

Practical, case-based learning
Hands-on with real industry tools
Expert-led live sessions
One-on-one mentorship and support
Personalized feedback and guidance
Career placement assistance
Thriving professional community
Job readiness and preparation

Ready to Get Started?

Next cohort starts October 5, 2026

Ask a Question