Get certified as a Data Analyst (Excel + Power BI)

Accelerate your career in data, and earn a data analysis certification teaching high-demand skills used by data analysts.

What you will learn:

  • Understanding and working with Cell
  • Understanding and working with Column
  • Understanding and working with Row
  • Mastering Copy Paste
  • Mastering Autofill
  • Intelligent navigation with Excel data
  • Basic Mathematical functions
  • Unlocking Keyboard Shortcuts with Master-key
  • Homework: Entering 10 records in Excel
  • Best Practices – Entering data in Excel
  • Removing Duplicates
  • Removing Spaces
  • Spell check
  • Replacing blank cells
  • Using proper fonts
  • Extracting Substring or part of data
  • Merging data in cells
  • Text to columns
  • Data sorting
  • Transpose data
  • Flash fill
  • Vlookup
  • Hlookup
  • Index and match
  • Consolidate
  • Append data with power query
  • Manipulating dates – Date | Month | Year
  • Manipulate dates – Name of The Year | Name of The Month
  • Manipulating dates – Day of the week | Week of the year
  • Day of the Year
  • Quarter of the Year
  • Dynamic TODAY | Tomorrow | Yesterday
  • Calculating Age
  • Adding conditional columns based on IF
    • NESTED IF
    • IF OR
    • IF OR Multiple Column
    • IF OR OR OR Practice
    • IF AND
    • IF AND AND AND Practice
  • Freeze Panes
  • Filters and advance filters
  • Conditional Formatting
    • Subtotals
    • COUNTIF
    • COUNTIFS
    • SUMIF
    • SUMIFS
  • Introduction to Data Analysis and Data
    Summary by a parameter
  • Adding parameters with drill down and drill up
  • Breaking down information by Column
  • Filtering the data in reports
  • Understanding Value Field Settings
  • Working with Dates in rows
  • Grouping example
  • Compiling data on one sheet
    • Slicers
    • Timeline
    • Adding Calculated Fields
    • Calculated Fields – Why this approach is better
  • Introduction and first chart
  • Exploring the chart options further
  • Compiling data on one sheet
  • Adding timeline (time slicer) on dashboard
  • Adding and adjusting slicers
  • Adding trendline charts
  • Understanding Relational Data
  • Adding Power Pivot to Excel
  • Adding data to Data Model
  • Data Modelling
  • Power Pivot
  • How to install Power BI
  • Course Introduction and objectives
  • Overview of Power BI
    Understand Power BI licenses
  • Get a dataset
  • Understand Power BI interface
  • Quiz
  • Understand data Importation and the Data View
  • Overview of the Data View in Power BI
  • Import a File from Excel
  • Use Get Data to Connect to Data Sources
  • Try a Sample Dataset from Power BI Desktop
  • Jump Into the Journey: Import Your Data!
  • Clean and Transform Data
  • Access the Power Query Editor
  • Overview of the Applied Steps List in Power Query Editor
  • Execute Basic Math Operations to a Column
  • Replace Errors in a Column
  • Jump Into the Journey: Clean Your Data
  • Quiz
  • Understand Text Visualization Types
  • Create a Visualization Card
  • Create a Table Visualization
  • Create a KPI Chart
  • Create a Key
  • Influencers Chart
  • Jump Into the Journey: Practice Creating Text Visualizations!
  • Lesson: Intro to Chart Visualizations
  • Create a Scatter Chart
  • Create a Waterfall Chart
  • Create a Funnel Chart
  • Create a Ribbon Chart
  • Jump Into the Journey: Practice Creating Chart Visualizations!
  • Lesson: Filters, Slicers, and Data Drilling
  • Create a Slicer
  • Analyze Your Visualization
  • Drill Down and Drill Up in a Visualization
  • Jump Into the Journey: Practice Using Filters and Slicers!
  • Quiz
  • Introduction to Data Modeling, Report View, and Visualizations
  • View Relationships in the Model View
  • Edit or Remove Relationships
  • Add a New Relationship Between Tables and Columns
  • Jump Into the Journey: Practice Data Modeling
  • Understand the Report View
  • Overview of the Report View in Power BI
  • Add a Visualization
  • Overview of Format
  • Features for Visualizations
  • Change the Visualization Type
  • Jump Into the Journey: Get to Know the Report View
  • Create measures and calculated columns
  • Quiz

Required Tools

Accelerator

Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.

  • 8 weeks training
  • In-person or online
  • Milestone projects
  • Portfolio building

Nest

Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.

  • 8 weeks training
  • In-person or online
  • Milestone projects
  • Portfolio building

