Skip to content
DAN Analytics

360 · Power BI · Power Apps · Power Automate · n8n · AI

Noordlicht 360

From the first enquiry to payment.

One customer journey across lead, quote, project, technician, stock, invoice, cashflow and the board.

Demo on fictional data — never customer data.

Noordlicht Techniek, Installation and service. The same customer Duinstede Techniek runs from lead to the board. Changes stay in this browser session.

  1. 01

    Lead management

    Score 80, route senior.

  2. 02

    Quote to project

    OFF-0087 is already PRJ-0087.

  3. 03

    Project profitability

    PRJ-0087: expected margin 14.8%.

  4. 04

    Field service app

    2 open work orders.

  5. 05

    Inventory and procurement

    MAT-0087: 12 on hand.

  6. 06

    Invoice processing

    INK-4418 blocked.

  7. 07

    Cashflow and financial risk

    Lowest balance €15,662,936.

  8. 08

    Executive business intelligence

    September margin 24.8%.

SQL
SELECT lead.id, quote.id, project.id, work_order.id, invoice.id
FROM customer
JOIN lead ON lead.customer_id = customer.id
JOIN quote ON quote.lead_id = lead.id
JOIN project ON project.quote_id = quote.id
JOIN work_order ON work_order.project_id = project.id
JOIN invoice ON invoice.project_id = project.id;

Curious what this could do for your business?