Reverse engineering

Rotterdam loading weather… Sicily (Catania) loading weather… From the Maas to Mount Etna: about 1,800 km as the crow flies
← All services
Services

Reverse engineering

Existing BI environments often grow organically. After years of changes, nobody knows exactly how a figure in a report is produced. With reverse engineering we map an existing solution completely, so you regain control of your data.

When does reverse engineering make sense?

  • The original developer has left and documentation is missing or out of date.
  • Reports produce unexpected or contradictory results.
  • You are facing a migration, rebuild or model change and need to know exactly what is running.
  • A proof of concept has quietly become the production environment.

Our approach: two directions

  • Bottom-up: we start with the source data and follow every transformation up to the reports.
  • Top-down: we start with the reports and trace every figure back to its source.

Combining both directions gives a complete and verifiable picture of the data flow from source to report.

What you receive

  • An overview of sources, tables, transformations and dependencies.
  • Insight into bottlenecks, risks and duplicated work.
  • Concrete recommendations for restructuring or a new data model.
  • The findings in Excel, Word or PowerPoint, tailored to your organisation’s level of knowledge: from administrator to board.

Reverse engineering is often the first step towards a future-proof data model. Read more about data modelling and migration.

Get more out of your data?

Get in touch for a no-obligation introduction.

bi-Wooning B.V. · Data warehousing, BI and Sat-Impactcheck · About bi-Wooning Chamber of Commerce (KvK) 90678370