| Business Intelligence,
Benchmark Computing & Dashboard |
|
| The Client |
|
| Global Marketing Communications
Organization: Deployed for Fortune 100 Media
Company |
|
| The Need |
|
| The Client required a
systematic solution to computerize their customer
data analysis facility for web site
advertisement placements. This requirement necessitated
development of a business Intelligence tool
with data warehouse capabilities. To meet this
requirement the Client created a tool within
the Digibase environment that presenting data to a Dashboard.
However this solution required manual manipulations. |
|
| The Challenge |
|
| The Digibase tool benchmarking
and Dashboard functions were not acceptable to
the users as it lacked the capability to create extensions to existing
applications and architectural documentation
was not available. New modules were required to operate
with the existing version and deployment. |
|
| Key challenges included : |
|
| |
|
|
Data
Ingestion : Existing modules were incomplete
and undocumented. |
|
| |
|
|
Benchmark Computations : No capability for multi-year benchmarking of earlier data. |
|
| |
|
|
Dashboard : No comparisons on multi-year benchmarks (Except basic Report Set) |
|
|
| The Solution |
|
| The Star Knowledge Technical
Team developed application extensions within
the existing Digibase tool with MS IIS Webserver and MS SQL servers as underlying
components. Existing source code were
analyzed and new extensions created to fit with
the existing code. Testing included the development
environment and testing in a staging environment
to ensure production capabilities and user acceptance. |
|
| Solution work effort included : |
|
| |
|
|
Data
Ingestion : Source data files
containing performance information were
analyzed
and existing modules were modified to
populate them to the application as required. |
|
| |
|
|
Benchmark Computations : Based on several years of data, metrics were developed as the benchmark. |
|
| |
|
|
Dashboard Development :
Introduction of multi-year benchmark
computations required comparison
with current performance data and reported
based on user needs. |
|
|
| Benefits |
|
| The key benefits realized as a result of the successful project include : |
|
| |
|
|
Provided
Client quicker access and analysis performance
information resulting in more timely
and effective web ad purchases. |
|
|
|
|
