DataCrafter

A data-processing workbench that loads, models, aggregates and reports on data as one repeatable run.

Runs on Desktop, Web browser, Excel

DataCrafter is my main product: an automated workbench for analysing data and producing reports. You load your data, model it, classify it, aggregate it and publish it as one repeatable run. Then you put that run on a schedule and leave it.

These pictures show the month-end close for a made-up bakery with two shops. Every name in them is invented.

It has a desktop client, a web client and an Excel add-in. The releases are public and the source is private. The DataCrafter website has the full story.

The workspace. The tree on the left lists a made-up bakery's objects by type, and its month-end Workflow is open on the canvas.

The month-end Workflow. It builds the sales aggregation first, then the report.

A data model that joins each sale to its product's name, category and price.

The month-end sales report after its run, ready to download or print.