Get certified as a Data Analyst
Accelerate your career in data, and earn a data analysis certification teaching high-demand skills used by data analysts.
Next Start date
13th May, 2025
Extended registrations ends April 20th
Duration
12 weeks
Schedule
Twice Weekdays 10am - 2pm or Saturdays 10am - 5pm
Format
Physical or Online
What you will learn
- Introduction to Excel and its interface
- Data entry, editing, and formatting
- Basic calculations and formulas (SUM, AVERAGE, COUNT)
- Data visualisation (charts, tables, conditional formatting)
- Advanced formulas and functions (VLOOKUP, INDEX/MATCH, IF)
- Data analysis tools (PivotTables, Conditional Formatting, Filter)
- Data validation and error handling
- Excel best practices and shortcuts
- Introduction to Power BI and its interface
- Connecting to data sources (Excel, CSV, SQL)
- Creating reports and dashboards
- Basic visualisations (tables, charts, maps, slicers)
- Advanced visualisations (gauges, KPIs, scatter plots, matrices)
- Data modelling and DAX formulas (CALCULATE, FILTER, SUMMARISE)
- Creating measures and calculated columns
- Power BI best practices and performance optimization
- Introduction to SQL and its interface (SQL Server, MySQL)
- Basic queries (SELECT, FROM, WHERE, GROUP BY)
- Filtering and sorting data (AND, OR, NOT, IN)
- Joining tables (INNER JOIN, LEFT JOIN, RIGHT JOIN)
- Advanced SQL queries (SUBQUERIES, Common Table Expressions)
- Data manipulation (INSERT, UPDATE, DELETE, MERGE)
- Integrating SQL with Excel and Power BI (ODBC, OLE DB)
- Advanced data analysis techniques (data modelling, data mining, predictive analytics)
Throughout this course, you will be introduced to Artificial Intelligence (AI) concepts and tools that can enhance your productivity and workflow. You will learn how to leverage AI to automate tasks, gain insights, and improve overall efficiency.
Your instructor will guide you through the exploration of various AI tools and technologies, tailored to the specific needs and goals of the course. This hands-on experience will enable you to develop practical skills and apply AI solutions to real-world problems.
Data Analytics: Turning Data into Gold
Imagine you have a treasure chest filled with raw gems. They’re beautiful, but their true value is hidden until they’re cut and polished. Data analytics is like that skilled craftsman.
It’s the process of taking raw data – numbers, text, images, and more – and transforming it into something valuable: insights. These insights can help businesses make smarter decisions, improve efficiency, and uncover hidden opportunities.
For example:
A retailer might use data analytics to understand which products are selling well, who their customers are, and when they’re most likely to shop.
A healthcare provider could analyse patient data to identify trends in diseases, optimize treatment plans, and improve patient outcomes.
By learning data analytics, you’ll gain the ability to:
Ask the right questions of data
Use powerful tools to uncover patterns and trends
Tell a compelling story with data
Make data-driven decisions that impact real-world outcomes
In essence, data analytics is about turning information into action. It’s a skill that’s in high demand across industries, and it can open up exciting career opportunities.
Kickstart your career with our NEST Program
1-1 Mentorship
Everyone’s career transformation journey is different, so you’ll have 1-on-1 session from a dedicated career coach
Portfolio
Showcase your newfound skills and impress recruiters with a professional portfolio we help you create
Internship Placement
Gain valuable industry experience through an internship secured through our network of 100+ partner companies.
Interview Prep
Develop your interview skills with our comprehensive guide and preparation support & mock interviews
LinkedIn profile
Make a strong first impression on potential employers with help of our team. This includes a professional headshot for your LinkedIn profile
Craft A Winning CV
If your intention is to get a job, you get expert guidance on building and optimising a compelling CV to land interviews.
Next Digital Marketing Course
13th May, 2025
Our education advisors can talk you through the payment options available to you. Start your career in Data Analysis today.
Flexible payment plans available. Our team can help answer any of your questions about the course. Get in touch.
Accelerator
Intensive training + Portfolio
N350,000
N300,000
Early bird offer ends April 20th
Nest
Intensive training + portfolio + Internship placement + Interview prep & more
N450,000
N400,000
Early bird offer ends April 20th
Testimonials
What our clients say about us?
Become a Certified Data Analytics Professional
Earn an employer-recognized certificate and get a professional portfolio that will help you get hired.
0
K+
grads have chosen Torilo Academy to launch new careers or upskill to greater heights
0
since TA has been dedicated to transforming the careers and lives of our students
0
%
of graduates report positive career outcome and secure jobs within few months of graduation
Join our growing community of 7,500+ alumni
Alumni Stories
From Marketing Novice to Digital Strategist: How Torilo Academy's Course Landed Me My Dream Role
Through hands-on training at Torilo Academy, I mastered digital marketing essentials. The practical skills and portfolio building helped me secure a position as a Digital Strategist.
- Watch Story
From Marketing Novice to Digital Strategist: How Torilo Academy's Course Landed Me My Dream Role
Through hands-on training at Torilo Academy, I mastered digital marketing essentials. The practical skills and portfolio building helped me secure a position as a Digital Strategist.
- Watch Story
You're in good company. Our Alumni work with leading organisations.
FAQs
Torilo Academy's Data Analysis course provides comprehensive training in Excel, SQL. Excel+SQL is our primary teaching language. SQL is taught for database querying and data extraction
Yes, our curriculum includes dedicated modules on Power BI. You'll learn to create interactive dashboards, complex visualizations, and publish shareable reports.
Absolutely. Our curriculum includes comprehensive coverage of descriptive statistics, probability distributions, hypothesis testing, correlation analysis, regression models, and inferential statistics. You'll learn when and how to apply appropriate statistical methods to extract meaningful insights from data.
Our course is designed to be accessible to students with high school-level math knowledge. We provide supplementary resources and refresher modules covering essential concepts in algebra, probability, and basic calculus. Our approach focuses on practical application rather than theoretical derivations.
Absolutely! Data communication is a core component of our curriculum. You'll learn to design effective dashboards in Power BI, create automated reports, and develop data stories that effectively communicate insights to both technical and non-technical audiences.
Learn high-quality skills from home with our online courses. Watch recorded lessons whenever you want, join live sessions with teachers, and use tools to work with other students on projects. Our courses are designed so everyone can take part, including people with disabilities.
To enroll, click the apply button an complete the application form with your personal details. Upon completion, a personnel will contact you on how to proceed.
