Admissions open

Data Analysis

  • 8 WeeksDuration
  • PhysicalClass
  • WeekdayMons & Weds
  • 10am - 2pmTime

About Course

Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Program · 9 modules

What you will learn

  1. 01 DATA ANALYSIS WITH EXCEL
    • What is Data Analysis?
    • Excel Pro Tips for Power Users
    • Advanced Excel Formulas & Functions
    • Structuring Source Data for Analysis in Excel
    • Excel tables
    • Advantage of Excel tables over regular ranges
    • Filter, sort and see totals
    • Use tables to add columns to the existing data in the Excel table
    • Raw data structure in Excel
    • Design & formatting options
    • Sorting, filtering, & grouping tools
    • Calculated fields, items & values
    • Interactive Excel dashboards
  2. 02 PIVOT TABLES
    • Why Pivot Tables?
    • Create pivot tables
    • Data Analysis with Excel PivotTables
    • Use pivot tables and pivot charts to create dashboards
    • Connect multiple slicers to the pivot tables
    • Configuring pivot table layouts & styles
    • Pivot Table layouts & styles
    • Pivot Charts, slicers & timelines
  3. 03 USING PIVOT TABLES FOR ADVANCED CALCULATIONS
    • The full power of pivot tables
    • Filter pivot table data to achieve interesting subsets of the data
    • Apply calculated fields with pivot tables
    • Calculate profitability and find anomalies
  4. 04 AGGREGATE DATA
    • Use formulas to aggregate data
    • Aggregate data as an alternative to pivot tables
    • Flexible reporting layouts
    • Pivot charts using more than one table
  5. 05 DATA ANALYSIS IN EXCEL USING TOOLS
    • Set the lab environment up with Office applications
    • Data analysis in Excel using tools:
    • o pivot tables
      o pivot charts and slicers
    • Excel data models
    • Power Pivot add-in
    • DAX expressions for calculated columns and measures
  6. 06 QUERIES
    • What are the queries?
    • Power Query for Excel 2010 and 2013
    • Excel data model built from a single flat table
    • Import multiple tables from a SQL database
    • Create an Excel data model using imported data
    • Create a collated result with data from text-files and data from a SQL database
    • Up & running with Power BI Desktop
    • Publishing to Power BI Service
    • SQL database analysis for beginners
  7. 07 DATA FILTERS & MEASURES
    • How to establish measures to calculate each cell
    • Filter context for calculation
    • DAX functions
    • Enhanced queries to import data from a formatted Excel sheet
    • Queries beyond the standard user interface
  8. 08 DATA VISUALISATIONS
    • Data visualisations in Excel
    • Cube functions for year-over-year comparisons
    • Create timelines, hierarchies, and slicers
    • Excel working together with Power BI
    • Excel workbooks with Power BI service
    • Excel on the mobile platform
  9. 09 CASE STUDIES
    • capstone projects

Investment

Invest in a skill that pays for itself.

Training Fees

₦250,000

Full programme · 8 Weeks

Book a seat
Best value

Early Birds

₦212,500

Offer ends 16th October, 2026

Claim early-bird seat

Student's feedback

Loved by the people who matter most.

Real words from graduates now building products, shipping code and designing experiences.

My experience at Aledoy Academy has been wonderful since I joined as an intern. The company's focus on innovation and creativity, along with seamless collaboration between UI/UX designers, frontend, and backend developers, has been a great learning opportunity.
Delu Olasunmbo NatiqWorks at Aledoy Solutions Limited
Attending the UI/UX design course at Aledoy Academy was transformative. The vibrant, supportive environment and hands-on projects deepened my skills, covering everything from user research to prototyping. I highly recommend registering for the next bootcamp!
Gloria NwankwoWorks at Aledoy Solutions Limited
Aledoy Academy provides comprehensive training to prepare you for a tech career, covering technical skills, workplace dynamics, and team communication.
Alao OluwamurewaWorks at Nazza Tech
Aledoy Academy offers a supportive learning environment with up-to-date resources essential for practical courses. Knowledgeable and approachable instructors enhance the learning experience, making the academy an excellent choice for aspiring developers.
Alabi Olayinka RoqeebWorks at NYSC
Aledoy Academy offers a supportive learning environment with up-to-date resources essential for practical courses. Knowledgeable and approachable instructors enhance the learning experience, making the academy an excellent choice for aspiring developers.
Alabi Olayinka RoqeebWorks at NYSC
What sets Aledoy Academy apart is its top-tier instructors—industry experts with real-world experience. The well-structured, up-to-date curriculum ensures students gain the latest knowledge and skills.
Valerian Pedro AdimikeAledoy Alumnus
Aledoy Academy is fantastic! Expert instructors, engaging curriculum, and a supportive community. I've gained valuable skills and confidence. Highly recommend!
AnthonyAledoy Alumnus
I recently finished (Web Designer : Frontend ) at ( Aledoy Academy) and wanted to share my feedback. The school strengths include knowledge instructors, relevant course material and a conducive environment
Fatai Anifat KanyisolaWeb Designer · Frontend

FAQs

Questions, answered.

Everything you need to know before you join. Can't find your answer?

Ask us anything
01 Are Aledoy Academy’s courses physical or online classes?

We offer both physical and online classes. Please note that certain courses, such as Data Science/Analysis, are currently only available as physical classes.

02 Who should take this course?

This course is ideal for children aged 6-12 who are interested in learning how to code. It’s perfect for beginners with no prior coding experience.

03 What prerequisites do I need for this course?

No prior coding experience is necessary. Basic reading and math skills are helpful. A curiosity about technology and a willingness to learn are the most important prerequisites.

04 Will I receive a certificate upon completion?

Yes, upon successful completion, you will receive a certificate that you can add to your resume and LinkedIn profile to showcase your skills to potential employers.

05 What kind of support will my child have during the course?

Children will have access to instructor-led sessions, interactive lessons, a supportive community, and opportunities for 1:1 guidance and feedback on their projects.

06 What benefits does this course offer to my child?

The course helps children develop critical thinking, problem-solving, and logical reasoning skills. It fosters creativity, encourages teamwork, and provides a foundation for future learning in technology and computer science.

07 How do I enroll in the course?

To enroll, visit our course registration page, fill out the application form, and follow the instructions to complete your enrollment. If you have any questions, our support team is here to help.

Early Birds ₦212,500
Book a seat

Your next chapter

Your tech career starts right here in Okota.

Beginner-friendly, practical and project-based training crafted to make you job-ready.

How can we help you?