SUNIMTECH
Browse coursesAboutContactFAQ
Log in

Top Enrolled Courses

View all courses
Photo: Fotis Fotopoulos

Claude Mobile App Development

Uko Hanson

No reviews yet
Advanced60hOffsite

₦45,000

Photo: Devin Pickell

WordPress Web Design

Uko Hanson

No reviews yet
Beginner28hOffsite

₦20,000

Photo: Faizur Rehman

Graphic Design & Motion Graphics

Uko Hanson

No reviews yet
Intermediate42hOffsite

₦25,000

Photo: FlyD

Cybersecurity Fundamentals

Uko Hanson

No reviews yet
Advanced55hOffsite

₦35,000

Photo: Budka Damdinsuren

UI/UX & Product Design

Uko Hanson

No reviews yet
Intermediate50hOffsite

₦30,000

Photo: Chris Ried

Web & Software Development (Full-Stack Foundations)

Uko Hanson

No reviews yet
Advanced85hOffsite

₦45,000

SUNIMTECH

Africa’s top learning infrastructure for grooming industry-ready tech, media and digital talent, with practical courses, flexible payment plans, and a certificate that carries real weight with employers.

Course Categories
Artificial Intelligence (AI)Claude AI Apps DevelopmentClaude AI Web Apps DevelopmentDigital Information LiteracyDigital Marketing and Social MediaMedia and JournalismMobile Apps DevelopmentWeb Design and Development
Company
About UsContact UsFAQPrivacy PolicyTerms of Service

© 2026 SUNIMTECH — Sun Institute of Media and Technology.

Photo: Luke Chesser

Applied Data Analytics

No reviews yet
Advanced65 hoursOffsite

About this course

Learn a complete data analytics workflow — spreadsheets, SQL, Python (pandas), statistics, data cleaning, exploratory analysis, visualization/dashboards, A/B testing, and AI-assisted analysis — ending in an end-to-end capstone analysis presented to a stakeholder audience.

Where this course can take you

Data analysts are hired by banks, fintechs, telecoms and agencies across Nigeria, and the same SQL, Python and dashboard skills open remote analyst roles with international companies paying in dollars. Freelance analysts also earn steadily on Upwork building reports and dashboards for small businesses who cannot justify a full time hire. Your capstone, a complete analysis presented to a stakeholder audience, becomes a real portfolio piece you can show in interviews from day one after graduating.

Who this course is for

Professionals who already have basic spreadsheet familiarity and want to become a competent, job-ready data analyst, or analysts wanting to formalize and extend existing skills with SQL, Python, and statistics. This is the Advanced-tier course in the analytics/data catalog.

Entry requirements

- Minimum age 16, comfortable using a computer and basic spreadsheet functions - A laptop able to run Python (setup covered in Module 6) - No prior SQL, Python, or formal statistics background required — this course builds each from the ground up before using it

Curriculum

Module 1: Foundations of Data Analytics (5 lectures)
  • VideoWelcome to Applied Data Analytics15 min
  • ArticleWhat Does a Data Analyst Actually Do?95 min
  • ArticleThe Analytics Workflow: Ask, Collect, Clean, Analyze, Communicate95 min
  • ArticleFour Types of Analysis: Descriptive, Diagnostic, Predictive, Prescriptive95 min
  • QuizModule 1 Quiz: Foundations of Data Analytics15 min
Module 2: Excel/Google Sheets for Analytics (5 lectures)
  • ArticleCore Formulas Every Analyst Needs (Step by Step)90 min
  • ArticleLookup Functions: VLOOKUP, INDEX/MATCH, and XLOOKUP90 min

Instructor

Uko Hanson

Reviews

No reviews yet.

₦35,000

+ ₦5,000 acceptance fee on approval

