Data Analysis
Turn raw data into clear insights. Learn Excel, SQL, Power BI and dashboards to support real business decisions.
About this course
This course introduces learners to the practical process of working with data—from organizing and cleaning raw datasets to analyzing information and communicating insights. Learners build foundational spreadsheet skills, progress into data cleaning, pivot-table analysis, charting and dashboard design, and develop SQL skills for querying and analyzing structured data. The course concludes with assessments and an exam.
Why this course
Data is increasingly used to support business, operational and strategic decision-making. This course equips learners with practical skills for transforming raw information into meaningful insights, reports and visualizations that support better decisions.
What you'll learn
- 01Organize and analyze data using spreadsheets
- 02Use formulas and functions including IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP and XLOOKUP
- 03Clean and prepare datasets for analysis
- 04Analyze data using PivotTables
- 05Create charts and dashboards
- 06Query databases using SQL
- 07Use filtering, aggregations, joins, subqueries and window functions
- 08Interpret and communicate data-driven insights
Career opportunities
- Data Analyst
- Junior Data Analyst
- Reporting Analyst
- Business Intelligence Support
- Data Operations roles
Understand what data analytics is, how organisations use data, and how analysts connect data to business decisions.