Examples of Flagship Insight Data Monitoring
The following is a small selection of real-world scenarios which illustrate some
of the benefits of proactively monitoring data using Flagship Insight.
Business Problem: If a retail replenishment process fails, stores may run low
or out of stock resulting in empty shelves and lost sales.
- Flagship Insight Test: Check the store
replenishment data required by the process has arrived at the expected time.
- Flagship Insight Actions On Test Failure:
- Retrieve previous day’s store sales information and email
that information to the Merchandising team.
- Alert the IT support team to the problem including available
error information to aid their investigation of the issue.
- Alert the warehouse team to possible delays in the process.
- Business Benefit: A manual replenishment
can be created based on the previous day’s store sales information.
Business Problem: there is a risk of losing or duplicating data, importing poor
quality data or replicating poor quality data across integrated systems during a
data integration or migration project.
- Flagship Insight Tests: Checks for data
quality issues such as, address records without a post code, missing data that is
mandatory in downstream applications, outdated or duplicated data.
- Flagship Insight Actions On Test Failure:
- Retrieve the full record(s) containing the invalid data and
email that information to the team responsible for that data.
- Alert the IT support team to the problem to allow them to
mitigate any knock-on effect.
- Business Benefit During a data migration
project, using Flagship Insight to regularly vet your organisation's data enables
the business to:
- Identify and remove data issues that could cause migration
or integration projects to fail.
- Prepare data for migration in a manageable, controlled and
iterative way in the run-up to UAT and go-live.
- Set up a series of data quality checks once that will automatically
incorporate new and modified data in the monitoring process. This becomes particularly
relevant for long running migration projects where data is changing in the time
leading up to the go-live.
Business Problem: If there are delays in processing the queue of website orders
in a multi-channel retail environment, those orders may be delayed or at worst,
not fulfilled. Meanwhile, warehouse stock levels do not reflect the unprocessed
website orders, potentially resulting in delayed or unfulfilled orders across other
channels.
- Flagship Insight Test: Check the size
of the web orders message queue (MSMQ) on a regular basis to ensure it is within
an expected range.
- Flagship Insight Actions On Test Failure:
- Alert the IT support team to the problem including the web
message queue count and any error information that will assist their investigation.
- Retrieve the detailed web orders information from the website
database and include that information in the alert email sent to the IT support
team.
- Alert the warehouse manager to possible delays in the process
including the number of delayed orders yet to be processed by the Distribution Centre
(DC) team.
- Business Benefit: Early warning allows
the business to:
- Minimise delays to customer orders.
- Minimise the back log to be handled by the warehouse/DC
- Avoid compounding the initial problem through over-allocation
of stock.