Skip to main content

Oxtech Academy

Oxtech Academy Wave 2.0 enrollment is now open. Apply today and take the next step towards building your tech career.

Menu
Log in
Register
Log in

Certificate

Data Analysis
Course completed by

Barriyah Olatunji

Course
Data Analysis
Instructor
Oxtech Academy Data Analysis
Issued
November 8, 2026
Certificate ID
1e18e06a5603f043
Skills
Understand the complete data analysis workflow from raw data to actionable insights. Navigate and work confidently with Microsoft Excel and Google Sheets. Use essential spreadsheet formulas including SUM, AVERAGE, COUNT, IF, VLOOKUP, and XLOOKUP. Sort, filter, organise, and validate large datasets efficiently. Clean messy datasets by removing duplicates, correcting inconsistencies, and handling missing values. Create Pivot Tables to summarise and analyse large amounts of information. Build professional charts and interactive dashboards for data visualisation. Learn the fundamentals of SQL and understand how databases work. Write SQL queries using SELECT, WHERE, ORDER BY, GROUP BY, COUNT, and JOIN. Turn analytical findings into clear business reports and presentations. Apply analytical thinking to solve real-world business problems. Build a portfolio-ready capstone project using real datasets.