"IQTech Analytics - Where storytelling aids informed decision making"
Welcome to IQTech Analytics, your gateway to a world of limitless learning and growth! We’re thrilled to have you on board.
At IQTech, we’re passionate about empowering individuals and organizations with cutting-edge skills and knowledge. Our expert-led courses are designed to ignite your curiosity, boost your confidence, and transform your career.
Explore our extensive range of courses, from Data Science, Business analytics and stay ahead of the curve.
Meet our MD/CEO
Israel Mayokun T
Business Analyst/Credit & Risk Analyst | Data Scientist | Spreadsheet Instructor | Data Science Consultant
With about a decade of experience in business analysis and data science, he empowers professionals, businesses, and organizations to harness the power of data for growth and informed decision-making. His expertise spans:
– Spreadsheet mastery (Excel, Google Sheets)
– Data visualization (Power BI)
– Data programming and sciences (SQL and Python programming)
– Analytics instructor
– Data science consulting and training
As the founder of IQTECH Analytics, he delivers innovative solutions that drive sales performance, revenue growth, and process improvements. His passion lies in staying current with corporate analytic trends and technologies.
Key achievements:
-Lead business & data analyst, for 7+ years in the telecoms space
– Trained and deployed numerous data science professionals
– Consulted for various organizations, deploying analytic solutions that enhance collections and revenue
– Dedicated to elevating your spreadsheet skills for optimal output and performance
Join our IQtech community today, interact and rub minds with other analysts and data enthusiasts! Register for a course today and be on your way to transforming your career.
We long to see you in school.
Cheers!
Session's Calendar
Virtual Classes
Online live classes
Duration
4 months
Matriculation date
April 5 2025
Graduation date
July 26 2025
Time:
Default time schedule – Saturdays & Sundays 4:00pm – 6:00pm WAT
Payment and Registration Procedure
- Kindly make payment using any of the below payment channels.
- Send evidence of payment, and a confirmation email to complete your registration will be sent to you within 24 working hours.
Offer ends March 21, 2025
Business Analysis & DATA Science
Tools: Excel, SQL, PowerBI
NGN 55,000/$55
- 1 Month internship.
- Certification.
- Capstone project
- Capstone project defense
- Practical, hands on experience with real life projects, datasets.
- Networking with fellow data enthusiasts
- Breakout sessions/Peer to Peer class
- CV Optimization
- LinkedIn Optimization
Late registration window begins March 22, 2025, through April 4, 2025
Business Analysis & DATA Science
Tools: Excel, SQL, PowerBI
NGN 65,000/$65
- 1 Month internship
- Certification.
- Capstone project
- Capstone project defense
- Practical, hands on experience with real life projects, datasets.
- Networking with fellow data enthusiasts
- Breakout sessions/Peer to Peer class
- CV Optimization
- LinkedIn Optimization
Bank Name: PROVIDUS
Account Name: IQtech Analytics.
Account Number: 1304218849
Bank Name: PROVIDUS
Account Name: IQTech Analytics
Account Number: 1304371917
Click here to pay via paystack
Bank Name: PROVIDUS
Account Name: IQtech Analytics.
Account Number: 1304218849
Bank Name: PROVIDUS
Account Name: IQTech Analytics
Account Number: 1304371917
Click here to pay via paystack
EXCEL CURRICULUM
- The world of data analysis in a glance
- Basic definitions, applications in the excel space and navigation between worksheets.
- Sequencing
- Auto-fitting and auto filling techniques with applications
- Harnessing formulars and functions within the excel space.
- Harnessing Logical functions, Mathematical functions, Text functions and applications.
- Understanding cell references and ranges
- Understanding and applying Relative, Absolute, Mixed cell references
- The use of named ranges.
- Data cleaning & formatting
- Dealing with errors, spaces and unwanted notations in Data
- Data Validation
- Data Filtering and sorting techniques
- Pivot tables, pivot chats, advanced filtering (Slicers), Power Pivot
- Conditional Formatting
- Discussing, Understanding, harnessing 6 different lookup functions for data analysis.
- The what-if Analysis
- The model of Scenario analysis
- The model of goal goal seeking
- Data Table
- Financial functions and applications
- Forecasting technique
- peer to peer environment
- project work
- project defense
SQL Curriculum
| What is SQL?, Introduction to Databases, DBMS, Setting up environment, SELECT, DISTINCT, LIMIT |
| Filtering rows (WHERE, AND, OR, NOT), Comparison operators, Sorting (ORDER BY), Filtering with IN, LIKE, BETWEEN, NULL handling |
| COUNT, SUM, AVG, MIN, MAX functions, GROUP BY, HAVING, Aliases with AS |
| INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN, CROSS JOIN (Cartesian Product) |
Introduction to subqueries, Subqueries in SELECT/FROM/WHERE, Correlated subqueries, EXISTS and NOT EXISTS
INSERT, UPDATE, DELETE, Transaction management (COMMIT, ROLLBACK), Best practices for modifying data
| String functions (CONCAT, LENGTH, SUBSTR), Date and time functions, Window functions (ROW_NUMBER, RANK, LEAD/LAG), Statistical functions, CASE statements, Common Table Expressions (CTEs), Advanced Window functions (NTILE, FIRST_VALUE, LAST_VALUE) |
| SQL execution plans, Indexing, Query optimization, Final Project: Applying concepts for analysis, Capstone project. |
PowerBI Curriculum
TESTIMONIALS
My experience with IQTech Analytics was the best of it’s kind. I learnt alot about Excel and Power BI, and I can confidently say that it was the best excel and PowerBI sessions that I have ever experienced.
The tutors are seasoned and highly efficient cum effective. Mr. Israel is exceptional , he teaches with passion and ensures everyone is carried along. He’s truly born to impact knowledge!
Ifeoluwa Akomolafe is very good at Power Bi, Dunsin was able to challenge our knowledge base during his shirt cameo.
Without a blink, I’ll gladly recommend IQTech now and in the future.
Hopefully, I’ll be able to take some lectures on this platform someday, so I can also give back to my generation from my wealth of knowledge and experience.
God bless everyone at IQTech and it’s ever-growing community!
Gbenga Olaifa,
Business Analyst, Nigeria
I had a fantastic experience with IQTECH ANALYTICS , and I long to share my positive feedback. As a new tech student in the tech space, I found the course content to be engaging and practical. The instructors are knowledgeable and outstanding in their courses , allowing personalized feedbacks and giving their full support, which boosted my confidence and improved my skills. I recommend IQTECH ANALYTICS school for anyone looking to improve their data analysis skills and pursue a career in this exciting field.
Idundun Elizabeth
Data Analyst, Nigeria
IQTech presented me with a life changing Skillset opportunity. My excel usage & understanding was broadened from a naïve level into basic level ,then an intermediate level, then professional level. Thanks to my very Palatable Tutor’s techniques ,I don’t stare at Excel function as a novice anymore
@Israel Mayokun You ROCK
Ronke Fagbohungbe
Data/Resource Analyst, Nigeria
My experience at IQTech was an amazing and impactful one. I had the best tutors in Mr Isreal Mayokun and Mr Ifeoluwa Akomolafe. Their mode of teaching is just so impactful and considerate. No one is left out of understanding or following through with the lessons. Almost feels like a Montessori mode of teaching. LOVED EVERY BIT OF IT. My cohort members were the best also, they were SUPPORTIVE and SELFLESS personified! If I would ever have to learn anything in the Tech space again, I’d happily go with IQTech Analytics if they offered to take the course. I’d recommend IQTech anyday to anybody!
Philips Olalekan
Data Analyst Nigeria
IQTECH ANALYTICS possesses remarkable talents for simplifying complex ideas into practical, understandable insights. Their teaching approach is interactive, immersive, and designed to meet the needs of both beginners and experienced learners alike.
I recommend IQTECH ANALYTICS to anyone seeking to enhance their knowledge of data analytics. Their courses were not only educational but genuinely transformative.
Olubola Durojaye,
Data Analyst, United Kingdom
I couldn’t be more impressed with my experience at IQTECH. The tutors are not only smart and highly knowledgeable but also deeply invested in each student’s success. They have a distinct ability to break down complex concepts into understandable lessons, making the learning process both engaging and manageable. IQTECH is an excellent choice for Data Analytics course
Bola Omotosho
Data Analyst, United Kingdom
