fbpx
Days
Hours
Minutes
Seconds
NEXT CLASS STARTS

● April 13, 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
image

2k+

2k+

2k+

Students

image

24

24

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings
THE CURRICULUM IS FOUND BELOW:

You can Pick One Track from the Two Below

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
image

24

24

24

Live Sessions

image

2k+

2k+

2k+

Students

image

85%

85%

85%

Certified

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings

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

  • Ratings