Take a real business question end to end: definition, profile, query with reconciliation, chart, one-page write-up, and a review by a sceptic.
Choose a question someone in your business actually asks. Write the metric definition and get it agreed. Profile the data and write notes. Build the query with a reconciliation check. Produce one chart with the finding as its title and a caveat beneath. Write the one-page analysis and have a sceptical colleague review it; record their questions and revise.
From a business question to a chart with a caveat, with definitions, checks and a write-up that survives scrutiny.
Answer business questions from data with defined metrics, reconciled queries, honest charts and a one-page write-up.
Skills: Turning questions into metric definitions, Profiling and cleaning data, SQL and spreadsheet aggregation, Chart choice and annotation, Writing up with caveats
Build an inventory workbook with a products table, stock movements, reorder points, a dashboard and checks.
Build a workbook with a products table (SKU, name, cost, reorder point, lead time), a movements table (date, SKU, quantity in or out), a stock-on-hand summary with SUMIFS, reorder alerts with conditional formatting, a pivot dashboard by category, validation on all inputs and a checks block.
Structure, formulas, lookups, pivots and checks — learned by building the sheets a business actually needs.
Build spreadsheets with clean structure, correct formulas, working lookups and built-in checks, in Excel or Google Sheets.
Skills: Structuring data as tables, Core formulas and absolute references, Lookups and conditional aggregation, Pivot tables, Validation and error checks
Implement the money, customer, work and risk systems for a real small business and run them for one month.
For a real business (yours or a client's), set up lean bookkeeping with a close checklist, invoicing with a reminder ladder, a thirteen-week cash sheet, a CRM with five stages and a weekly review, one task list, a file structure, three procedures, tested backups, a password manager with offboarding, and a compliance calendar. Run everything for one month and write a one-page review.
Money, customers, work and risk: set up each system once, on a rhythm, so the business runs without heroics.
Set up bookkeeping, invoicing, a CRM, a task system and the risk basics for a small business, each on a weekly or monthly rhythm.
Skills: Monthly close and cash view, Invoicing and collections, CRM and pipeline discipline, Task and document systems, Backups, access and compliance basics
Design a three-step checkout with every state and all its copy, then run a usability test and revise.
Design a checkout flow: cart review, details, confirmation. Define each screen's job and primary action, build hierarchy in greyscale first, design all five states per screen, write all copy to the rules, then test with five people and revise the top three findings.
Build and deploy a SaaS with accounts, two plans with limits, subscription billing via webhooks, an admin customer view and the operational basics.
Ship a small SaaS: users and accounts, two plans with one enforced limit, checkout and webhook-driven activation with idempotency, a cancel-at-period-end flow, an admin customer screen with two audited actions, and the five operational services. Deploy it and take one real test payment.
The parts every SaaS needs — accounts, plans, billing, admin, operations — built in order on a small real product.
Build a multi-user SaaS with plans, subscription billing, an admin area and the operational basics, and deploy it.
Skills: Data modelling for accounts and plans, Subscription billing via webhooks, Entitlements and access control, Admin tooling, Operations: logs, backups, monitoring
Build a landing page with semantic structure, keyboard-accessible interaction, a fluid layout and measured performance.
Build a landing page for a product with a header, hero, feature grid, pricing cards, FAQ disclosures and a signup form. It must pass an accessibility audit, work by keyboard, adapt from 320px to 1600px with at most two media queries, and load with good paint metrics.
HTML that means something, CSS that holds up, and the browser behaviour every front-end depends on.
Build accessible, responsive pages with semantic HTML and modern CSS, and understand how the browser loads and renders them.
Skills: Semantic, accessible HTML, Modern layout with flexbox and grid, Responsive design without breakpoints everywhere, Forms and validation, Performance basics
Time 6h
Instant delivery after paymentLicence stated on every productRe-download anytime from My LibrarySecure checkout — Polar or FungiesNew products every week
Instant delivery after paymentLicence stated on every productRe-download anytime from My LibrarySecure checkout — Polar or FungiesNew products every week
