Data Warehousing

Proven Products and Methodology

Patti Barney, Associate Vice President of Information Technology at Broward Community College says:

"We can now easily transfer ADABAS data to ORACLE for business intelligence and Web applications, while continuing to benefit from our robust, high-performance ADABAS-based OLTP administrative applications. We use several purchased packages written specifically for ADABAS, and we can now have confidence that these packages will continue to serve our needs well into the future."

However, success in BI projects requires more than technology; it requires a proven methodology.

To assist customers in leveraging our products for successful BI initiatives, TSI has allied with Earl Hadden, a world-renowned authority in the data warehouse movement. Earl is co-developer of the Hadden-Kelly Data Warehouse Method, the most widely used methodology for the development of data warehouses, data marts and BI solutions. Known for his pragmatic, business-driven approach, Earl has worked with over thirty-five organizations in seventeen countries to help significantly improve business performance through the application of advanced management concepts and information technology. He is a member of the Data Warehouse Network Editorial Advisory Board, the Patricia Seybold Group Business Intelligence and Data Warehouse Advisory Panel, and the Digital Consulting Data Warehouse Advisory Board. Earl’s worldwide seminars have been sponsored by Digital Consulting Inc., Technology Transfer Institute, IIT, SPL, Ni-Tech, NCR, Digital Equipment Corporation, Oracle Corporation, BBS International, Business Objects, Prism Solutions, Informix, Aonix, Silicon Graphics, Carleton Corporation, Sybase, Software AG, the Data Warehouse Institute, and the Data Warehouse Network.

The Hadden-Kelly Method fosters project success by delivering:

• A solution aligned with business strategy
• An architecture or “blueprint” to ensure integration
• Application of both business and technical expertise
• A solution that is constructed incrementally, with each increment delivering a significant, measurable business benefit
• Fast and focused development

TSI provides expert consulting services utilizing the Hadden-Kelly Method to help you achieve your business intelligence goals.

The method is divided into four phases...

2. Planning - an eight to twelve week activity that focuses on specific business objectives, organizations, locations, and data. The planning phase delivers an infrastructure blueprint that describes the technology components required to deliver information to those who need it, where they need it and when they need it. It also delivers a detailed implementation plan that describes the 90 - 120 day projects to build the Warehouse and/or Data Mart.

3. Building - this phase constructs part of the Warehouse (or a Data Mart or both) that meets a specific business objective. It includes mapping source data to the Warehouse model, defining and building the extract and transformation processes, analyzing data quality and availability, fixing problems as necessary, building the central Data Warehouse, defining and populating a Data Mart if necessary, and building data exploitation applications as required to meet the need of the business. The building phase is iterative and is performed in 90 - 120 day time boxes.

4. Operating - as an ongoing activity we must provide training and support, periodically refresh data in the Warehouse and/or Data Mart, conduct backup/recovery and archiving activities, enforce security, monitor performance against our original objective and provide enhancement as business needs evolve. Additionally, information dissemination using facilities such as publish/subscribe on the internet/intranet is provided.