QUANTIFIED MECHANIX : Twin Cities Business Intelligence

BI Worldwide, the Business Improvement Company, produces measurable results by helping clients solve employee, sales channel and consumer marketing challenges.

The Problem:
Existing client critical performance data was difficult to deliver and new information delivery was difficult to develop with existing systems. Data volumes exceeded current solution.

Bottom Line:
Quantified Mechanix designed and delivered a solution to allow BI to meet and exceed the needs of their clients, while accommodating for future growth and keeping current with existing tools.

Upgrading performance, protecting client base.

BI Goals

Create a self service Business Intelligence environment to segment customers, track enrollments, track and measure promotions, and compare performance across clients.
Increase existing report delivery performance.
Reduce labor to maintain and support existing solution.
Reduce risk of failing to meet contractual agreements.
Maintain Cognos support by upgrading existing environment.

Quantified Mechanix Strategy & Tactics

Develop a method for promotional analysis and structure data to support efficient promotional reporting.
Design and deliver a total data solution to meet the needs of existing and future reporting needs.
Upgrade existing environment.

The Solution

Quantified Mechanix designed and delivered a functional automated reporting database. We built into the database a delta method to measure promotional performance and designed the capability to report on all levels of data including transactional detail. Finally, we performed Cognos upgrade to improve support.

Results:

Enhanced performance on existing report functions allowing BI to meet existing contractual agreements.
Automated delivery of new promotional performance reporting.
Capacity to grow with the data.
Continuing support with Cognos.