Learn With iKay
Progress from intermediate to advanced SQL, build interactive Power BI dashboards, and learn to analyse and visualise data with Python.
For learners who already have the basics and are ready to work with the tools and techniques used in real-world data analysis.
Across six weeks you will deepen your SQL with subqueries, CTEs, window functions and views, build interactive dashboards in Power BI including data modelling, transformation and DAX, then move into Python for analysis with NumPy, pandas, and visualisation using Matplotlib and Seaborn. The course closes with a capstone project.
A step-by-step technical progression designed for maximum retention and immediate practical application.
Subqueries, CTEs, window functions, and SQL views.
Data modelling, data transformation, data visualisation, and DAX.
Introduction to Python, data structures and algorithms, introduction to NumPy, pandas for data manipulation and cleaning, and Matplotlib and Seaborn for data visualisation.
An end-to-end advanced project bringing SQL, Power BI and Python together into one analysis, from raw data to a visual, defensible result.
Six weeks of SQL, Power BI and Python, with a capstone project to show for it.