Training Details

12 Weeks
10am to 1pm (Morning)

Weekdays (Mon, Wed, Fri) Weekends (Sat)

1st Floor, Nikky Africana Plaza, 70c Allen Avenue, Obasa Close, Opp UBA, Ikeja, Lagos
N300,000
2348029704730

Data Analytics Training In Lagos Nigeria

Our data analytics training is beginner-friendly, practical and project-based .It is designed to help participants gain mastery of different technologies and tools that are used to analyze data in organizations. It is tailored to help you gain real-world experience that can get you a job and grow your career.

Who should attend

  • Those who are switching career to tech industry.
  • Those planning to travel abroad and seeking hands-on skill that can make them relevant.
  • Those in managerial position seeking to have knowledge of how data is cleaned, analyzed and visualization.
  • Those who studied computer science, mathematics, statistics and other related courses seeking to acquire skill with real-world project to be able to get a job and be relevant to organizations.

Technologies covered

Learning outcomes

Real-World Project

Work on different data such as sales data, start-up data, student record, covid-19, advertising data, olympic and more

Data analyst role

Ability to work as a data analyst and engage in data cleaning, data wrangling, data manipulation and visualization

Version control

Learn how to use online repository like git and GitHub for source code management for collaboration and saving your works

Career Positioning

CV review, interview preparation, LinkedIn profile update, job alert within our alumni community, and mentorship

Course Curriculum

Introduction to data analytics

      Introduction and onboarding

  • Introduction to data analytics
  • Data analytics vs data science vs data engineering
  • Data analysis process
  • Installation and setup

Excel for data analysis

  • 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

Working with data and lists

  • How to freeze rows
  • How to quickly sort using one column in Excel
  • How to sort using more than one column
  • How to filter a list
  • How to filter with multiple criteria

References

  • Relative references
  • Absolute reference
  • Creating a reference to another sheet

Conditional formatting in Excel

  • Using the if function
  • How to create a formula with nested IFs

Working with Text

  • How to join values with an ampersand
  • How to join cell values with concatenating
  • How to clean text with trim
  • How to count characters
  • Changing case in Excel
  • How to extract text

Dates and time

  • How to work with date in excel
  • Formatting date
  • Calculating the number of days
  • Calculating years and months

Statistics

  • How to use the COUNT function
  • Using the COUNTIF function
  • Using the SUM function
  • How to use SUMIF
  • How to use the AVERAGE function
  • How to calculate the minimum and maximum value
  • How to rank value with the RANK function

Lookups

  • How to use VLOOKUP
  • How to use VLOOKUP for approximate matches
  • VLOOKUP vs Nested IFs
  • Using the index function
  • Using the match function
  • How to use HLOOKUP

Pivot table

  • What is a pivot table
  • How to create a pivot table
  • How to add fields to pivot tables
  • How to rearrange fields in the pivot table
  • How to adjust aggregate function in pivot table
  • Styling pivot table
  • How to add slicers
  • How to filter pivot table
  • How to sort pivot table
  • How to group pivot table
  • How to create a pivot chart
  • How to change chart type
  • How to work with pivot chart options
  • How to filter pivot chart
  • Pivot chart

Task: Analyzing sales data with excel

Visualizing the data for better
communication with stakeholders using pivot tables and pivot chart

SQL for database manipulation

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

Personal task: Design a database for a school management system

Key takeaway: Ability to design and create a database

Implement the database design

Perform CRUD operation

Power BI for Business Intelligence

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

Data Analysis Expressions (DAX)

  • 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

Project: Designing of sales dashboard

Key takeaway: Ability to understand how to use PowerBI to learn data, build relationships between tables and create visualization and reports

Python Programming

Introduction to python

  • What is Python?
  • Installing Python
  • Setting up VSCode for Python
  • Python fundamentals
  • Python Syntax
  • Variables
  • Input and output
  • comments

Data types

  • Strings
  • String properties
  • Indexing and slicing
  • String methods
  • Numbers
  • Boolean

