Online Tutorial for Data Analysis and Automation
A Python if else statement lets your program make decisions. Python evaluates a condition, runs one block of code when it is True and a different block when it is False. With elif you can test several conditions in order, and by nesting one if inside another you can model more detailed business rules. The […]
This Python introduction explains what Python is, what people build with it and why it is the most useful first programming language for anyone who works with data, spreadsheets or reports. Python is a free, readable, general-purpose language, and in this course you will learn it side by side with an AI assistant that explains […]
Learn SQL UNION and UNION ALL to stack results from two queries into one list. Syntax, worked examples with output, duplicates vs speed, and common mistakes.
Track 13 concrete KPIs on one page – MTD and YTD achievement, traffic lights, twelve-month trends and vs prior year. Formula-driven Google Sheets, no add-ons, no subscription.
A formula-driven Google Sheets KPI dashboard for insulation contractors: 14 trade KPIs, a month picker, MTD and YTD traffic lights, a twelve-month trend page and a KPI group roll-up.
A walkthrough of the Locksmith Business KPI Scorecard in Google Sheets: 10 trade KPIs across 5 groups, MTD/YTD toggles, direction-aware traffic lights, a per-KPI trend page, and the two build defects we found when we opened the workbook.
A formula-driven optical store appointment calendar in Google Sheets: 6 tabs, Annual, Monthly and Daily views, 100 verified sample bookings, 18 appointment types and 18 rooms – and no customer or prescription column, by design.
A one-page Fertility & Ovulation Tracker in Google Sheets: 14 columns, 5 of them calculated, a Fertile Days Logged card and a BBT curve. A personal record-keeping template – not a medical device, not contraception and not medical advice.
A Google Sheets period and cycle log: one cycle per row across 16 columns, seven of them calculated, with an average cycle length card and four charts. A personal record-keeping template – not a medical device and not medical advice.
A six-page Google Sheets reporting dashboard for physiotherapy and rehabilitation clinics – sessions, revenue, recovery rate and satisfaction by clinician, treatment line, condition and clinic site. Not an EHR, no live link to a practice system.