Work

Dealership dashboards first, plus samples from other industries.

Everything on this page is built on fictional data and labelled as a sample or demo. Client projects are kept confidential unless the client agrees to be named.

Car dealerships · sample build

Dealer profit dashboard

Margin per car, per make and per salesperson, stock ageing and lead sources in one Power BI report, with a weekly summary sent automatically. From $600.

See the dealer dashboardExample engagement
Car dealership profitability and inventory sample dashboard with fictional data
Car dealership profitability and inventorySample build · fictional data
Example engagements

Typical projects, start to finish

Common scenarios showing the problem, what gets built and the goal it aims for. These are examples, not client case studies, and the aims are targets rather than measured results.

Example engagement

Power BI and data analytics · Automotive retail

Dealership sales and stock reporting in Power BI

Replacing a monthly spreadsheet pack with one Power BI report for sales, gross profit and stock ageing across branches.

Read the example
Example engagement

n8n workflow automation · Service businesses and dealerships

Lead capture and routing with n8n

Bringing enquiries from web forms, WhatsApp, ads and missed calls into one workflow that replies fast and assigns an owner.

Read the example
Example engagement

Custom web app · Agencies and professional services

A client portal for approvals and files

Moving project updates, approvals, quotations and files out of email threads into one secure workspace per client.

Read the example
Interactive browser samples · fictional data

Power BI portfolio: 21 interactive samples

Open any card to try its own dashboard above. Change branch and period filters, select chart bars and inspect the matching records. These browser samples use fictional data to demonstrate reporting ideas; they are not live Power BI embeds.

  1. 01Interactive sample

    Car dealership profitability and inventory

    Compare gross profit by make, vehicles sold and stock receipts across branches.

    Open interactive dashboard
  2. 02Interactive sample

    Executive sales performance

    Compare product revenue, order counts and average order value across branches.

    Open interactive dashboard
  3. 03Interactive sample

    Inventory and stock ageing

    Find ageing stock, compare days on lot and inspect individual vehicles.

    Open interactive dashboard
  4. 04Interactive sample

    Financial P&L and cash flow

    Compare channel profit, operating costs and monthly cash movement.

    Open interactive dashboard
  5. 05Interactive sample

    Retail store performance

    Compare net sales, transactions and average basket value by product group.

    Open interactive dashboard
  6. 06Interactive sample

    E-commerce profitability

    Compare order revenue, returns, selling costs and contribution profit by channel.

    Open interactive dashboard
  7. 07Interactive sample

    Sales CRM analytics

    Inspect pipeline stages, deal values and won sales across branches.

    Open interactive dashboard
  8. 08Interactive sample

    HR and workforce analytics

    Compare paid hours, absence, overtime and payroll across departments.

    Open interactive dashboard
  9. 09Interactive sample

    Project profitability

    Inspect billed revenue, delivery costs and contribution by project type.

    Open interactive dashboard
  10. 10Interactive sample

    Operations and management KPIs

    Compare completed cases, on-time completion and net backlog added by process.

    Open interactive dashboard
  11. 11Interactive sample

    Overdue collections

    Prioritise outstanding invoices by overdue age and inspect payment balances.

    Open interactive dashboard
  12. 12Interactive sample

    Job profitability

    Compare billed labour and materials, direct costs and gross profit by job type.

    Open interactive dashboard
  13. 13Interactive sample

    Budget and forecasting

    Compare planned spending, actual costs and archived monthly forecasts.

    Open interactive dashboard
  14. 14Interactive sample

    Manufacturing waste

    Compare scrap weight, usable output and waste rates by production stage.

    Open interactive dashboard
  15. 15Interactive sample

    Construction project analytics

    Compare certified work, actual costs, budget variance and delivery margin.

    Open interactive dashboard
  16. 16Interactive sample

    Demand planning

    Compare forecast demand with actual demand and inspect forecast errors.

    Open interactive dashboard
  17. 17Interactive sample

    Multi-branch performance

    Compare revenue, branch contribution and margin across business lines and offices.

    Open interactive dashboard
  18. 18Interactive sample

    Marketing analytics

    Compare campaign spend, leads, acquired customers and cost per lead.

    Open interactive dashboard
  19. 19Interactive sample

    Field-service analytics

    Compare scheduled visits, completed work, first-time fixes and on-time visits.

    Open interactive dashboard
  20. 20Interactive sample

    Automated reporting from Business Central

    Reconcile fictional posted invoice totals with extracted reporting values.

    Open interactive dashboard
  21. 21Interactive sample

    Dashboard repair and rebuild toolkit

    Inspect validation rules, issues found, resolved exceptions and example repairs.

    Open interactive dashboard
Workflow patterns

n8n automations

Common workflows, described by the problem they solve and the tools involved. Each one is adapted to the apps and rules of the business using it.

Missed-call booking

  • n8n
  • Twilio
  • WhatsApp Cloud API
  • Google Calendar
Problem
A service business loses jobs when calls go unanswered during a job.
Workflow
A missed call triggers an SMS, the conversation continues on WhatsApp and a slot is booked into the calendar, with every lead logged to a sheet.

Product question assistant

  • n8n
  • Supabase
  • Vector search
  • LLM
Problem
Staff answer the same product questions by hand all day.
Workflow
The product catalogue is kept indexed and an assistant answers from it, showing the source, and hands over to a person when it is unsure.

Lead qualification

  • n8n
  • LLM
  • Google Sheets
Problem
Sales time goes on reading every inbound message to find real buyers.
Workflow
Incoming enquiries are scored against agreed rules and routed, so the team sees qualified leads first.

Attendance reporting

  • n8n
  • Google Sheets
Problem
Attendance is collected and checked by hand, and reports arrive late.
Workflow
Attendance is captured, validated and reported on a schedule.

Important email backup

  • n8n
  • Gmail
  • Google Drive
Problem
Critical emails from key senders exist in a single inbox.
Workflow
Emails from chosen senders are saved to Drive as PDFs automatically.

Daily news digest

  • n8n
  • RSS
  • LLM
Problem
Someone spends time each day scanning sites for relevant news.
Workflow
Articles are collected, scored for relevance and sent as a short daily summary.
Demo · fictional data

Client workspace

A project portal where a client can follow milestones, approve deliverables, review quotations and exchange files. The backend is Django and PostgreSQL with role-based access and automated browser tests.

The demo runs in your browser with a fictional project. Nothing you enter is sent anywhere.

Open the demo
  • Milestones with approval steps
  • Quotations the client can accept or question
  • Private file sharing per project
  • Conversation kept next to each deliverable
  • Invitation-only accounts