Python lists

  • Introduction to Lists
  • Sorting a List
  • Slicing a List:
  • Unpacking a List
  • Iterating over a List
  • Finding Index of an Element: index()

Tuple

  • Indexing tuple elements
  • Unpacking Tuples
  • Type Conversion

Python dictionary

  • Introduction to dictionary
  • Nested dictionary
  • Dictionary methods
  • Indexing dictionary items
  • Updating dictionary items
  • Dictionary Comprehension

Python Set

  • Set Comprehension
  • Union of Sets
  • Intersection of Sets
  • Difference between Sets
  • Symmetric Difference of Sets
  • Subset
  • Superset
  • Disjoint Sets

Operators

  • Arithmetic Operators
  • Assignment operators
  • Comparison Operators
  • Membership
  • Control flow
  • if…elif
  • type Conversion

Loops

  • for Loop
  • while Loop
  • For in loop

Python Functions

  • Inbuilt function
  • User-defined function
  • Default Parameters
  • Keyword Arguments
  • Lambda Expressions
  • Function Docstrings
  • The *args Parameters
  • The **kwargs Parameters
  • Transform List Elements: map()
  • Filtering List Elements: filter()
  • Reducing List Elements: reduce()
  • List Comprehensions

Working with Files

  • Reading a Text File
  • Writing to a Text File
  • Creating a Text File

Modules

  • Benefits of using modules
  • Python packages
  • Using the OS module

Personal tasks: Create a function that can process data

Key takeaway: Understand python programming and be able to translate concepts into pseudo-code and program which can be applied to analyze data

 

Numpy for array manipulation

Introduction

  • What is Numpy?
  • Array Creation
  • Indexing numpy array
  • Slicing in NumPy
  • Data Type Objects
  • Iterating Over Array
  • Mathematical Function
  • String Operations
  • Sorting, Searching and Counting

Random sampling

  • randint() function
  • random_sample()
  • function
  • ranf() function

Statistical Function

  • Minimum and
  • maximum value
  • Percentile
  • Median
  • Standard deviation
  • Variance
  • Average

Key takeaway: Understand how to work with multi-dimensional array and integrate numpy with other libraries like Pandas and Matplotlib

Pandas for data analytics

Introduction to Pandas

  • Importing pandas libary
  • Creating a Pandas Series
  • Creating a Pandas DataFrame

Pandas Methods

  • Describe and info methods
  • Head and tail method
  • Apply method
  • Unique and nunique method
  • Sorting values
  • Counting values
  • Replacing values
  • Deleting values
  • Largest and lowest values

Manipulating data

  • Dealing with Rows and Columns in Pandas 
  • Extracting rows
  • Indexing and Selecting Data
  • Conditional filtering
  • Handling missing data

 

Grouping and merging data

  • Grouping data
  • Merging data
  • Joining data
  • Concatenating data
  • Working with date and time
  • Working with text data

Reading files

  • Read CSV files
  • Reading excel file
  • Reading HTML tables from websites

Project: Analyzing covid19 data

Key takeaway: Ability to clean and analyze different types of data

Matplotlib for visualization

Introduction

  • Overview of Matplotlib
  • Importing matplotlib
  • Plotting your first graph

Adjusting graph

  • Figure Class
  • Axes Class
  • Setting Limits and Tick labels
  • Multiple Plots
  • What is a Legend?

 

Creating Different Types of Plots

  • Line Graph
  • Bar chart
  • Histograms
  • Scatter Plot
  • Pie Chart
  • 3D Plots
  • Customizing Plots

Project: Grade student results and plot a graph to visualize it.

Takeaway: Being able to plot and style different types of graph

Seaborn for visualization

Introduction

  • Importing seaborn
  • Using Seaborn with Matplotlib
  • Plotting graph using seaborn

Customizing Seaborn Plots

  • Changing Figure Aesthetic
  • Changing the figure Size
  • Scaling the plots
  • Color Palette
  • Multiple plots with Seaborn

Creating Different Types of Plots

Relational Plots

  • Scatter Plot
  • Line Plot