Apply
  • ArticlePivot Tables, Step by Step90 min
  • ArticleBasic Charting for Quick Insights90 min
  • QuizModule 2 Quiz: Excel/Google Sheets for Analytics20 min
  • Module 3: SQL for Data Analysis (8 lectures)
    • ArticleYour First SQL Query: SELECT, WHERE, ORDER BY80 min
    • ArticleAggregating Data: GROUP BY and Aggregate Functions80 min
    • ArticleCombining Tables: JOINs, Step by Step80 min
    • QuizModule 3 Quiz A: SQL Fundamentals20 min
    • ArticleSubqueries and Common Table Expressions (CTEs)80 min
    • ArticleWindow Functions: Running Totals, Rankings, and More80 min
    • ArticleWriting Efficient Queries: A Beginner's Guide to Query Performance80 min
    • QuizModule 3 Quiz B: Advanced SQL20 min
    Module 4: Statistics Fundamentals for Analysts (5 lectures)
    • ArticleDescriptive Statistics: Mean, Median, Mode, Standard Deviation90 min
    • ArticleUnderstanding Distributions (Normal, Skewed, and What They Mean)90 min
    • ArticleCorrelation vs. Causation: A Step-by-Step Way to Tell the Difference90 min
    • ArticleConfidence Intervals and Basic Hypothesis Testing, Explained Simply90 min
    • QuizModule 4 Quiz: Statistics Fundamentals20 min
    Module 5: Data Cleaning & Preparation (5 lectures)
    • ArticleFinding and Handling Missing Data, Step by Step90 min
    • ArticleDetecting and Removing Duplicates90 min
    • ArticleSpotting and Handling Outliers90 min
    • ArticleStandardizing Formats and Fixing Inconsistent Data90 min
    • QuizModule 5 Quiz: Data Cleaning & Preparation20 min
    Module 6: Python for Data Analysis (Pandas) (6 lectures)
    • ArticlePython Basics for Complete Beginners: Variables, Lists, and Loops95 min
    • ArticleGetting Started with Pandas: Loading Your First Dataset95 min
    • ArticleFiltering, Sorting, and Selecting Data in Pandas95 min
    • ArticleGrouping and Aggregating Data with Pandas95 min
    • ArticleTransforming Data: New Columns, Merging, and Reshaping95 min
    • QuizModule 6 Quiz: Python for Data Analysis20 min
    Module 7: Exploratory Data Analysis (EDA) (4 lectures)
    • ArticleA Repeatable Process for Getting to Know a New Dataset90 min
    • ArticleSummarizing and Profiling Data, Step by Step90 min
    • ArticleVisual Exploration: Histograms, Box Plots, and Scatter Plots90 min
    • QuizModule 7 Quiz: Exploratory Data Analysis20 min
    Module 8: Data Visualization & Dashboard Design (5 lectures)
    • ArticleChoosing the Right Chart Type for Your Data90 min
    • ArticleDashboard Design Principles: Clarity Over Decoration90 min
    • ArticleBuilding Your First Interactive Dashboard, Step by Step90 min
    • ArticleCommon Visualization Mistakes and How to Avoid Them90 min
    • QuizModule 8 Quiz: Data Visualization & Dashboard Design20 min
    Module 9: A/B Testing & Experimentation Basics (4 lectures)
    • ArticleDesigning a Valid A/B Test, Step by Step60 min
    • ArticleCommon Statistical Pitfalls in Experimentation60 min
    • ArticleReading and Interpreting a Results Report Critically60 min
    • QuizModule 9 Quiz: A/B Testing & Experimentation15 min
    Module 10: AI Tools for Data Analytics (3 lectures)
    • ArticleUsing AI to Accelerate Data Analysis, Step by Step75 min
    • ArticleVerifying AI-Suggested Findings Before You Trust Them75 min
    • QuizModule 10 Quiz: AI Tools for Data Analytics15 min
    Module 11: Communicating Insights & Storytelling with Data (3 lectures)
    • ArticleStructuring a Findings Presentation for a Non-Technical Audience60 min
    • ArticleTurning a Chart into a Story: A Step-by-Step Framework60 min
    • QuizModule 11 Quiz: Communicating Insights15 min
    Module 12: Capstone — End-to-End Data Analysis Project (1 lecture)
    • ArticleCapstone Brief: End-to-End Data Analysis Project60 min