The process of retrieving data and performing data analysis normally is very labor intensive. At Drayton, Drayton & Lamar, Inc. (DDL), our methodology allows our clients to efficiently retrieve and integrate data into their organization’s work flow. Thus, clients reduce labor costs while effectively and efficiently meeting mission needs.
We offer the following database services:
· Define and refine data/business requirements
· Database and data warehouse development and support
· Data extraction, transformation, and loading (ETL)
· Data analysis
· Special reports (e.g., congressional inquiries, Freedom of Information Act requests, and press inquiries)
· Technical assistance
· Technical documentation
To meet the needs of our clients, we provide a scalable data warehouse with a focus on high availability and accuracy. Our methodology facilitates the steps that enable us to assist our clients in developing a data warehouse solution. We document business requirements, identify data elements to be extracted from source systems, and document business rules for data conversion and cleansing. To increase retrieval efficiency, we develop data extraction conversion scripts and develop reports to support executive decision making. Summary tables, simple unvaried descriptive statistics, and simple graphics become extremely valuable tools for our clients.
Our clients require rapid results from the queries of data stores, and our tools allow the fastest and most reliable return of data possible. With our support, our clients extract data from data systems, conduct data analysis, create databases, and deliver timely and high quality reports. The reports created are delivered to Congress, other federal agencies, nongovernmental organizations, and the public.
Our support staff is trained in a variety of tools that adapt well to the client’s environment. These tools include, but are not limited to, databases (Oracle, SQL Server, MS Access), query languages (SQL, Visual Basic), and reports (MS Excel, MS Word, MS PowerPoint).
Please contact us for more information.
.
