General
Our Excel-based solutions fall into the following broad categories:
- Automation of existing manually created reports, to reduce report creation time, and eliminate errors
- Creation of new reports & dashboards: - To support ad-hoc reporting needs
- Creation of custom tools to supplement your existing business management software and databases.
- To improve internal processes
- To support strategic corporate initiatives, such as a balanced scorecard
We typically use data extracted from your corporate databases or data warehouse. In addition, we can use data from other sources (such as Excel files, text files or extracted from a web site). If your business utilizes SharePoint (internal or externally hosted), Excel reports and dashboards can be saved or published to SharePoint, and viewed via Excel or a web browser.
Some Typical BIExcel Report Solutions
These solutions can be used on a standalone basis or integrated to support business initiatives such as Balanced Scorecard, ISO9000, Six Sigma, Lean, etc.
Executive Management: Via a single page dashboard view, see the health of your company via Key Performance Indicators (KPI), past performance trends, and current performance against targets. For further details see:
Business Dashboard 
Customer Service: Provide your customers with monthly performance reports – order summaries, product return rates, and on-time delivery statistics. A powerful customer relationship tool. For further details see:
Quality Metrics & Reporting
Sales Commissions: Automatically compute complex sales commissions and generate commission reports for payroll processing and sales personnel. For further details see:
Sales Commission Processing
Sales Order Management: Sales revenue, bookings, and backlog data are summarized and filtered to any level of detail required. Reports show overall revenue by date (monthly, quarterly, yearly) and can be further broken down by customer, product, product family, or territory. For further details see:
Sales Reporting
Product Quality: We can provide return rate and failure rate (MTBF) calculations as well as industry standard (ISO 9000, TL9000) data reports. For further details see:
Quality Metrics & Reporting
Custom Tools
Examples of custom tools we have created include:
- Electronic Traveler – Entry forms and database associated with recording unit data during manufacturing flow, including automatic unit ID generation (serial number, MAC address for Ethernet based devices).
- Manufacturing Test Data – Forms and database for electronic storage of test results data.
- System Configurator – Comprehensive tool designed for telephone central office equipment, including configuration, pricing, and manufacturing - used by sales, engineering, and manufacturing personnel.
Contact us with your needs - we can create a solution for you.