Data Analysis with Excel, SQL and Power BI
A compact, hands-on course in the three tools employers list most for data analyst jobs. In Excel you'll use formulas, XLOOKUP, PivotTables and data cleaning. In SQL you'll query real tables with SELECT, WHERE, GROUP BY, HAVING, JOINs, CASE, subqueries, CTEs and window functions, writing and checking every query on your phone in the course's built-in SQL practice. In Power BI you'll prepare data with Power Query, build a star-schema model, write DAX measures and design a dashboard. The course follows the skills measured by the Microsoft PL-300 exam (prepare, model, visualise and analyse, manage and secure) and uses African business examples: pharmacy sales, mobile money agents, school records. Video lessons come from Alex The Analyst's popular free courses. Finish with a full analysis project on a real-style dataset, ending in a dashboard and a one-page insights memo.