Skip to content

README.md

Latest commit

 

History

History
105 lines (76 loc) · 5.99 KB

README.md

File metadata and controls

105 lines (76 loc) · 5.99 KB

Data Analyst Training

Release License

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.

Dataset

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.

Database Management Tools

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.

DataGrip is now free for non-commercial use. 😊

Roadmap

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

SQL Cheatsheet

There is an SQL cheatsheet page here.

Useful Books

Practice

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.

Job Market

Salary benchmarks from Robert Walters, along with current job listings from the Department for Work and Pensions, the Civil Service, EFinancialCareers, and LinkedIn:

License

This project is licensed under the Modified MIT License.

Citation

@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}
}

Copyright

(c) 2025 Finbarrs Oketunji. All Rights Reserved.