Business processes and rules
Invoicing
- Source document
Retrieve invoice information in PDF format.
- Excel tracking
Reenter the reference, dates, and amount due.
- Sending and tracking
Send to the customer and track payments.
Stated need: a monthly view of invoices processed and paid.
Hotel rates
- Approved offer
Rates and terms approved by sales.
- Duplicate entry
Enter data in the business tool and recreate tracking in Excel.
- Analysis
Send to management accounting; history is difficult to reconstruct.
Stated need: retain price changes to analyze sales.
Shared metrics
- Event
Distinguish bookings, services, invoices, and payments.
- Business rule
Specify the date, amount before / after tax, cancellations, and scope.
- Check
Reconcile the total with its details and source.
Recommended rules for comparing figures with matching definitions.
Recommended target architecture
Business sources
Bookings, sales, invoices, and files.
Bronze · raw data
Retain received data and its provenance.
Silver · prepared data
Check, standardize, and reconcile reference data.
Gold · business data
Apply definitions for analysis and applications.
Findings and responses
FindingResponseScope
FindingDuplicate entry and intermediate files
ResponseDocument sources and transformations before automating.
ScopeReduce avoidable handling — impact to be measured after implementation.
FindingInconsistent definitions
ResponseAssign a business rule and an owner to each metric.
ScopeMake comparisons explainable.
FindingIncomplete history
ResponsePlan to retain pricing and reference data history.
ScopeEnable analysis of changes — recommended target.