Data Analytics

Days

Hours

Minutes

Seconds

NEXT CLASS STARTS

● October 12, 2024

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

2k+

Students

24

Live Sessions

Student Reviews

What Our Students Says

The class was very educative and insightful. I learned a lot within the 3weeks of the virtual class. Before now I did not know how to use Excel worksheets, for example: data cleaning, creating pivot tables and charts, and lots more. After this intensive, interactive, and intellectual virtual Excel class. I have the confidence to handle any work in Excel.

Modupe Joy Lebi

The Excel Class was well-organized, and the pace of the sessions was just right. The instructor was approachable and created a supportive atmosphere that encouraged active participation, was responsive to queries raised during the class, and she also encouraged participants to reach out for clarification outside of class hours. The course content covered a comprehensive range of Excel topics, starting from the fundamentals and progressing to more advanced features. Overall, the Class was a worthwhile investment of time and money.

Edith Onyebuchi Obidi

I really learned quite well from the class. The tutor is an ever-passionate one who always wants to carry everyone along and how she does that and still completes the syllabus is just awe-amazing. I really love her humble and meticulous efforts in making the class quite impactful.

Bolu Israel ADISALAWAL

It was a very interesting, communicative, and educative class. I applaud the ability of the tutor to carry everyone along and make sure everyone got it right. The class gave me an insight into new and fresher problem-solving solutions when it comes to Excel tasks.

NWAJI CHINONSO OBINNA

The Excel class was a very interesting one. I have a better knowledge of Microsoft Excel and was taught the use of Power Query to analyze data. The tutor was very patient and made sure everyone was on track with the course. The curriculum provides you with a good knowledge of the use of Excel for data analysis.

Adodo Olabanke Kehinde

Excellent! The tutor is versed and knowledgeable in Excel, very calm, and ensures every member of the class understands each concept with copious examples, class works, and assignments to drive home each point/topic. I will recommend Trevotech Academy to family, friends, and professional colleagues any day, any time.

Mba, Ndukwe Christopher

At the end of last year, I was very intentional about signing up for an advanced Excel class, to improve my Data Analytics skills. Thanks, to Trevotech Academy for bringing my dreams into reality. I enjoyed the online class because I had a tutor whose class was well-planned, and easy for me to follow. The assignments and project, were my best experience, as it was very beneficial to my learning process. Now I can confidently use the power query, and pivot table analyzer for analysis – Also, understand the purposes and steps for data cleaning. Thanks

Adara Ruth Oluwafunmilayo

I had no basic background or prior knowledge in tech and by diving into Data Analytics, Trevotech made learning easy. Our tutor was very great and she ensured all members of the class understood what was being taught before moving to the next topic no matter how long it took or how many times a particular question was being asked, she was really patient with everyone. She also gave relatable and live examples that made us understand better and she made sure she carried everyone along. I am glad I was able to participate in the class. It’s been a wonderful experience.

Dominic Precious Gold

I was one person that was scared to start the class, because I wasn’t a computer guru, plus, had no knowledge whatsoever of data analytics. But I thank God for giving me courage and always assuring me that I can do it. Our Excel instructor was so patient ooo … geez she’s patient and friendly, I wasn’t much of a talker or question asker in class, was more of a silent follower. Also grateful for the class recording which allows me to go back and play it whenever I’m lost. Geez 💃💃💃 I did it. All Glory to God.

ONYEACHIE MERCY OBIAGELI MAY

The Analytics class was beyond my expectations and very insightful. I gained alot in using excel for data cleaning and transformation using excel analytical functions and creating a report from the cleaned dataset. The tutor is very calm, experienced, and professional. She takes her time to explain each and every concept well so that every student will understand. This training has steered my data analytics career path with a strong foundation and also made the career path a promising one. Thank you Trevotech.

Abdul Basit Junaid

TRACK 1

Microsoft Excel
Structured Query Language (SQL)
Tableau

TRACK 2

Microsoft Excel
Structured Query Language (SQL)
Power B.I

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

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

24

Live Sessions

2k+

Students

N65,000 ($150)

Price

85%

Certified