Datum Advisory
Excel, Power Query and business reporting support
Reports should help people understand what is happening and decide what to do. Datum helps with the data, definitions and tools behind them, from a troublesome workbook to a set of connected operational reports.
When reporting becomes a job in itself
You might spend hours combining exports, struggle to reconcile figures or rely on a workbook that only one person understands. Information may be available in the ERP but difficult to use at the level your team needs.
I investigate the sources and the business meaning of the data before developing the output. That includes discussing exceptions and agreeing how ambiguous records should be treated.
Practical help with data and tools
- Investigate, recover and improve existing Excel workbooks.
- Connect and transform data using Power Query.
- Build Excel data models and Power Pivot analysis.
- Develop Access applications and operational information tools.
- Combine transactional information with agreed reference data.
- Clarify measures, definitions and data quality issues.
- Provide training, explanations and handover appropriate to the users.
Make the information usable
Tools can include a managed refresh button with progress and completion feedback, error handling, consistency checks, defined filters and different views of a shared dataset. Layouts, colours and guidance can be kept consistent so that users know what to expect.
Selected applications can also support comments and controlled write-back. Multi-user use, editing rights and update arrangements are designed for the particular application.
An interim solution with a clear purpose
There are times when a focused tool can improve visibility while a wider systems programme progresses. We establish what it will do, which system owns the underlying records and how it will be maintained.
This could provide more detailed access to existing ERP information, reduce manual reporting or support a specific planning activity.
What we could agree to deliver
A repaired workbook, a repeatable report, a documented data pipeline, an operational application or an assessment of what the available data can reliably support.
