2k+
2k+
2k+
Students
24
24
24
Live Sessions
Days
Hours
Minutes
Seconds
NEXT CLASS STARTS
● January 11, 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
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
24
24
Live Sessions
2k+
2k+
2k+
Students
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
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.