Course overview
In today’s data-driven world, the ability to analyze and interpret data is a highly sought-after skill across industries. Our Data Analytics course equips you with the knowledge and hands-on experience to transform raw data into meaningful insights. From mastering Excel and SQL to exploring Power BI and Python, you’ll gain practical skills in data cleaning, visualization, and analysis.
Whether you aim to make data-driven decisions, optimize business processes, or build interactive dashboards, this course provides a structured learning path to turn data into actionable intelligence. Join us and start your journey toward becoming a confident and proficient data analyst.
Register now
Course Curriculum
- Your Learning Path
- What is Data Analysis
- Types of Data
- Data Analysis Process
- Overview of Tools (Excel, MySQL, Power BI, Python)
- Installing and Setting Up Required Tools
- Excel Interface and Navigation
- Data Entry and Data Types
- Basic Formulas and Functions
- SUM
- AVERAGE
- COUNT
- IF
- Data Formatting
- Sorting and Filtering
- Creating Basic Charts (Column, Line, Pie)
- Text Functions
- TRIM
- LEFT
- RIGHT
- MID
- LEN
- Lookup Functions
- VLOOKUP
- XLOOKUP
- Logical and Conditional Functions
- COUNTIF / COUNTIFS
- SUMIF / SUMIFS
- IFS
- PivotTables and PivotCharts
- Practical Data Cleaning Workflow
- Excel Dashboard Basics
- Introduction to Databases
- Understanding Tables and Records
- MySQL Environment Overview
- Writing Basic SQL Queries
- CREATE
- SELECT
- FROM
- WHERE
- Filtering Data Using AND / OR
- Aliasing and Limiting Results
- Hands-on Query Practice
- Aggregate Functions
- COUNT
- SUM
- AVG
- GROUP BY and HAVING
- SQL JOINs
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CASE Statements
- Analyzing Customer and Order Data
- SQL Mini-Project
- Power BI Interface Overview
- Connecting Data from Excel and SQL
- Data Transformation Using Power Query
- Creating Visuals
- Bar Charts
- Pie Charts
- Tables
- Cards
- Filters and Slicers
- Building a Basic Sales Dashboard
- Introduction to DAX
- DAX Functions
- SUM
- COUNTROWS
- CALCULATE
- Calculated Columns vs Measures
- Data Modeling and Relationships
- Bins and Lists
- Advanced Dashboard Design
- Performance Dashboard Mini-Project
- Python Environment Setup (VS Code)
- Python Basics
- Variables
- Data Types
- Lists
- Dictionaries
- Introduction to Pandas and NumPy
- Importing CSV and Excel Files
- Exploring and Understanding Datasets
- Data Filtering, Grouping, and Aggregation
- Data Visualization
- Bar Charts
- Line Charts
- Histograms
- Dataset Selection
- Data Cleaning Using Excel or Power Query
- Analysis Using SQL or Python
- Data Visualization Using Power BI, Python, or Excel
- Dashboard and Report Development
- Insight Presentation
- Peer Review and Feedback
Duration: 3-4 Months
Pricing: ₦300,000