Learn With iKay
A practical, beginner-friendly path through data literacy, Excel and SQL, with a real capstone project to show for it.
Built for absolute beginners who want a solid, practical foundation in data analysis, not a wall of theory.
You will start with how to think about data through data literacy and basic statistics, move into Excel for cleaning and analysing data, then take your first real steps into relational databases and SQL. Every week builds directly on the last, and the programme closes with a capstone project that puts everything together.
A step-by-step technical progression designed for maximum retention and immediate practical application.
Understanding data and sources of data, population and samples, sampling and sampling techniques, sampling distributions and outliers, and measures of central tendency.
Introduction to Excel, Excel formulas and data cleaning, data mining with lookup formulas, ETL with Power Query, Pivot Tables, and building dashboards with Excel.
Relational databases, database normalisation, basic SQL syntax, SELECT, FROM, WHERE, JOIN, ORDER BY and GROUP BY, aggregate functions, and CASE statements.
An end-to-end beginner project applying data cleaning, Excel and SQL to a real dataset, from question to a documented result.
Data literacy, Excel, and SQL, with a capstone project to show for it.