Analytics

Data Analytics

Learn to collect, clean, analyse, and visualise data to drive business decisions. Master Excel, SQL, Python, Power BI, and Tableau — the essential tools for every data analyst.

Data Analytics
Course Overview

What You'll Learn

  • Data collection and cleaning techniques
  • SQL for database querying and analysis
  • Python with Pandas for data manipulation
  • Statistical analysis and hypothesis testing
  • Data visualisation with Power BI and Tableau
  • Excel for business analytics and pivot tables
  • Storytelling with data and presentation skills
  • Presenting insights clearly to non-technical stakeholders

Course Details

LevelBeginner
Duration12 Weeks
FormatLive Online + Recorded
Certificate✓ Yes
LanguageEnglish
PriceFree
Enroll Now — It's Free
Curriculum

Course Modules

A structured, hands-on curriculum designed around real industry skills — not just theory.

Module 1: Data Fundamentals
  • Types of data and data sources
  • Data collection methods and surveys
  • Spreadsheet basics and Excel formulas
  • Introduction to relational databases
Module 2: SQL for Analysis
  • SELECT, WHERE, JOIN, GROUP BY
  • Subqueries and Common Table Expressions (CTEs)
  • Window functions: RANK, ROW_NUMBER, LAG
  • Writing analytical queries on real datasets
Module 3: Python for Analytics
  • Pandas: loading, cleaning, and filtering data
  • NumPy for numerical computation
  • Handling missing values and outliers
  • Merging and reshaping datasets
Module 4: Statistical Analysis
  • Descriptive statistics: mean, median, mode, variance
  • Probability distributions and the normal curve
  • Hypothesis testing: t-tests, chi-square
  • Correlation and causation
Module 5: Data Visualisation
  • Power BI: dashboards, DAX, and report publishing
  • Tableau: charts, calculated fields, and story points
  • Python: Matplotlib and Seaborn
  • Choosing the right chart for your data
Module 6: Analytics Capstone
  • End-to-end project: clean and analyse a real business dataset
  • Build a Power BI or Tableau dashboard
  • Present findings as a structured business report
Right Fit

Who This Course Is For

📊
Business Professionals
Operations, marketing, or finance staff who want to make data-driven decisions.
🎓
Recent Graduates
Entry-level candidates building analytical skills to enter data careers.
🔄
Career Changers
Professionals from non-technical fields transitioning into data analysis roles.
Your Instructor

Meet Your Instructor

Instructor
Chukwuemeka Adeyemi
Lead Data Analytics Instructor

A data analyst and business intelligence specialist with 7 years of experience delivering insights to C-suite executives at Nigerian banks and FMCG companies using Power BI and Python.

Student Reviews

What Our Students Say

★★★★★

"Thanks to H-Tech Innovations Hub, our workforce has been armed with highly relevant and in-demand tech skills — enabling consultants to stay ahead of big data trends."

Hassan Gray
Hassan Gray
Mobile Developer
★★★★★

"With H-Tech Innovation Hub, employees were able to marry technology and consultant soft skills. Once they took their key IT courses — the results were outstanding."

Emeka Obi
Emeka Obi
Cloud Engineer, Lagos
Keep Learning

Related Courses

Ready to Start Learning Data Analytics?

Join thousands of students across West Africa learning in-demand tech skills — completely free.