Note
AGI can't and won't automate everything Data Analysts do. AI will transform the profession, but the need for human insight and judgment ensures its continued relevance. Acquire the skills, make a lot of money, and take care of your family. Mathematicians and Scientists are at greater risk. 🤷♂️
The repository contains training materials for data analysts, organized by week:
- Week 1: Introduction to Data Analysis
- Week 2: Basic SELECT Statements
- Week 3: WHERE Clauses & Filtering
- Week 4: Sorting & Grouping Data
- Week 5: Fundamentals, data import, and basic visualisations (Hands-on Lab Session)
- Getting Started with Power BI
- Data Import and Connection
- Data Transformation with Power Query
- Creating Basic Visualisations
- Hands-on Lab Session 1
- Week 6: Advanced dashboards, reports, and publishing capabilities (Hands-on Lab Session)
- Advanced Visualisation Techniques
- Dashboard Design Principles
- Interactive Features and Filters
- Publishing and Sharing
- Hands-on Lab Session 2
- Week 7: Aggregate Functions
- Week 8: JOINs, Subqueries & CTEs
- Week 9: Data Types & Functions
- Week 10: Window Functions & Complex JOINs
- Week 11: Advanced JOINs & Set Operations
- Week 12: Stored Procedures & Views
Each week contains PDF materials covering the topics in detail. The materials are designed to be self-contained, with each week building on the concepts introduced in the previous week.
The dataset used for the training materials is the Northwind dataset, which is a well-known dataset in the field of data science. The dataset contains information about the Northwind Traders, including their customers, employees, products, and orders.
For database management and query execution, I recommend using DBeaver Community, a free and open-source universal database tool that supports multiple database systems including MySQL, PostgreSQL, SQLite, and more.
The training roadmap is available here.
SQL Training (10 weeks, 2 days):
- Weeks 1-4: Core fundamentals including database concepts, basic queries, filtering, and grouping
- Weeks 7-10: Intermediate skills covering aggregate functions, JOINs, subqueries, and data manipulation
- Weeks 11-12: Advanced techniques including window functions, complex JOINs, and stored procedures
Power BI and/or Tableau Training (2 weeks):
- Week 5: Fundamentals, data import, and basic visualisations
- Week 6: Advanced dashboards, reports, and publishing capabilities
There is an SQL cheatsheet page here.
- Becoming a Data Analyst
- Learning SQL
- SQL for Data Analysis
- Fundamentals of Data Visualization
- Data Visualization with Microsoft Power BI
- Learning Tableau 2025
- Storytelling with Data
You can continue improving your SQL skills with hands‑on practice on LeetCode, DataLemur, and HackerRank, which offer collections of database problems ranging from basic queries to advanced analytical challenges. These exercises will help you master SQL syntax, optimize query performance, and prepare for technical interviews.
Salary benchmarks from Robert Walters, along with current job listings from the Department for Work and Pensions, the Civil Service, EFinancialCareers, and LinkedIn:
- Data Analyst UK Average Salary: Robert Walters
- Data Analyst Jobs: DWP, Civil Service, EFinancialCareers, and LinkedIn
- Remote Data Analyst Jobs: WeWorkRemotely, Remote OK, and Remote Rocketship
This project is licensed under the Modified MIT License.
@misc{datafo2025,
author = {Oketunji, A.F.},
title = {Data Analyst Training},
year = 2025,
version = {0.3.0},
publisher = {Zenodo},
doi = {10.5281/zenodo.17170671},
url = {https://doi.org/10.5281/zenodo.17170671}
}(c) 2025 Finbarrs Oketunji. All Rights Reserved.