About The Training
This program is designed for people who want practical, employable data skills not certificates that gather dust. Learn how to analyze real-world data,
build dashboards decision-makers trust, and turn numbers into business insights that actually matter. This is not theory.
This is how data analysts actually work. No prior coding experience is required. If you can think logically and you’re willing to learn, you are just fine.
You should apply if you are:
- A working professional looking to upskill or switch careers
- A business owner or manager who wants to make data-driven decisions
- A graduate or NYSC member seeking in-demand tech skills
- A non-tech professional ready to move into analytics
- A developer or analyst who wants to level up with modern tools and AI
Why Learn at with Alabian Solutions?
The curriculum at Alabian Solutions is a practical and industry-Focused. Our curriculum is designed around how data analytics is used in real companies today, not outdated academic theory. At Alabian Solutions, we don’t just teach syntax we train you to think and build like a software engineer. Our JavaScript development training combines solid fundamentals, real projects, and the new frontier of AI-assisted coding. You'll graduate not just knowing how to code, but knowing how to use AI to code smarter.
-
Data Fundamentals & Thinking Like an Analyst
Understanding data types, data quality, and analytical thinking -
Excel & Spreadsheet Analytics
Real-world data analysis, reporting, and automation -
SQL for Data Analysis
Querying, joining, and extracting insights from databases -
Python for Data Analytics
Data manipulation with Pandas & NumPy Data visualization and exploratory analysis -
Statistics for Business Decisions
Interpreting data correctly and avoiding wrong conclusions -
Data Visualization & Business Intelligence
Power BI / Tableau dashboards and storytelling with data -
AI-Assisted Analytics
Using ChatGPT and modern AI tools to accelerate analysis and insight generation
Technologies To be Taught
Requirement
-
No coding experiences
No previous coding (programing) skill set is required for this training, as the training can be taken by somebody with zero skill in programming. The training will be intensive for participants leaving them with skill they can use to develop world class software. -
Good computer usage skill
All students are expected to know how to navigate their way on a computer system. They should know how to create files, save files in a folder and be very familiar with their computer keyboard. -
Hardware Requirement
Students are expected to come for the training with a laptop that has Wireless LAN, minimum 2Gb RAM, minimum free space on hard disk should be 50Gb minimum Dual Core CPU and USB port. -
Software Requirement
All students are expected to have PDF reader and Microsoft office installed in their system. Any other software need will be provided by us.
Training Venue
Alabian Solutions Limited Infinite Grace Plaza Plot 4 Oyetubo Street off Obafemi Awolowo Way Ikeja Lagos
We are going back to the basics of statistics as we have in our secondary school days, for you to be a Data Analyst that knows his salt your statistics basics needs to be taken care of. Here we get to know the meaning of mean, mode, median variance, standard deviation etc and how we can use it in real life to solve problems.
WHY Basic Statistics
basic statistics are important because they provide a set of tools and techniques for analyzing data, making inferences, and drawing conclusions. They are essential in a wide range of fields, from business and economics to psychology and medicine, and are critical for informed decision making and research.
REGISTER NOWIntroduction to Statistics
- What is Staatistics
- Measures of Central Tendency
- Measure of variability
- Statistics with Python
- Measuring Variance
- Normal Distribution
- Binomial Distribution
- Poisson Discrete Distribution
- Bernoulli Distribution
- P-value
- Correlation
It is clear that a data analyst needs variety of tools to carry out his work, Excel is one of the tools we will be using in this training, we will apply some of the concepts we learned in Statistics and see how we can use Excel functions to carry out some operations, we look at how to create Charts, Vlookup, Sorting & Filtering etc.
WHY Excel
Excel provides a flexible and efficient way to manage large sets of data. It allows users to store and organize data in tables, and to sort and filter that data to find the information they need. Excel also provides tools for data cleaning and formatting, which can save time and improve data quality.
Excel provides a wide range of tools for analyzing data, including basic statistical functions, charting tools, and pivot tables. These tools make it easy to explore data, identify patterns and trends, and create visualizations that help communicate findings to others.
- Introduction
- Reading CSV, tabbed and fixed column data
- Data manipulation
Formula basics
- What is a cell reference?
- What is a formula?
- What is a function?
- How to enter a formula with cell references
- How to use addition in a formula
- How to use subtraction in a formula
- How to use multiplication in a formula
- How to use division in a formula
- How to use exponents in a formula
- The order of operations
Formatting
- How to use number formatting in Excel
- How to use currency formatting in Excel
- How to use percentage formatting in Excel
- How to use fraction formatting in Excel
Excel chart
- How to create a basic chart
- How to move and resize a chart in Excel
- How to create a standalone chart
- How to edit and add to chart data
- How to add a title and legend to a chart
We will be using Power BI to create interactive charts and Dashboard, Power BI harness people's natural ability to spot visual patterns quickly, the drag and drop feature for quickly performing calculations is spot on.
WHY Power BI
Power BI allows users to connect to a wide range of data sources, including databases, spreadsheets, and cloud-based applications. This makes it easy to combine data from multiple sources and create a unified view of an organization's data.
Power BI includes tools for creating data models, which allow users to define relationships between data tables and create hierarchies and calculations. This makes it easy to perform complex analyses and create custom metrics and measures.
Introduction to PowerBI
- What is PowerBI?
- Installing Power BI
- Desktop
- Adjusting Settings in
- PowerBI
Connecting and shaping data
- Types of Data Connectors
- The Power BI Query Editor (Power Query)
- Basic Table Transformations
- Working with Numerical Values
- Working with Date & Time Tools
- Generating Index & Conditional Columns
- Grouping & Aggregating Records
- Merging Queries in
- Power BI Desktop
- Appending Queries
- Configuring Data Source Settings
- Defining Hierarchies
- Power BI Data Connection Best Practices
Table relationship and data model
- What is a “Data Model”?
- Principles of Database Normalization
- Understanding Data Tables vs. Lookup Tables
- Understanding Table
- Relationships vs. Merged Tables
- Creating Table Relationships
- Managing & Editing Table Relationships
- Connecting Multiple Data Tables
- Hiding Fields from the
- Power BI Report View
- Power BI Data Model Best Practices
Introduction
- DAX Calculated Columns
- DAX Measures
- Adding Columns & DAX Measures
- Implicit vs. Explicit DAX Measures
- Filter Context Examples in Power BI
- Understanding DAX Syntax & Operators
- Common DAX Function
- Date & Time Functions
- Conditional & Logical Functions (IF/AND/OR)
- Common Text Functions
- Joining Data with RELATED
- Basic Math & Stats Functions
- COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
- CALCULATE, ALL & FILTER
- Iterator Functions (SUMX, RANKX)
- DAX Best Practices
Data Visualization and report
- Introduction
- Exploring the “Report”
- Adding Simple Objects to the Power BI Report Canvas
- Inserting Basic Charts & Visuals in Power BI
- Conditional Formatting
- Report Formatting Options
- Report Filtering Options
- Exploring Data with Matrix Visuals
- Filtering with Date Slicers
- Inserting Text Cards
- Visualizing Geospatial Data with Maps
- Visualizing Data with Treemaps
- Artificial Intelligence in PowerBI
We will be using SQL to manipulate data in this training, many organisations uses Database softwares like Oracle, MySQL, PostGres etc to manage thier data, SQL is a language used to manipulate data in any of these softwares, we will be looking at concepts like Tables, CRUD operations, Transaction, etc.
WHY SQL
SQL provides a simple and efficient way to retrieve data from databases. Users can write queries that specify the data they want to retrieve, and SQL will return the results in a structured format.
SQL provides robust security features, including user authentication and encryption, to protect sensitive data stored in databases.
Introduction to SQL
- What is SQL?
- Create Table Statement
- ALTER TABLE Statements
- Rename Columns of a Table
- Modify Column DataType
- Drop Columns from Table
- Rename Tables
- Drop Tables
- What is Null Value?
DML Statements
- Insert Statement
- Update Statement
- Delete Statement
- Truncate Statement
- Merge Statement
SQL Functions
- AVG()
- COUNT()
- MAX()
- MIN()
- SUM()
Select Queries
- Select Query
- WHERE Clause
- GROUP BY Clause
- HAVING Clause
- ORDER BY Clause
SQL Joins
- Inner Join
- Left Join
- Right Join
- SQL Operators
- BETWEEN
- IN
- LIKE
- INTERSECT
- MINUS
- UNION
- DISTINCT
- ANY, SOME
- ALL
SQL Operators
- BETWEEN
- IN
- LIKE
- INTERSECT
- MINUS
- UNION
- DISTINCT
Project: Design a database for a social network
Participants will be given a project to carryout, all the tools and concepts taught during the training will be put to use in this project A certificate will be issued upon the completion of the project
Frequently Asked Question
ex-student
We are proud to showcase the progress of our ex-student
Instructors
Our faculty is made of guys that are enthusiastic about teaching and assisting participant to understand technology been taught. Each of the instructors are working on real life project for clients and also developing a pet project by the side.
Instructor
Muyiwa has a bachelor's degree in Mathematics and post graduate in Data Science and business analytics from the university of Texas.
He has a passion for data mining, Analytics and visualization. Besides his passion for data wrangling he is an excellent communicator and loves to guide students through their learning journey.
Instructor
Benedict is currently the Training Director/Web Developer at Alabian Solutions Limited he is a Web Developer with an analytical mindset, he is down to earth in teaching and believes in offering an interactive learning experience using real life scenario to make class more interesting.
Some organisations that have business relationship with us.
