Data Warehouse Development
Web-based Report Services
|
GST
has extensive experience in the areas of Data Warehouse
Development, Information aggregation, Data Scrubbing
and Internet Accessible Customized Reports.
A recent success involves a countywide law enforcement
agency. GST was up to the task, and developed a successful
model involving the following components:
| - |
Creation of a countywide Oracle© Crime
Incident Data Warehouse© |
| - |
Aggregation of additional Statistical Datasets
for crime analysis and other demographic data
|
| - |
Development of a customized Visual Basic©
Data Scrubbing Application that cleans dirty
demographic data (license plates in street address,
wrong city, incorrect name spellings, etc.)
and adds geo-coded data elements to all crime
incidents |
| - |
Creation of customized Incident Reports that
are web-accessible via standard browsers such
as Internet Explorer |
|
|
GST
Data Warehouse & Web-based Reporting Services include: |
 |
Database development
in Oracle©, SQL-Server©, others |
|
SQL programming,
stored procedures, triggers, etc. |
|
Data
Flow Modeling (Database mapping, charts and ER-diagrams) |
|
Customized
report development |
|
Web-based Report
Information Server configuration & maintenance |
|
Data scrubbing
and cleansing |
|
Data geo-coding
services |
|
Integration
of statistical data warehouses and other customized databases |
version 5.5 or later or Netscape's Navigator 
version 6.0 or later
