Data cleanup
Extraction, error identification and verification, with Tablify™ doing the rules-first extraction. We get your source data fit for purpose before anything is built on top of it.
More on data cleanupFrom messy data to meaningful information.
CostCraft™ cleans, restructures and reports on the operational data Canadian organizations already have — field records, lab results, supplier files, CRM exports, cost reports.
-
1Records arrive from sites, suppliers and systems.
-
2Exports and spreadsheets never quite match.
-
3One clean table. Anything that can't be fixed safely is set aside, with a reason.
-
4Every value is checked against its target.
-
5Same method, every month.
How we work
- Canada-wide
- Rules first, exceptions shown
- Free 30-minute data review
Four services. One standard.
Every engagement produces data and reporting your team can rely on and your reviewers can follow.
Transformation
Restructuring data into the form your reporting actually needs. When the shape of what you have doesn't match what you have to produce.
More on transformation
Reporting
Power BI reporting, operational dashboards and cost reporting for finance and operations teams — built to your data, not a generic template.
More on reporting
Partners
Working behind consultancies and CRM/ERP implementers: we prepare and clean client data so migrations and reports land on time.
More on working with partnersWhere this work shows up
The same problem turns up in very different organizations: data that arrives messy and has to become something people can rely on.
-
Technical & regulated reporting
Monitoring, lab and field data rebuilt by hand every reporting cycle.
Sectors: Environmental & technical consulting · Mining · Utility contractors · Food processing
This is where most of our delivered work is.
Compliance reporting -
Product & supplier data
Supplier catalogues and item records in every format, none of them matching.
Sectors: Wholesale distribution · Manufacturing · Retail
-
CRM & ERP migration preparation
Legacy client, member or donor records too messy to migrate on schedule.
Sectors: Implementation partners · Associations · Nonprofits · Donor CRM consultants
Working with partners -
Multi-location reporting
Location reports that don't line up, so nobody can compare them.
Sectors: Franchises · Logistics · Hospitality
Before, after, and what couldn't be fixed
Worked example, synthetic data: eight supplier lines in, five clean rows out, three exceptions with a reason each.
Before 8 rows
| # | SKU | Supplier | Item | Qty (as sent) |
|---|---|---|---|---|
| 1 | 1042 | Supplier A Ltd. | Hex bolt M8 x 40, zinc | 100 ea |
| 2 | SKU-1042 | SUPPLIER A LTD | HEX BOLT M8X40 ZN | 1 box/100 |
| 3 | SKU-2210 | Supplier B | nitrile gloves L | 12 dozen |
| 4 | sku_3305 | supplier b | Safety glasses - clear | 24 pcs |
| 5 | SKU-4410 | Supplier C Inc | Cable tie 200mm | 1,000 EA |
| 6 | SKU-5120 | Supplier C Inc. | Duct tape 48 mm | 2 cs |
| 7 | SKU-6?01 | Supplier D | Work light, LED | 6 ea |
| 8 | SKU-7002 | Supplier-A | Shop towels | 6 rolls |
After 5 rows
| SKU | Supplier | Item | Qty | Unit |
|---|---|---|---|---|
| SKU-1042 | Supplier A | Hex bolt, M8 × 40, zinc | 100 | ea |
| SKU-2210 | Supplier B | Nitrile gloves, large | 144 | ea |
| SKU-3305 | Supplier B | Safety glasses, clear | 24 | ea |
| SKU-4410 | Supplier C | Cable tie, 200 mm | 1000 | ea |
| SKU-7002 | Supplier A | Shop towels | 6 | roll |
Exceptions 3 rows
| Row | SKU | Status | Reason |
|---|---|---|---|
| 2 | SKU-1042 | Flagged | Duplicate of row 1 once the box of 100 was converted to 100 ea. Kept once. |
| 6 | SKU-5120 | Flagged | Quantity given in cases ("2 cs"), and the case size isn't on the item record. Not guessed. |
| 7 | SKU-6?01 | Flagged | SKU not in the item master. Not guessed. |
Table 1 of 3 · swipe for the next