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.

Request Quotation ← Back to Courses

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

Level Beginner

Duration To be confirmed

Training Format Virtual Live Class Instructor-Led Training Physical Training

Certificate Details on request

Language English

Contact our team to discuss your preferred training format, schedule, duration, and fees. Training arrangements are confirmed through a quotation.

Request Quotation

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

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

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

Cloud Engineer, Lagos