Categorical Plots

  • Bar Plot
  • Count Plot
  • Box Plot

 

Distribution Plots

  • Histogram
  • Distplot
  • Pairplot
  • Rugplot

Regression Plots

  • lmplot
  • Regplot

Matrix Plots

  • Heatmap

Key takeaway: Understand how to create and style plots using seaborn

Testimonials

EXCELLENT
56 reviews on
Emmanuel Ireke
Emmanuel Ireke
A beginner friendly place where everything is broken down bit by bit and I will highly recommend for anyone who is trying to enhance or about to start his/her tech journey.
Vincent Edokpayi
Vincent Edokpayi
Best training ever! With the highly experienced and patient teachers, they carefully nurtured me as I went from 0 to 100. The classes are interactive, flexible and exciting in a very cosy environment. I’ll recommend it to anyone out there who desires to learn a new skill, grow in their career or just become more knowledgeable; notwithstanding your present skill level or having none at all, Tech365 would guide you carefully step-by-step into that you dream of becoming. Well done Tech365!
Deborah Babarinsa
Deborah Babarinsa
Very knowledgeable and experienced tutor.
Akinyele Aje
Akinyele Aje
Tech 365 is a very excellent place to learn. The location is wonderful, the lecture rooms have cool ambience and the tutors are very experienced, knowledgeable and friendly. I came in as a pharmacist and I came out as a techie!
Dosa Comfort
Dosa Comfort
It’s a place where you’ll get value for your money, good teaching with project to improve your learning
ogbonna chidiogo
ogbonna chidiogo
Training in Tech 365 is one of the best decisions I've made so far. Did Data Analytics, I was a novice to Excel or anything Tech( I was unsure I would catch up with the lessons) but my first day in class was Wow!! And the rest like the say is history 😃 Kudos to the Mr Wale.
Bello Ololade
Bello Ololade
My training at tech365 is the best. The teaching, mentoring and everything is top notch!

Our students work at

Frequently Asked Questions

Yes we accept installment payment. You can discuss with our team members on available payment options.

No prior programming experience is required. However, you need to know how to operate the computer efficiently. Our training approach is beginner friendly, and we work on several real world projects to help our student have deeper understanding of each module. 

People prefer Tech365 because our training are:

  • Project-based training
  • Job recommendation
  • World-class support
  • Up-to-date curriculum
  • Career guidance and mentoring
  • Access to support community
  • Certificate of completion
  • Flexible payment plan
  • Flexible timing

 

Our training is

  • Globally relevant
  • Beginner friendly
  • Futuristic
  • Relevant across industries
  • In high demand
  • Financially rewarding

We do not guarantee job. However, we do refer our students for jobs as different organization do reach out to us to hire our students. Some of our students have gotten job through this process.

Yes, we offer weekend classes for those who can’t attend weekdays due to their job or other reasons

Our training schedule are around January, May and September. You can talk to one of our representative for more information.

Yes our training is physical at Ikeja, Lagos. However, those outside Nigeria or living far away can join us online via zoom. The experience is similar.

Yes. In fact, this is our strength. We are committed to supporting our students to ensure they succeed.

Yes, it is recommended to come with your own laptop as it will help you to practice whatever you are learning. However, we provide laptop that can be used only within our premises if need be.

Yes, we provide internet access to our students.

Depending on your budget, Core i7, 16 GB ram with SSD is best.

However, core i3 or i5 with 4gb or 8gb ram HDD will also work fine.

It can be HP, DELL, Mac or any other brand.

Our Pricing Plans

Best Data Science/Analytics Training

You can choose available options below based on your need.

Data Analytics
N300,000
  • Complete data analytics
Data Science
N500,000
  • Complete Data Analytics
  • Machine Learning
Artificial Intelligence
N1,000,000
  • Complete Data analytics
  • Machine Learning
  • Artificial Intelligence

tech365-logo

Tech365 is a register ICT Training company in Lagos Nigeria. Over the years, we have training several students in Canada, UK, United States, Nigeria and more

Contact Us
error: Content is protected !!