01 Module 01
Analytics Foundations and Business Thinking Build the mindset and vocabulary of a modern analyst while learning how data supports decisions.
The role of data analysts in business and product teams Structured thinking, business questions, and problem framing Data ecosystems, ethics, privacy, and stakeholder communication Practical Output A business-question brief and stakeholder requirements template
02 Module 02
Spreadsheets, Data Collection, and Organisation Start working with raw data using spreadsheet workflows that prepare you for real analysis tasks.
Spreadsheet formulas, sorting, filtering, validation, and lookup functions Data collection planning, file organisation, and naming standards Data quality checks and documentation habits Practical Output A cleaned spreadsheet workbook with analysis-ready tabs
03 Module 03
Databases, SQL, and Data Preparation Move from spreadsheet-level work into querying structured datasets with confidence.
Database concepts, tables, relationships, and schemas Core SQL queries for filtering, joins, aggregations, and calculated fields Preparing datasets for exploration and analysis Practical Output A SQL exercise pack with saved business queries
04 Module 04
Data Cleaning, Analysis, and Insight Development Use repeatable workflows to clean messy data, analyse trends, and draw valid conclusions.
Data cleaning standards, integrity checks, and transformation logic Descriptive analysis, trend spotting, and KPI interpretation Turning observations into useful business insights Practical Output An analysis workbook with documented findings and assumptions
05 Module 05
Dashboards, Visualisation, and Storytelling Learn how to communicate results clearly with charts, dashboards, and concise narratives.
Chart selection, visual hierarchy, and dashboard design principles Building reports in BI tools and presenting core KPIs Presenting findings to technical and non-technical audiences Practical Output A dashboard and insight presentation deck
06 Module 06
Case Study, Portfolio, and Career Readiness Bring everything together in a professional case study and prepare to present your work confidently.
Case study structure and portfolio writing Documenting methodology, decisions, and recommendations Interview-ready storytelling for analytics roles Practical Output A portfolio-ready analytics capstone project
