Data Analytics

Register Now
*
*
*

Data science

How did you hear about us

Occupation required

State of Residence *

About The Training

This training is organise by the Data Analytics team at Alabian Solutions Limited so it is a practical oriented training class. There will be a tutor lead section, hands-on session and a student capstone project. Every student will be expected to complete a project on Data Analytics using the tools learnt during the training. All graduand will benefit from free consultation service from Alabian Solutions Ltd.

  • Understand the Fundamentals of Statistics
  • Using Microsoft Excel for Data analysis
  • Understanding concepts of Python programing
  • Using Power BI for Visualizations, and Creating Dashboards
  • Learning the basics of SQL and how we can use it to analyze data
  • Data Capstone Project

Technologies To be Taught

Data science
Download Timetable
Weekend
  • Time: 10:0am - 6:pm
  • Date: 8th Jun'24 - 1st Sep'24
  • Price: ₦300,000.00

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

About Basic Statistics

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.

COURSE CURRICULUM FOR Basic Statistics

Introduction 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

About Excel

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.

COURSE CURRICULUM FOR Excel

  • 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

About Power BI

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.

COURSE CURRICULUM FOR POWER BI

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

ABOUT SQL

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.

COURSE CURRICULUM FOR SQL

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

Capstone Project

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

What programming languages do you teach?
As a tech company, we offer training and education in a variety of programming languages. Our curriculum is designed to equip individuals with the skills and knowledge needed to succeed in the technology industry. Some of the programming languages that we teach include but are not limited to: Python, Java, JavaScript, PHP and many others. We strive to provide a comprehensive and up-to-date education in programming languages to ensure that our students are prepared for success in their careers.
What level of programming experience is required to enroll in your courses?
We strive to provide education and training to individuals of all skill levels. Our courses are designed to be accessible to individuals with varying levels of programming experience, from beginners to advanced learners. Some of our courses are designed specifically for individuals who have no prior programming experience, while others are tailored to individuals who have some programming knowledge but wish to expand their skill set. Our instructors and support staff are available to assist students at every step of their learning journey, from selecting the appropriate course to providing guidance and feedback as they progress through the program.
What kind of job opportunities are available after completing your program?
Our goal is to prepare students for successful careers in software development. We work closely with industry partners to ensure that our curriculum is up-to-date and relevant to the job market, and we offer job placement services to help students find employment after completing our program. Graduates of our program have gone on to work for companies ranging from startups to Fortune 500 firms.
What is the duration of your courses?
The duration of our courses varies depending on the specific program, but most courses run for several months. We offer full-time and part-time options to accommodate students' schedules, and we work hard to ensure that our courses are intensive and immersive to maximize learning outcomes.
What is the format of your courses (e.g. online, in-person, hybrid)?
We offer a variety of course formats to meet the needs of different students. Some courses are held in-person at our campus, while others are offered online. We also offer hybrid courses that combine in-person and online instruction.
How much do your courses cost?
The cost of our courses varies depending on the program and format. We strive to keep our tuition affordable while still providing high-quality instruction and resources. We offer financial aid and scholarships to eligible students to help make our programs accessible to a wide range of learners.
Do you offer any job placement services?
Yes, we offer job placement services to our graduates. Our team works closely with industry partners to identify job opportunities and connect students with potential employers. We also offer resume reviews, interview preparation, and other resources to help our students succeed in their job searches.
Who are the instructors for your courses?
Our instructors are experienced professionals with backgrounds in software development, data science, and other technical fields. We carefully vet our instructors to ensure that they have both subject matter expertise and teaching skills, and we provide ongoing professional development to ensure that our instructors are up-to-date on the latest trends and technologies.
What kind of projects will students work on during the program?
Our courses are project-based, which means that students will work on real-world projects throughout the program. The projects are designed to give students hands-on experience with the concepts they are learning, and to help them build a portfolio of work that they can showcase to potential employers. Projects may include web development, app development, data analysis, and more.

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.

Olumuyiwa Sobayo

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.

Uwazie Benedict

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 Fun Facts

Some stuff are better explained in figures. Our scorecard

Happy Clients

0+

Successful Projects

0+

Students Trained

0+

Employees

0