|
|
With experience
across diverse applications and systems*, we can analyze
complete populations of master and transactional data that
span years and come from different sources. As your systems
continue to grow, in number and in reach, capturing more and
more data, two fundamental needs persist:
1. Business Intelligence: the capability to produce
flexible, on-demand management reports that summarize and
isolate information in new ways for decision making
2. Monitoring: the capability to monitor the quality
of your data as it is stored, processed, and transferred to
related systems
**Sample Analyses Include**: |
|
|
|
|
|
| |
|
Business Intelligence |
|
Monitoring |
|
Strategic Sourcing |
|
> Analyze procurement dollars
by major categories and services |
|
> Isolate spend categories for
savings opportunities, e.g. where high
numbers of suppliers are used, or where
variable procurement practices exist across
divisions |
|
|
|
|
Sales Analysis |
|
> Perform regression analysis
to analyze complex purchasing trends |
|
> Assess sales trends by
region, division, product, etc. over any
interval of time |
|
> Generate profitability
reports by sales person |
|
|
|
|
Due Diligence |
|
> Sort, stratify, and
summarize historical data across systems and
tables |
|
> Recalculate margins,
depreciation, and search for related party
transactions |
|
|
|
|
Customer Relationship
Management |
|
> Identify customer
acquisition and retention costs |
|
> Sample and aggregate
customer information via internet POS data,
surveys, and other collection points |
|
|
|
|
|
|
Master Data and System
Archival |
|
> Report on key system table
statistics, e.g. invalid data per business
rules, missing data, invalid data per field
technical definition |
|
> Validate data prior to,
during, or after major system event,
including system conversion/implementation,
data rationalization and standardization |
|
|
|
|
System Processing |
|
> Recalculate and verify key
equations and logic used by systems, e.g.
match GL detail to GL summaries |
|
> Identify adjustments in
high-risk system modules, e.g. general
ledger reversals to inappropriate accounts,
overuse of default vendor codes,
inappropriate application of taxes |
|
|
|
|
Warehouse, Application, and
Network Interfacing |
|
> Validate data warehousing
against source system data feeds |
|
> Compare current application
query procedures and results to source data
analysis and re-query |
|
> Verify data sent across
interfaces equals data captured by receiving
application |
|
|
|
|
|
|
|
|
|
|
|
|
