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

N270,000

Early bird offer ends September 27th 

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

Join our growing community of 7,500+ alumni

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

Play Video

”I’m definitely rating the teaching and learning experience at Torilo Academy a 9/10”

Watch Story
Watch Story
Play Video

My tutor made learning really interesting and comprehensive taking his time to explain every step involved.

Watch Story
Watch Story
Play Video

“I needed something technical for design so I took the frontend development course”

Watch Story
Watch Story