Data Analytics Notes
(Google Sheets · SQL · Python · Apps Script)

Intro

These are my structured notes from learning data analytics using Google Sheets, SQL, Python, and Apps Script.
Built from real practice to understand how data actually works.

Built from real practice while developing my own system — read how I approached learning data analytics while building my own app → here

clean workspace with laptop showing spreadsheet, notebook and pen in warm natural light
clean workspace with laptop showing spreadsheet, notebook and pen in warm natural light

Start Here

Learn Python fundamentals before applying automation and data workflows.

Khan Academy Python fundamentals course page showing beginner programming lessons and exercises for learning Python basicsKhan Academy Python fundamentals course page showing beginner programming lessons and exercises for learning Python basics

Google Sheets

(Data & Automation)

Core tools I use daily to clean, structure, and automate data workflows.

  • QUERY function

  • Named ranges

  • Dropdown logic

  • Data 1,

  • Apps Script 1,

Laptop showing Google Sheets dashboard with charts and data tables, representing data analysis and spreadsheet automation
Laptop showing Google Sheets dashboard with charts and data tables, representing data analysis and spreadsheet automation

SQL

Foundations for querying, filtering, and organizing structured data.

  • SELECT

  • WHERE

  • ORDER BY

Laptop displaying SQL query with data table results on screen, representing structured data analysis and database querying
Laptop displaying SQL query with data table results on screen, representing structured data analysis and database querying

Python

Building logic, automation, and data handling from scratch.

Pinterest Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40

Python programming workspace with laptop displaying code, notebook and pen on desk, representing data automation & scripting
Python programming workspace with laptop displaying code, notebook and pen on desk, representing data automation & scripting

Why this page exists

I’m building the Belle app myself.
This page documents everything I learn—clearly, in one place.

Download the Belle App -> Here

Custom app interface showing data automation and workflow design, representing real-world application of analytics skills
Custom app interface showing data automation and workflow design, representing real-world application of analytics skills

How to use this page

Start with Python basics, then move into Google Sheets and SQL.
Each section builds on the previous.