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
7th October 2024
Extended registrations ends Sept 27th
Duration
12 weeks
Schedule
Twice Weekdays 10am - 2pm
or
Saturdays 10am - 5pm
Format
Physical or Online
Next Start date
7th October 2024
Extended registrations ends Sept 27th
Duration
12 weeks
Format
Physical or Online
Schedule
Twice Weekdays 10am - 2pm
or
Saturdays 10am - 5pm
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)
Required Tools
What is Data Anaytics?
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
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
1-1 Mentorship
Everyone’s career transformation journey is different, so you’ll have 1-on-1 session from a dedicated career coach
LinkedIn profile
Make a strong first impression on potential employers with help of our team. This includes a professional headshot for your LinkedIn profile
Portfolio
Showcase your newfound skills and impress recruiters with a professional portfolio we help you create
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 Data Analytics Course
7 October 2024
Our education advisors can talk you through the payment options available to you. Start your career in Digital Marketing today.
Accelerator
Intensive training
N300,000
N280,000
Limited time offer ends September 27th
Accelerator
Intensive training + portfolio
N300,000
N280,000
Limited time offer ends September 27th
Nest
Intensive training + portfolio + Internship placement + Interview prep & more
N350,000
N320,000
Early bird ends August 30th
Flexible payment plans available. Our team can help answer any of your questions about the course. Get in touch.
Tola Adegbite
Data Analyst, Luminous
“I have a new job as a Data Analyst! I am deeply grateful for all the time and energy from the Torilo Academy team who helped me with my interview preparation .”
“I have a new job as a Data Analyst! I am deeply grateful for all the time and energy from the Torilo Academy team who helped me with my interview preparation .”
Tola Adegbite
Data Analyst, Luminous
Become a Certified Data Analytics Professional
Become a Certified Data Analytics Professional
Earn an employer-recognized certificate and get a professional portfolio that will help you get hired.
10k+
grads have chosen Torilo Academy to launch new careers or upskill to greater heights
2012
since TA has been dedicated to transforming the careers and lives of our students
85%
of graduates report positive career outcome and secure jobs within few months of graduation
You're in good company. Our Alumni work with leading organisations.
You're in good company. Our Alumni work with leading organisations.
Alumni Stories
Upcoming Course Start Date
| Start Date | Learning Mode | Path | Schedule | Length | Tuition Fee | Status |
|---|---|---|---|---|---|---|
| 7 October 2024 | Excel + Power BI | Accelerator | Weekdays or Weekends | 8 Weeks | N300,000 | Open |
Upcoming Course Starts Date
| Start Date | Learning Mode | Tuition Fee | Path | Schedule | Status | |
|---|---|---|---|---|---|---|
| 7 October 2024 | Excel + Power BI | Accelerator | Weekdays or Weekends | 8 Weeks | N300,000 | Open |
Alumni Stories
”I’m definitely rating the teaching and learning experience at Torilo Academy a 9/10”
My tutor made learning really interesting and comprehensive taking his time to explain every step involved.
“I needed something technical for design so I took the frontend development course”