2k+
Students
24
Live Sessions
Days
Hours
Minutes
Seconds
NEXT CLASS STARTS
● April 12, 2025
Do you love Figures and making meaning with figures?
Learning Data Analytics/Business Intelligence Analytics can also launch you into the world of Tech with without Coding
Data analytics is the process of using data to identify what a business needs to do to improve its bottom line. By building mathematical models from data, you can generate helpful insights to guide decisions and determine the right courses of action for a company or organization.
The average income of a Data analyst in the USA is between USD70,000-USD130,000 Per annum.
Learning how to use tools like TABLEAU, SQL, EXCEL are skills that big firms are looking for because these tools have proven to help firms generate outstanding results in terms of sales and profit optimization.
- Live Intructor-led classes
- 3 months of hand-on session
- Free extra 3 months of mentorship on completion
- Certificate on completion
- Replay available after each class
- Mini tasks after each class
- Group projects
Capstone projects - Interview preparation
- Career roadmap
Student Reviews
What Our Students Says
TRACK 1
- Microsoft Excel
- Structured Query Language (SQL)
- Tableau
TRACK 2
- Microsoft Excel
- Structured Query Language (SQL)
- Power B.I
Program details:
- Suitable for starters in Tech
- Class times :
- Saturdays: 3pm – 6pm (Nigerian time)
- Sundays: 3pm – 6pm
- Duration: 3 Months
- Replays available after each class
- Scroll down to see the tuition
- Free mentorship after the training
- Classes are done remotely. You don’t have to leave your location.
MICROSOFT EXCEL
WEEK 1
INTRODUCTION TO DATA CLEANING & MANIPULATION
- Navigating through a worksheet
- Data formats in Excel
- Fill, copy, insert, move, and delete data
- Range, Relative and Absolute Addressing
- Data cleaning and preparation with text functions
like Substitute, Mid, Concatenate, Trim, Proper,
Lower, Upper, Left and Right functions - Find and Replace texts
- Removing duplicates from data
- Split data with text-to-columns in Excel
- Sorting and Filtering data
- Aggregation Functions: SUM, COUNT,
AVERAGE, MAX, MIN, STDEV, and MEDIAN - Logical Functions and Comparison Operators
WEEK 2
PIVOT TABLES & CONDITIONAL ANALYSES
- Conditional Aggregation Functions: SUMIF,
COUNTIF - Errors reduction via Data Validation
- Conditional Formatting in Microsoft Excel
- Look up Functions: VLOOKUP, XLOOKUP,
INDEX, MATCH - Analyzing and summarizing data with Pivot
Table. - Solving business problems using Pivot Tables.
WEEK 3
Building a CHARTS & DASBOARDS WITH EXCEL
- Creation of Charts and Interpretation of these
charts to derive actionable insights - Combination of these charts to build an Analytical
dashboard. - Building Compelling Dashboards in Microsoft
Excel
EXCEL PROJECT
In this project, participants would
demonstrate all they have learnt in the last
three weeks by working on a MINI PROJECT
STRUCTURED QUERY LANGUAGE (SQL)
WEEK 4
INTRODUCTION TO SQL STATEMENTS
- Introduction to SQL
Why SQL?
Advantages of SQL over Microsoft
Excel - Data Types
- Entity Relationship Diagram
- Fundamentals of Data Definition Language (CREATE,
ALTER, DROP, TRUNCATE) - Data Manipulation Languages
(SELECT, INSERT, UPDATE,
DELETE) - Performing Basic Queries (SELECT
and FROM, DISTINCT, WHERE,
GROUP BY, ORDER BY, LIMIT)
WEEK 5
FILTERING & CONDITIONAL STATEMENTS IN SQL
- Load flat files into POSTGRES
database - Performing Basic Queries (SELECT
and FROM, DISTINCT, WHERE,
GROUP BY, ORDER BY, LIMIT) - Arithmetic and Logical Operators
(LIKE, IN, AND, NOT IN, OR,
BETWEEN) - Aggregate Functions
WEEK 6
UNDERTANDING THE USE OF JOINS
- JOINS in SQL
- Constraints
WEEK 7
WORKING WITH DATES IN SQL
- Working with dates in
- SQL Subquery
WEEK 8
MORE ON SUBQUERIES
- Working with Subqueries
- Work with previous data loaded into the POSTGRES
database and answer some questions using subquery. - More questions would be
given to the participants to solidify their knowledge of
subquery.
SQL MINI PROJECT
- Students will Load a new flat file into the POSTGRES database
- Answer questions which
would show solid
understanding of what has been taught in the past five weeks.
tableau for visualization
WEEK 9
INTRODUCTION TO TEBLEAU & BASIC CHARTS
- Introduction to tableau
- Different type of Tableau files
- Difference between All Tableaus software
- Exploring Tableau interface
- Data Cleaning with Tableau
- Connecting to Data Sources
- Creating a bar chart
- Creating a word cloud
- Creating a line chart
- Creating a heat map
- Creating a text table (crosstab)
- Creating a bubble chart
- Creating a tree map
WEEK 10
MORE ADVANCED CHARTS & INTERACTIVITY
- Creating a highlight table
- Creating an area chart
- Creating a pie chart
- Creating a stacked bar chart
- Creating a scatter plot
- Creating a histogram
- Creating a combo
- chart (dual axis chart)
- Creating a bullet chart
- Creating a bar in bar chart
- Creating a donut chart
- Creating a sparkline with indicators
- Creating a KPI text table
- Creating a waterfall chart
Creating a population pyramid - Creating a motion chart
- Creating a dynamic column/row trellis chart
- Creating a top/bottom N filter
- Comparing one to everything else
- Dynamically displaying dimensions
- Dynamically displaying and sorting measures
- Creating a custom date period filter
WEEK 11
Maps and Geospatial VISUALIZATION
- Introduction
- Adding data layers to map
- Creating custom territories
- Working with Web Map Service (WMS)
- Using path to display movement in map
- Mapping custom polygons
- Importing custom geocoding
- Using a custom image background
- Introduction
Creating a filter action
Creating a highlight action - Creating a URL action
- Creating an
- Infographic-like
- dashboard
- Creating story points
- Using Custom Shapes
WEEK 12
TABLEAU ANALYSIS
- Introduction
- Adding a constant line
- Adding a trend line
- Using a reference line
- Adding a reference band
- Performing cluster analysis
- Visualizing forecast
- Getting more information from your worksheet
CAPSTONE PROJECT
PLUS 3 MONTHS FREE MENTORSHIP PLAN
- Interview Preparation
- Professional Exam Guide
- LinkedIn Optimization
- CV Review
PLUS 2 MONTHS INTERNSHIP
POWER BI for visualization
WEEK 9
Power BI Fundamentals
- Power BI Interface Exploration
- Navigating the Power BI Desktop interface
- Understanding ribbon functionalities
- Data Loading and Connection
- Loading data into Power BI
- Connecting to various data sources
- Introduction to Power Query Editor
- Data transformation techniques using Power Query
WEEK 10
Data Modeling in Power BI
- Introduction to Data Modeling
- Basics of data modeling
- Importance of effective data modeling
- Dimensional Modeling Concepts
- Understanding Snowflake Schema and Star Schema
- Practical applications in Power BI
- Building a Data Model
- Creating relationships between tables
- Defining calculated columns and measures
WEEK 11
Advanced Power BI Features
- Understanding DAX Formulas
- DAX Calculations and Aggregations
- Time Intelligence Functions
- Building a Calendar Table for time analysi
WEEK 12
Data Visualization and Report Building
- Visualizing Data in Power BI
- Visual Elements Overview
- Creating Basic Visuals
– Line Chart
– Bar Chart
– Stacked Chart
– Pie Chart
– Donut Chart
– Waterfall Chart
– Matrix Table
– Chart Formatting Techniques
– Enhancing visuals with formatting options
– Customizing colors, labels, and axes - Using Filters Pane and Slicers
- Implementing drill-downs for interactivity
- Building a complete end-to-end solution (Report/ Dashboarding)
- Case studies and industry-specific application
CAPSTONE PROJECT
PLUS 3 MONTHS FREE MENTORSHIP PLAN
PLUS 2 MONTHS INTERNSHIP
