|
 |
21Tech, LLC
1390 Market Street, Suite 1202
San Francisco, CA 94102
Phone: 1-415-355-9090
Fax: 1-415-355-9095
Contact contact@21tech.com
|
|
 |
|
 |
Data Warehousing |
|
|
Data Warehousing projects are typically complex and resource intensive. The nature of pulling data from disparate sources, aligning the data and merging into a reportable format can be a challenge. It not only requires expertise with the technology but an ability to align the information to meet long-term business needs. Once the data is integrated, the benefits of being able to report and act on the information in a timely manner are tremendous. A few of the key factors in a successful warehousing solution are:
Expert Advisory Service
21Tech consultants bring multi-industry knowledge and expertise and provide complete DW services from project planning, architecture design to successful deployment. We will partner together and make sure that you are aware of Data Warehousing implementation best practices and Roadmap. We can help you to establish the right direction of bringing your mission-critical business information to one place, so you could leverage the correct, quality data and make confident decisions.
Planning and Design
Plan for a process that ensures the users requirements are understood fully – and determine a custom process that is iterative or sequential based on their needs.
Prepare for the detail-level information-gathering sessions by reviewing and making notes on the key business and architectural information that was generated in the Business Case Development, Business Question Assessment, and Architecture Review and Design stages or projects, respectively.
Business information and technical requirements need to be defined and refined at a level of detail sufficient for populating the Data Warehouse one subject area at a time and making its contents accessible to users. Conduct a series of focus sessions and supplemental interviews with the business users, as needed, for the subject area to be implemented during this population cycle of the Data Warehouse, and develop a detailed list of business and technical requirements for the current population project. The objective of the sessions and interviews is to zero in on the precise data that will provide users with answers to the subset of business questions identified for this iteration. It is also to further identify special application and technical requirements that will permit users to access the data they need when they need it, to produce what they need, so that the iteration development project can be effectively designed to meet user expectations.
Integration
Once the Planning and Design stages are complete, the necessary hardware, software and middleware components are purchased and installed, the development and test environment is established (in parallel or sequentially), and the configuration management processes are implemented. Specific applications are developed to extract, cleanse, transform and load the source data and to periodically refresh the existing data in the Warehouse, and the programs are individually unit tested against a test database with sample source data. The source data may come from a variety of disparate locations. Metrics are captured for the load process. The metadata repository is loaded with transformational and business user metadata. Canned production reports are developed and sample ad-hoc queries are run against the test database, and the validity of the output is measured. User access to the data in the Warehouse is established. Once the programs have been developed and unit tested and the components are in place, system functionality and user acceptance testing is conducted for the complete integrated Data Warehouse system. System support processes of database security, system backup and recovery, system disaster recovery, and data archiving are implemented and tested as the system is prepared for deployment. The final step is to conduct the Production Readiness Review prior to transitioning the Data Warehouse system into production. During this review, the system is evaluated for acceptance by the customer organization.
All Factors of Testing
In preparation for transitioning the system into production, we will implement and test the Data Warehouse support activities of backup and recovery, disaster recovery, data archiving, and security enforcement – in addition to the several levels of testing of the Data Warehouse application itself. At the conclusion of this final round of testing, we generally conduct a review of the pre-production Data Warehouse with the Executive Sponsors, IT and Business Managers, and Stakeholders to validate that the Warehouse is ready to be put into production. |
| |
|
|
|
