Unlocking Your Full Potential: Data Training
& IT Services

Data & IT: Unleash Your Potential. We provides expert data training and IT solutions. Gain in-demand skills and optimize operations. Experience the NDYLENS advantage where data expertise meets cutting-edge technology.

Get Started

Unlock Your Full
Potential
Data Made Easy

Join Our Data training classes for 12 weeks to elevate Your Skills and Broaden Your Horizons in the World of Data Analytics

Get Started

Experience
The Best Of  IT Excellence With Us

We provide expert solutions. From cloud computing and cybersecurity to data analytics and support, we streamline your technology and boost your bottom line. Experience the difference of seamless IT – contact us today for a free consultation.

Get Started

Unlocking Your Full Potential: Data Training & IT Services

Data & IT: Unleash Your Potential. We provides expert data training and IT solutions. Gain in-demand skills and optimize operations. Experience the NDYLENS advantage where data expertise meets cutting-edge technology.

Get Started

OUR SERVICES

Data Science Solutions

Experience our transformative machine learning and data modeling solutions for your unique business cases.

Data Strategy

We deliver tailored data roadmaps, actionable insights, and seamless integration for your business success.

Data Insights Platform

Uncover insights, seize opportunities, and elevate your business with our advanced Data Insights Platform.

Data Training

We ignite high performance through our immersive training programs, unlocking the full potential of your staff.

ETL Pipeline

Efficiently develop and monitor your ETL pipelines with our expert services, ensuring seamless data extraction, transformation, and loading for optimized data processing.

Custom Software Development

Experience the power of custom-built software designed to meet your unique needs and fuel your growth.

Training
    Curriculum

Experience the power of custom-built software designed to meet your unique needs and fuel your growth.

Weeks 1-2: Google Sheets
 Week 1: Introduction to Google Sheets
- Understanding cells and basic formulas
- Using cell references effectively (relative and absolute)
- Exploring and understanding data structures
- Cleaning and preparing raw data for analysis
Week 2: Data Analysis in Google Sheets
- Performing data analysis using built-in functions
- Applying positional matching techniques (VLOOKUP, INDEX/MATCH)
- Creating pivot tables for summarizing and segmenting data
Using conditional formatting to highlight trends and patterns
Weeks 3-6: Power BI
Week 3: Introduction to Power BI
- Overview of Power BI environment
- Data source connections in Power BI
- Data cleaning and transformation using Power Query (ELT)
Week 4: Power BI - Semantic Models & Data Modeling
- Understanding and building semantic models
- Data modeling fundamentals
Relationships and data integrity
Week 5: Power BI - DAX & Reporting
- Introduction to Data Analysis Expressions (DAX)
- Building calculated columns and measures
- Creating interactive reports and dashboards
Week 6: Power BI - Deployment & Maintenance
- Publishing and sharing reports
- Scheduling data refreshes
- Maintaining and troubleshooting reports
Weeks 7-14: SQL
Week 7: Introduction to SQL & Database Basics
- SQL and database concepts (tables, rows, columns)
- SQL Syntax Basics (SELECT, FROM)
Week 8: Basic SQL Queries
- WHERE clause (filtering)
- ORDER BY clause (sorting)
- LIMIT clause (row limitation)
Week 9: Data Types and Operators
- Numeric data types (INT, DECIMAL, FLOAT)
- String data types (CHAR, VARCHAR, TEXT)
- Date and Time data types (DATE, TIME, DATETIME, TIMESTAMP)
Week 10: Aggregate Functions
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING clauses
Week 11: SQL Joins
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
- Practical examples and join conditions
Week 12: Subqueries and Common Table Expressions (CTEs)
- Using subqueries in SELECT, FROM, WHERE clauses
- Defining temporary result sets using CTEs
- Simplifying complex queries with CTEs
Week 13: Window Functions
- ROW_NUMBER, RANK, DENSE_RANK
- LEAD, LAG
- Calculating running totals, moving averages
Week 14: Advanced SQL Topics
- Advanced filtering and querying
- Complex joins and performance optimization
- Practice exercises and case studies
Weeks 15-16: DBT (Data Build Tool)
Week 15: Introduction to DBT & DBT Models
- Overview of DBT
- Creating and managing DBT models (Part 1 & 2)
Week 16: DBT Advanced Concepts
- Model refactoring, usage of ref() and source()
- DBT Testing, documentation, seeds, and snapshots

HERE ARE A FEW OF

OUR
TESTIMONIALS

200+ Trained Students

Oladayo Joshua Akinola

Oladayo Joshua Akinola

The program has been exceptional! Mr. Victor is an amazing mentor in data analysis. His deep expertise in SQL, Python, and Power BI, combined with his passion for teaching, makes learning both engaging and transformative. His guidance is truly inspiring, simplifying complex concepts into clear, actionable insights. Also the course is very affordable and fully packed with lots of knowledge. Highly recommended!

Adeleke Ajibade Waheed

Data analyst

Learning under Victor Akan has been valuable. His use of practical examples and real-world case study projects has greatly improved my efficiency as a data analyst in an office setting. Working on these real-world case projects has been especially helpful.

Amaka Ezeoke

Data analyst, moniepoint

He’s more than a teacher, he is a mentor. He pushes you till you gain mastery of your skill.

Oladayo Joshua Akinola

Oladayo Joshua Akinola

The program has been exceptional! Mr. Victor is an amazing mentor in data analysis. His deep expertise in SQL, Python, and Power BI, combined with his passion for teaching, makes learning both engaging and transformative. His guidance is truly inspiring, simplifying complex concepts into clear, actionable insights. Also the course is very affordable and fully packed with lots of knowledge. Highly recommended!

START YOUR AMAZING DATA JOURNEY

Register with us and work hand in hand with our amazing instructor with years of experience under his belt
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Pages
Our ServicesCurriculumTestimonialsContact
Terms of Use & Privacy Policy
©2025 Ndylens. All Rights Reserved