| Business | Scenario | Solution | Results |
|---|---|---|---|
| Channel Sales | Poor understanding of sales channel costs | Implemented reporting solution consolidating multiple sources of data into “single version of the truth”. | $500k cost saving in channel supply chain. |
| Computer Systems Sales | Little visibility of cross-sold products.
Business worried it was missing opportunities. |
Consolidated product data into reporting solution – identified groups of cross-sold products | 25% increase in product sales. Sales and marketing strategy changed to focus on bundled products. |
| Wholesaler | Sales management spending significant amount of time preparing reports. | Consolidated customer, product and rep data into Excel friendly BI solution. | 90% improvement in efficiency |
| IT Distributor | Key measures skewed towards financial goals. | Worked with business to develop “Business Fundamentals” approach and set targets and measures for key processes. | Improvement in key supply chain metrics – inventory holdings, months of supply and delivery turnaround. |
| Accounting Firm | Month end processing of base data for accounting allocation took 8 hours. | OLAP Reporting solution used to consolidate detail data. | Reduced prep time from 8 hr to 1 hr. |
| IT Sales Organisation | No user (200+users) confidence in new reporting system.
Inaccurate reports generated across multiple functions. Users wasting days creating and reconciling reports. |
Took ownership of new system.
Created key reports. Trained users in report generation. |
90% improvement in reporting preparation.
Restored confidence in reporting system for : |
| Financial Services Firm | Detailed account reconciliations taking 5 days | Taught users advanced Excel functions. Took grunt work out of reconciliations. | Reconciliation time reduced by 80% to 1 day . |
| Computer Sales Organisation | Month end reporting to sales management took 10 working days. | Implemented Excel friendly BI solution to integrate many sources of data required for report. | Preparation time reduced from 10 days to 1 day. |
