100% Practical Data Analytics Training
Become a competent and certified data analyst now.
To speak with someone,
Going through this course with us will give you the requisite practical skills and experience to become a competent full-stack data analyst.
After your training and optional internship experience, you will perfectly fit into the role of a Data Analyst / Business Analyst. You will be able to work for any company in the world physically or remotely; and compete favourably in the world of data analysts regardless of where the others studied… even if it’s in Lagos, Harvard, Oxford, Cambridge or MIT.
Our vision is to be one of the best / top 3 places to learn data analysis in Nigeria in terms of training delivery and post training job opportunities. So when you enroll with us, you are making a wise investment into your career and future.
And, we give all our students one year post-training support to help you establish your career as a data analyst.
AREAS COVERED IN OUR TRAINING PROGRAM
- Data Engineering
- Data Analytics and Visualization
- Data Modeling
- GitHub
- How to secure a physical or remote job as a data analyst
So far, many learners enrolled in our data analytics training in Ibadan because...
- they wanted to add data analytics skills to their Resume to boost their chances in the labour market. OR
- they are working already and need to impress their boss as well as increase their efficiency and relevance at work with their new skill. OR,
- they are about to continue their education overseas in data analytics or data science related field and want to have some practical experience before leaving the country. OR
- they are migrating to developed countries and want to operate in the IT space on their arrival there. OR
- they need it personally for their research work and/or private business.
Whichever category you belong to, you will be satisfied.
Basic Requirement:
While we take the training classes from the A.B.C for all learners, basic computer appreciation / operations skills and a good personal computer is a requirement for entry into this program.
Core i7, 16GB RAM and SSD is recommended. But lower configuration may still work fine. Contact us with your system configuration for further advice.
If you need basic computer literacy trainings before your data analytics class begins, kindly enroll earlier and indicate so that we can make special arrangements for you.
See Our Curriculum Here
This module will empower our learners with Microsoft Excel and basic to advanced skills to work with data for analysis, graphs, data organization and programming. The following topics are covered:
Excel for Data Analytics and Visualization
- Getting started with Excel
- Working with data and Excel tables
- Performing calculations on data
- Changing workbook appearance
- Focusing on specific data by using filters
- Reordering and summarizing data
- Combining data from multiple sources
- Analyzing data and alternative data sets
- Creating charts and graphics
- Using PivotTables and PivotCharts
- Using DAX in the Power Pivot Window
- Printing worksheets and charts
- Working with macros and forms
- Working with other Office programs
- Collaborating with colleagues
- Manage and share workbooks
- Apply custom formats and layouts
- Create advanced formulas
- Create advanced charts and formulas
- Using the Analysis Toolpak (Data Analysis)
- Using the Excel Solver
CERTIFICATION
While we give you our Certification of Training, we also encourage you to attempt the following global certifications:
In addition, if you are looking at enrolling for an undergraduate or post graduate degree in related course in any institution overseas, this training prepares you ahead for first class degree.
COST:
From ₦100,000 if taken as a stand alone course.
Power BI for Data Visualization
- Introduction into Data Visualization Concepts
- Understanding the basic concept of data visualizations – Understanding Datasets, Data Visualization, Visualization Interpretation
- Importing Datasets into Power BI
- Navigating Power BI
- Understanding the basis of Hierarchy Formation – Drilling Up, Drilling Down
- Advanced Drilling Options
- Colours for Enhanced Visualizations
- Time Series, Aggregation, Granularity and Filters
- Maps, Scatter Plots and Interactive
- Custom Visualization Installation
- Data / Business Forecast with Power BI
- Creating Relationship among Tables
- DAX – Data Analysis Expression with Power BI
- Publishing Report on powerbi.com
CERTIFICATION
While we give you our Certification of Training, we also encourage you to attempt the following global certifications:
In addition, if you are looking at enrolling for an undergraduate or post graduate degree in related course in any institution overseas, this training prepares you ahead for first class degree.
COST:
From ₦100,000 if taken as a stand alone course.
Learning to work with SQL, this module empowers you to be able to do the following:
- Use SQL for data mining, data analysis, and data visualization
- Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
- Become a Master SQL Developer
- Build awesome dashboards with Google Data Studio and Google Big Query as the backend
- Be confident in using the Google Big Query Tool and Ecosystem
- Practice Every Step of the Way by Working through myriads of practice files.
Modules
- Explaining the theoretical and physical aspects of a relational database
- Relating clauses in SQL Select Statement to Components of an ERD
- Explaining the relationship between a database and SQL
Retrieving Data using the SQL SELECT Statement
- Using Column aliases
- Using The SQL SELECT statement
- Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Using Arithmetic expressions and NULL values in the SELECT statement
Restricting and Sorting Data
- Applying Rules of precedence for operators in an expression
- Limiting Rows Returned in a SQL Statement
- Using Substitution Variables
- Using the DEFINE and VERIFY commands
- Sorting Data
Using Single-Row Functions to Customize Output
- Manipulating strings with character functions in SQL SELECT and WHERE clauses
- Performing arithmetic with date data
- Manipulating numbers with the ROUND, TRUNC and MOD functions
- Manipulating dates with the date function
Using Conversion Functions and Conditional Expressions
- Applying the NVL, NULLIF, and COALESCE functions to data
- Understanding implicit and explicit data type conversion
- Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nesting multiple functions
Reporting Aggregated Data Using Group Functions
- Restricting Group Results
- Creating Groups of Data
- Using Group Functions
Displaying Data from Multiple Tables
- Using Self-joins
- Using Various Types of Joins
- Using Non equijoins
- Using OUTER joins
- Understanding and Using Cartesian Products
Using Subqueries to Solve Queries
- Using Single Row Subqueries
- Using Multiple Row Subqueries
- Update and delete rows using correlated subqueries
Using SET Operators
- Matching the SELECT statements
- Using the ORDER BY clause in set operations
- Using The INTERSECT operator
- Using The MINUS operator
- Using The UNION and UNION ALL operators
Managing Tables using DML statements
- Managing Database Transactions
- Controlling transactions
- Perform Insert, Update and Delete operations
- Performing multi table Inserts
- Performing Merge statements
Managing Indexes Synonyms and Sequences
- Managing Indexes
- Managing Synonyms
- Managing Sequences
Use DDL to manage tables and their relationships
- Describing and Working with Tables
- Describing and Working with Columns and Data Types
- Creating tables
- Dropping columns and setting column UNUSED
- Truncating tables
- Creating and using Temporary Tables
- Creating and using external tables
- Managing Constraints
Managing Views
- Managing Views
Controlling User Access
- Differentiating system privileges from object privileges
- Granting privileges on tables
- Distinguishing between granting privileges and roles
Managing Objects with Data Dictionary Views
- Using data dictionary views
Managing Data in Different Time Zones
- Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Working with INTERVAL data types
CERTIFICATION
While we give you our Certification of Training, we also encourage you to attempt the following global certifications in Database Management
In addition, if you are looking at enrolling for an undergraduate or post graduate degree in related course in any institution overseas, this training prepares you ahead for first class degree.
COST:
From ₦100,000 if taken as a stand alone course.
Python is one of the best languages used by data scientist and machine learning engineers for various projects / application. This module will take learners through our
- Python Foundation Course where you will learn Python Programming fundamentals.
- Data Analytics and Data Wrangling Course where you will learn about data cleaning, data analysis, data engineering, data preprocessing and more
Before the end of this data analytics training experience, learners will work on the following projects:
- Earthquake prediction
- Restaurant Recommendation system
- Cryptocurrency Price Prediction for the next 30days
- Health Insurance Premium Prediction
- Financial Budget Analysis
- Ted-Talks Recommendation System
- Next word Prediction
- Movie Recommendation System
- Image Recognition with Machine Learning
- Fake News Detection
- Uber Data Analysis
- Handwritten Character Recognition
- Credit Card Fraud Detection
- Customer Segmentation Using Machine Learning
- Face Land Marks Detection
- Car Prices Prediction
- Python GUI For Data Entry
- Generate Interactive Map
- Translate Using Python
- Exploratory Data Analysis on Global Terrorism
- Send Custom Email with Python
- Quiz Game with Python
- Calculator GUI with Python
Modules:
The Training is organized into the following modules:
PYTHON FOUNDATION
Python programming language is a popular and highly demanded skill. This training will help prepare learners to master Python programming language well enough to break into the world of AI/Machine Learning, Data Science, Data Analytics, Software Engineering and many more.
MODULE 1: Onboarding and Course Introduction
Understanding the difference between Data Analytics, Data Science, Machine Learning, Deep Learning, and Artificial Intelligence. System specification, Jupyter Notebook and GoogleColab Explained, Program Structure and answering all necessary questions to fix learners properly on their career track.
MODULE 2: Python Foundation
- Python Basics, Data Types, Containers, Operators
- If, else, elif, nested if statement, Loops and functions
- Advance Python
Learners will be given minimum of 5 Projects to work on within the period of 2 weeks and they are advised to submit before the deadline. These projects are applications of what they learnt in module 1 and 2.
DATA WRANGLING
This section of the training will introduce the student into the world of Data Collection, Exploratory Data Analysis, Data Cleaning, Feature Engineering, Data Preprocessing and more. After this training experience, students will be able to perfectly clean data, answer all Data Related Questions and derive insights for any company, organization and individuals that need their services.
Data Visualization is a method that uses static and interactive visuals to help people understand the details embedded in the data being collected. This Program will build student with necessary skills to choose the best chart to visualize data for best decision making.
MODULE 3: Data Wrangling
- NumPy
- Data Analysis with Pandas
Students will be given minimum of 3 Projects to work on within the period of 2 weeks and they are advised to submit before the deadline. The projects take the learners through the experience of practical application of what they learnt in Data Wrangling.
Module 4: Data Visualization
- Matplotlib Data Visualization
- Seaborn Data Visualization
- Plotly and Cufflinks Data Visualization
Students will be given minimum of 2 Projects to work on within the period of 1 week and they are advised to submit before the deadline. This projects are applications of what they learnt in the Data Visualization Class.
Module 5:
- Using GitHub to manage Data Analytics Projects
- Working on Projects
- Projects Presentation
- Building Professional Resume
- Sessions on how to Get Your First Data Analytics Job
CERTIFICATION
While we give you our Certification of Training, we also encourage you to attempt the following global certifications in Data Science with Python:
- IBM Data Science Professional Certificate
- OpenEDG Python Institute Certifications
- Microsoft Azure Data Science Certification
- Google Data Analytics Professional Certificate
In addition, if you are looking at enrolling for an undergraduate or post graduate degree in related course in any University overseas, this training prepares you ahead for first class degree.
COST:
From ₦150,000 if taken as a stand alone course.
IBM SPSS allows researchers to construct and evaluate statistical models utilizing sophisticated statistical methods.
At the end of this training learners will be able to efficiently use SPSS for simple to advanced statistical data analytics
Beginner Level:
- Introduction to SPSS
- Overview of SPSS software interface
- Understanding the data editor and variable view
- Data Handling
- Importing data into SPSS from different sources (e.g., Excel, CSV)
- Managing datasets (sorting, filtering, recoding variables)
- Descriptive Statistics
- Calculating measures of central tendency and dispersion (mean, median, mode, standard deviation)
- Generating frequency distributions and histograms
- Graphical Representation
- Creating different types of charts (bar charts, pie charts, histograms)
- Basic Inferential Statistics
- Conducting t-tests (independent and paired samples)
- Performing chi-square tests for categorical data
Intermediate Level:
- Regression Analysis
- Simple linear regression
- Multiple linear regression
- Interpreting regression output
- Analysis of Variance (ANOVA)
- One-way ANOVA
- Two-way ANOVA
- Post-hoc tests (Tukey’s HSD, Bonferroni)
- Factor Analysis
- Exploratory Factor Analysis (EFA)
- Confirmatory Factor Analysis (CFA)
- Non-Parametric Tests
- Mann-Whitney U test
- Wilcoxon signed-rank test
- Kruskal-Wallis test
- Data Manipulation Techniques
- Transforming variables (e.g., log transformation)
- Creating new variables
- Merging datasets
Advanced Level:
- Advanced Regression Techniques
- Logistic regression
- Hierarchical regression
- Moderation and mediation analysis
- Multivariate Analysis Techniques
- Discriminant analysis
- Cluster analysis
- Canonical correlation analysis
- Survival Analysis
- Kaplan-Meier survival analysis
- Cox proportional hazards model
- Time Series Analysis
- Descriptive time series analysis
- Forecasting using SPSS
- Customizing SPSS Output
- Formatting tables and charts
- Exporting results to other software (e.g., Microsoft Word, Excel)
Practical Applications:
- Case Studies and Practical Projects
- Applying SPSS to real-world datasets
- Working through case studies to solve specific research questions
COST:
From ₦100,000 if taken as a stand alone course.
Click the links below to read the testimonials directly on our Google Reviews.
- https://maps.app.goo.gl/1mAMqbQqTmg1op4u7
- https://maps.app.goo.gl/vntJdJZd8ybQs2Me9
- https://maps.app.goo.gl/mf16pTc2Jkd7PiYN9
- https://maps.app.goo.gl/s7Cw2ar5EUB94EbW7
- https://maps.app.goo.gl/uF9E8q5v9QfCNjBF8
- https://maps.app.goo.gl/cxdh329B7vRWVj8i9
- https://maps.app.goo.gl/NhWpmoFZjytyxXLJ7
- https://maps.app.goo.gl/8mCdMwK2darEiu1t9
Our Training Model
- We deliver the trainings through strategic combination of online and physical classes.
- Two (2) classes per week. The online classes we run are as effective as physical classes.
- You will be taught by Nigerians tutors who speak your English with a mix of our local dialect whenever it will help your learning
- All classes are recorded and made available to you… So you can watch the video of the classes unlimited times for better assimilation
- Your tutor will be easily reachable on WhatsApp and email
- Three months paid internship is guaranteed for the best 2 learners in every batch.
- All learners are encouraged to undertake 3 months internship immediately after their practical training for on-the-job experience.
FREQUENTLY ASKED QUESTIONS
Yes.
The practical trainings and projects you will do will help you gain requisite skills and experience to operate as a professional data analyst to local and international organisations.
No.
We want every learner to be able to concentrate on the classes without any distractions for the duration of the 4 months.
It’s going to be a very exciting 4 months learning experience for all participants.
We want every learner to be sure before enrolling with us as withdrawals from the training leaves us sad.
If you withdraw from the training after a full class for personal reasons, you will only be entitled to only 75% of your training fee.
If you withdraw from the training for personal reasons before attending any class, you will be entitled to only 90% of your training fee.
We do not give refund after delivering the training to you because the knowledge and skill imparted cannot be recalled.
However, we will work round the clock to ensure you achieve your good goals for enrolling in this program.
We do not promise that we will give you a job by ourselves after the training.
However, these are what we promise you:
- If you are one of the best 2 learners in this batch, we will immediately engage you in 3 months paid internship which can be reviewed to full time job based on your performance.
- In reality, there are hundreds of thousands of data analytics jobs you can access. We will train and guide you to apply for these jobs and get them.
- We will engage you with our clients’ projects based on your availability after your training with us.
Absolutely.
Arm yourself with practical data analytics skills and certifications so that you will not be stranded to menial jobs when you arrive at your dream country.
As a data analyst, if you live in Nigeria you can earn anything between ₦200,000 and ₦1,000,000 or even more depending on skill level and organization.
If overseas, you can earn as much as $5,000 – $10,000 monthly as well.
You can do a personal search on Google as well to verify this claim.
During your training with us, we will guide you to apply for these opportunities.
These might interest you...
- The first five (5) ladies to register for this course will enjoy 1 free make up session for their next owanbe (smiles…)
- The first five guys (men) to register will also enjoy a free movie ticket because all work and no play makes jack a dull boy.
- Every participant in this training will be trained on GitHub and you will start building your portfolio immediately so that you are ready to display your portfolio after the training.
- Every class is recorded and made available to you so that you can watch over and over to enhance your mastery of the training.
- Every learner will graduate from this training with high end skills on data analytics using Microsoft Excel, Power BI, SQL, Python and SPSS.
- Adequate training materials are available. You can also take your international certification exams after your training with us and you are guaranteed to be well prepared to pass the exams.
- Every participant would have made their training fee back within the first 1 – 3 months of training.
- We will mentor every learner to be gainfully and profitably engaged either remotely, physically or in an hybrid work environment within the first 1 – 3 months of completing the course. You will get data analytics job.
- The best 2 students get automatic three (3) months paid internship slot with us, after which the engagement could be reviewed to a permanent paid job.
Let's talk about your job prospects as a data analyst.
There are hundreds of thousands of data analytics job in the world today waiting for competent hands.
Have a look at some of them below:
As part of your data analytics training with us in Ibadan, we will show you how to harness these platforms to get your own cut of the data analytics job market.
So whether you are considering a career switch, a new remote job experience or you want to relocate overseas, this is the right course for you.
