Data Analytics

JOIN OUR DATA ANALYTICS WITH EXCEL, SQL & POWER BI CLASS

This course will allow you to learn data analysis, teach you how to work with industry tools and complex datasets, and help you develop essential data skills and knowledge. To complete this data course and showcase your new skills, you’ll complete a detailed, final portfolio project based on a data set of your choosing.

MODE OF DELIVERY: PHYSICAL CLASS - ANTHONY, ONLINE CLASS - ZOOM

COURSE FEE: PHYSICAL CLASS: N80,000, VIRTUAL CLASS: N45,000

Microsoft Excel
-Getting Started: Named Ranges, Cell Locking and Referencing
-Data Analysis: Logical Functions, Arithmetic Functions, VLOOKUP, HLOOKUP, INDEX-MATCH
-Conditional Aggregation: COUNT, COUNTA, COUNTIF, SUMIF, COUNTBLANK, NESTEDIF, COUNTIFS, SUMIFS, SUMPRODUCT, AVERAGEIF
-Data, Manipulation with Power Query
-Data Modelling with Power Pivot
-Dashboarding

Microsoft Power BI
-Getting Started with Power BI workspace and Environment
-Connect Power BI to Multiple Sources: Excel & CSV, Web, SQL Server, Other Sources
-Using Column, line & Pie Chart to understand business trends
-Visualizing Data with Treemaps, Funnel Charts, Scattered Chart, Card, and KPI Card
-Using Tables, and Matrix Tables
-Importing Custom Visuals from Marketplace
-Maps, and other visuals
-Using Data Analysis Expression (DAX) Language: Creating Dynamic Date Tables, Calculated Columns and Measures
-Data Transformation (Cleaning)
-Data Modelling
-Creating Reports and Dashboards

Structured Query Language (SQL)
-Introduction to SQL
-Introduction to Relational Database Management System (RDBMS)
-Creating Databases, Tables and Columns
-Retrieving, Updating, Inserting and Deleting Data
-Sorting and Filtering Data, Advanced Filtering
-Summarizing and Grouping Data
-Joining and Managing Tables
-Using Subqueries and Views

image

Expert Peoples

At vero eos et accusamus etiusto odio praesentium.

image

First Growing Process

At vero eos et accusamus etiusto odio praesentium.

image

Creative Ideas

At vero eos et accusamus etiusto odio praesentium.

Why Choose Us

We Worked With Reputed Companies in The World

We donec pulvinar magna id leoersi pellentesque impered dignissim rhoncus euismod euismod eros vitae.

Software Development

Web Development

SEO Analysis

Cyber Security

Data Science

JOIN OUR DATA SCIENCE & MACHINE LEARNING WITH PYTHON

In the course, learn the foundations of data science and perform an end-to-end statistical analysis, learn to make data-driven predictions, and present results in a data visualization.

MODE OF DELIVERY: PHYSICAL CLASS - ANTHONY, ONLINE CLASS - ZOOM

COURSE FEE: PHYSICAL CLASS: N80,000, VIRTUAL CLASS: N45,000

Introduction to Python for Data Science
-Python Programming Basics
-Manipulating Data with NumPy
-Data Wrangling with Pandas
-Data Visualization with Matplotlib and Seaborn
-Web Scrapping for Data Collection
-Making Inference from Data

Building Machine Learning Models
-Supervised Techniques:
i. EDA and Data Pre-processing
ii. Linear Regression
iii. Logistic Regression
iv. Feature Engineering
v. Improving Model with Feature Selection Technique
-Other Machine Learning Algorithms

Capstone Project

100 k
Happy Clients
250 +
Projects Done
60 +
Expert People
250 +
Portfolios
FULL STACK

(FULL STACK): EXCEL, SQL, POWER BI, DATA SCIENCE & MACHINE LEARNING WITH PY

MODE OF DELIVERY: PHYSICAL CLASS - ANTHONY, ONLINE CLASS - ZOOM

COURSE FEE: PHYSICAL CLASS: N160,000, VIRTUAL CLASS: N80,000

This is a combination of all courses in Package 1 and Package 2 with the same curriculum