What you will learn:

  • Understanding and working with Cell
  • Understanding and working with Column
  • Understanding and working with Row
  • Mastering Copy Paste
  • Mastering Autofill
  • Intelligent navigation with Excel data
  • Basic Mathematical functions
  • Unlocking Keyboard Shortcuts with Master-key
  • Homework: Entering 10 records in Excel
  • Best Practices – Entering data in Excel
  • Removing Duplicates
  • Removing Spaces
  • Spell check
  • Replacing blank cells
  • Using proper fonts
  • Extracting Substring or part of data
  • Merging data in cells
  • Text to columns
  • Data sorting
  • Transpose data
  • Flash fill
  • Vlookup
  • Hlookup
  • Index and match
  • Consolidate
  • Append data with power query
  • Manipulating dates – Date | Month | Year
  • Manipulate dates – Name of The Year | Name of The Month
  • Manipulating dates – Day of the week | Week of the year
  • Day of the Year
  • Quarter of the Year
  • Dynamic TODAY | Tomorrow | Yesterday
  • Calculating Age
  • Adding conditional columns based on IF
    • NESTED IF
    • IF OR
    • IF OR Multiple Column
    • IF OR OR OR Practice
    • IF AND
    • IF AND AND AND Practice
  • Freeze Panes
  • Filters and advance filters
  • Conditional Formatting
    • Subtotals
    • COUNTIF
    • COUNTIFS
    • SUMIF
    • SUMIFS
  • Introduction to Data Analysis and Data
    Summary by a parameter
  • Adding parameters with drill down and drill up
  • Breaking down information by Column
  • Filtering the data in reports
  • Understanding Value Field Settings
  • Working with Dates in rows
  • Grouping example
  • Compiling data on one sheet
    • Slicers
    • Timeline
    • Adding Calculated Fields
    • Calculated Fields – Why this approach is better
  • Introduction and first chart
  • Exploring the chart options further
  • Compiling data on one sheet
  • Adding timeline (time slicer) on dashboard
  • Adding and adjusting slicers
  • Adding trendline charts
  • Understanding Relational Data
  • Adding Power Pivot to Excel
  • Adding data to Data Model
  • Data Modelling
  • Power Pivot
  • How to install Power BI
  • Course Introduction and objectives
  • Overview of Power BI
    Understand Power BI licenses
  • Get a dataset
  • Understand Power BI interface
  • Quiz
  • Understand data Importation and the Data View
  • Overview of the Data View in Power BI
  • Import a File from Excel
  • Use Get Data to Connect to Data Sources
  • Try a Sample Dataset from Power BI Desktop
  • Jump Into the Journey: Import Your Data!
  • Clean and Transform Data
  • Access the Power Query Editor
  • Overview of the Applied Steps List in Power Query Editor
  • Execute Basic Math Operations to a Column
  • Replace Errors in a Column
  • Jump Into the Journey: Clean Your Data
  • Quiz
  • Understand Text Visualization Types
  • Create a Visualization Card
  • Create a Table Visualization
  • Create a KPI Chart
  • Create a Key
  • Influencers Chart
  • Jump Into the Journey: Practice Creating Text Visualizations!
  • Lesson: Intro to Chart Visualizations
  • Create a Scatter Chart
  • Create a Waterfall Chart
  • Create a Funnel Chart
  • Create a Ribbon Chart
  • Jump Into the Journey: Practice Creating Chart Visualizations!
  • Lesson: Filters, Slicers, and Data Drilling
  • Create a Slicer
  • Analyze Your Visualization
  • Drill Down and Drill Up in a Visualization
  • Jump Into the Journey: Practice Using Filters and Slicers!
  • Quiz
  • Introduction to Data Modeling, Report View, and Visualizations
  • View Relationships in the Model View
  • Edit or Remove Relationships
  • Add a New Relationship Between Tables and Columns
  • Jump Into the Journey: Practice Data Modeling
  • Understand the Report View
  • Overview of the Report View in Power BI
  • Add a Visualization
  • Overview of Format
  • Features for Visualizations
  • Change the Visualization Type
  • Jump Into the Journey: Get to Know the Report View
  • Create measures and calculated columns
  • Quiz

Required Tools

Accelerator

Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.

  • 4 weeks training
  • In-person or online
  • Milestone projects
  • Portfolio building

Nest

Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.

  • 4 weeks training
  • In-person or online
  • Milestone projects
  • Portfolio building

Upcoming Course Start Date

Location Start Date Learning Mode Path Schedule Length Tuition Fee Status
Ikeja June 5, 2024 Excel + Power BI Accelerator Weekdays or Weekends 8 Weeks N150,000 Open
Online June 5, 2024 Excel + Power BI Accelerator Weekdays or Weekends 8 Weeks N150,000 Open

Upcoming Course Starts Date

Location Start Date Learning Mode Tuition Fee Path Schedule Status
Ikeja June 5, 2024 Excel + Power BI N150,000 Accelerator
8 Weeks
Weekdays or Weekends Open
Online June 5, 2024 Excel + Power BI N150,000 Accelerator
8 Weeks
Weekdays or Weekends Open

Pay As You Learn

Focus on gaining practical skills and worry less about your payments.

Passionate about a course?

We know how much you yearn to learn and advance to the next level of what the future holds for you. We have provided you with resources that makes persuading either your boss of relative easier. Take charge of your future now!

Creative and Collaborative Learning

Experience engaging and interactive sessions. At Torilo Academy training center, we leverage both group and individual sessions to ensure that our students practise working in teams and independently to build usable solutions.

Where Torilo grads. get hired

Where Torilo grads. get hired

Ready to start your Tech, Design,
Digital or Data journey?

Take the next step and speak to our admissions team. Book a 15-minute chat to ask questions and learn more about our programs.

Ready to start your Tech, Design, Digital or Data journey?

Take the next step and speak to our admissions team. Book a 15-minute chat to ask questions and learn
more about our programs.

Torilo Academy | Training Centre In Lagos, Nigeria

4.8Out of 5 stars

Overall rating out of 111 Google reviews

Femi Fatunla
a month ago

Torilo Academy has been a great experience. Their practical approach to learning is excellent. The Tutors ensure all students are carried along.

Badmus Miftau
a month ago

This is the best Tech center so far

akinlembola ade
a month ago

the experience has actually been electric

oluwole tobiloba
a month ago