Data Analysis for Aspiring Data Analysts
Welcome to your data analysis journey! Whether you are a complete beginner just starting out, or a professional looking to add data skills to your toolkit — this programme is built for you. You will master the tools that real data analysts use every day, with clear step-by-step guidance and practical, hands-on exercises.
What Is Data Analysis?
Data Analysis is the process of inspecting, cleaning, transforming, and modelling data with the goal of discovering useful information, drawing conclusions, and supporting decision-making. In today’s world, every industry — from finance and healthcare to retail and government — relies on data analysts to make sense of the information they collect.
As a data analyst, you will be the person who bridges the gap between raw data and meaningful business insights. You will gather data, clean it, analyse it, build dashboards, and present your findings to stakeholders in a way that drives real action.
The End-to-End Data Analysis Process
Our curriculum follows the complete, industry-standard data analysis workflow — from raw data to boardroom presentations:
| Stage | Description | Tool |
|---|---|---|
| 📥 1. Data Collection | Identify data sources, import datasets, and understand the structure of your data | Excel |
| 🧹 2. Data Cleaning | Handle missing values, fix inconsistencies, remove duplicates, and format data correctly | Excel / SQL |
| 🔍 3. Data Analysis | Write queries, aggregate data, join tables, and extract the insights that answer business questions | SQL |
| 📊 4. Data Visualisation | Build compelling charts, interactive dashboards, and KPI reports that communicate findings clearly | Tableau / Power BI |
| 🎤 5. Stakeholder Presentation | Structure your narrative, present data-driven recommendations, and handle questions from stakeholders | Tableau / Power BI |
Your Course Path 📚
Work through these courses in sequence. Each one builds on the previous, taking you from spreadsheet fundamentals all the way to advanced business intelligence dashboards.
📊 Course 1: Microsoft Excel for Beginners
The foundation of every data analyst’s toolkit. You will learn:
- Spreadsheet navigation and data entry best practices
- Essential formulas: SUM, AVERAGE, IF, VLOOKUP, and more
- Data cleaning techniques: removing duplicates, fixing formats
- Pivot Tables for quick data summarisation
- Charts and visualisations in Excel
🗄️ Course 2: SQL for Beginners
Take your analysis to the next level with Structured Query Language. You will learn:
- Understanding relational databases and tables
- Writing SELECT, WHERE, GROUP BY, and JOIN queries
- Aggregating and summarising large datasets efficiently
- Filtering and sorting data to answer specific business questions
- Combining multiple tables for deeper analysis
📈 Course 3: Tableau — Data Visualisation
Transform your data into powerful visual stories. You will learn:
- Connecting Tableau to data sources (Excel, SQL, CSV)
- Building bar charts, line graphs, maps, and scatter plots
- Designing interactive dashboards for stakeholders
- Using filters, parameters, and calculated fields
- Presenting data insights clearly and professionally
📉 Course 4: Power BI for Beginners
Master Microsoft’s leading business intelligence tool. You will learn:
- Importing and transforming data with Power Query
- Building relationships between data tables
- Writing DAX formulas for advanced calculations
- Creating professional reports and dashboards
- Publishing and sharing reports with your organisation
Begin with Course 1: Excel and progress through each course at your own pace. By the time you complete all four courses, you will have the full skill set of a professional data analyst — ready to tackle real-world challenges and present data-driven insights with confidence.
Data Cruise 